1. I SQL2008 can be connected with the following data:

2. But the VB connection inside the old error, to open any (test1 has built)

3. What problem, can not pass??????? Strives for the great god,,,, thank you very much,,,,

CodePudding user response:

Conn. Put a link at the end of the open strings is conn. Open the ConnectionString

CodePudding user response:

SQL Server 2008 not the Provider=SQLOLEDB this drive, should use the Provider=SQLNCLI10 or Driver={} 10.0 SQL Server Native Client, specific written below the content of the
SQL Server 2008 connection strings

CodePudding user response:

Connection SQL2008 is really not easy, I recently met question is even not under win10, seems to be said that my SQL Server Native Client version is too new, depressed,

CodePudding user response:

Conn. The ConnectionString="driver=SQL Server;=SQL server instance name; Uid=sa; The PWD=sa password; Database database name="