Click here to Skip to main content
15,662,823 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

how to connect sql server 2005 database table from the vb6 environment.I want step to step procedure. Also, how to import sql database table to sql server 2005.

thanks in advance,

Updated 20-Mar-10 6:20am

VB^ has always sucked and has been obsolete for a decade. That's why you're having trouble finding help. Use VB.NET. It's an actual programming language.
Share this answer
Using SQL Server 2005 Express from Visual Basic 6[^]

You may need to change the connection string to;
Provider=SQLNCLI.1;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;
Provider=SQLNCLI.1;Data Source=DataSourceName;User ID=useridname;Password=password;

But if you spend some time looking through[^] you should be able to find the correct version.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900