vb6 on MSSQL10

Is it possible that vb6 connect to MSSQL10?
I'm trying to connect my vb6 project with MSSQL10. How to start?
Whing Dela CruzAsked:
Who is Participating?
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
Download and install the SQL Native Client 10 (if you don't already have it).  Look for 'Microsoft® SQL Server® 2008 R2 Native Client' under "Install Instructions" on this page:  http://www.microsoft.com/en-us/download/details.aspx?id=16978  Then you need to get a login for the database you want to use and put it in one of the connection strings on this page and put it in your code:  http://www.connectionstrings.com/sql-server-native-client-10-0-oledb-provider/    This page talks about using VB6 with SQL 2005 but the code should be the same for SQL 2008.  http://technet.microsoft.com/en-us/library/bb264566%28v=sql.90%29.aspx
Whing Dela CruzAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.