Connect sql server 2005 database table from the vb6 environment

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;
or
Provider=SQLNCLI.1;Data Source=DataSourceName;User ID=useridname;Password=password;

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