Connecting to SQL 2005 using VB6

Is there some reference material that shows how to connect to a SQL 2005 DB
using Visual Basic 6? Any help is appreciated.

Re: Connecting to SQL 2005 using VB6

Charlie (jadkins4@yahoo.com) writes:
> Is there some reference material that shows how to connect to a SQL 2005
> DB using Visual Basic 6? Any help is appreciated.

You find the reference for ADO on
http://msdn2.microsoft.com/en-us/library/ms675532.aspx. ADO is a piece
of crap in my opinion, but it's nevertheless the best option for VB6.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx