hi ,

I'm just too much worried for a database connection...
I'm using sql server2005 and VB6.0 ...
I badly need the code for the connectivity..

Thanks.

__________________
Get the will power n U will be powered

Please check the following links:

Using SQL Express from Visual Basic 6
http://msdn.microsoft.com/vbrun/vbfu...ingsqlexpress/
http://msdn.microsoft.com/en-us/libr...6(SQL.90).aspx

SQL Server 2005 is built on the .NET 2.0 Framework.

If you use a .NET language, you don't need MDAC as you just use .NET.
But for VB6, the latest MDAC contains the "compatibility tools" you need to use SQL 2005 from non-.NET.

Check the following for connection strings
http://www.connectionstrings.com/

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.