关于VB6连接SQL数据库的问题

Question

 

我是用ADO,然后用下面的语句连接SQL的:

cn.ConnectionString = "driver={SQL Server};server=" & server & ";uid=" & uid & ";pwd=" & pwd & ";database=" & database & ""

但是ODBC连接SQL的默认方式是命名管道,我怎么用可以在代码中指定TCP/IP连接,另外怎么样指定端口号,谢谢!           

Answer 1

Connect via an IP address
Code Snippet Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
DBMSSOCN=TCP/IP. This is how to use TCP/IP instead of Named Pipes. At the end of the Data Source is the port to use. 1433 is the default port for SQL Server.

 

http://www.connectionstrings.com/?carrier=sqlserver

Answer 2

 

谢谢,解决问题了