SQL2000端口1433改成6000了,PB9 SQL本地接口如何连接
SQL2000端口1433改成6000了,PB9 SQL本地接口怎么连接?
SQL2000端口1433改成6000了,PB9 SQL本地接口怎么连接?
// Profile taifeng_server
SQLCA.DBMS = "MSS Microsoft SQL Server"
SQLCA.Database = "testDB"
SQLCA.LogPass = "1234"
SQLCA.ServerName = "192.168.0.1"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = True
SQLCA.DBParm = ""
没看到在哪里设置端口参数啊?
------解决方案--------------------
SQLCA.ServerName = "192.168.0.1"
为:SQLCA.ServerName = "192.168.0.1,6000"
试一下
------解决方案--------------------
servername 属性的地址加逗号加端口号就可以了.
------解决方案--------------------
C:\WINDOWS\system32\cliconfg.exe 设置TCP/IP 属性6000
------解决方案--------------------
//写注册表,为该服务名写别名
SQL2000端口1433改成6000了,PB9 SQL本地接口怎么连接?
// Profile taifeng_server
SQLCA.DBMS = "MSS Microsoft SQL Server"
SQLCA.Database = "testDB"
SQLCA.LogPass = "1234"
SQLCA.ServerName = "192.168.0.1"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = True
SQLCA.DBParm = ""
没看到在哪里设置端口参数啊?
------解决方案--------------------
SQLCA.ServerName = "192.168.0.1"
为:SQLCA.ServerName = "192.168.0.1,6000"
试一下
------解决方案--------------------
servername 属性的地址加逗号加端口号就可以了.
------解决方案--------------------
C:\WINDOWS\system32\cliconfg.exe 设置TCP/IP 属性6000
------解决方案--------------------
//写注册表,为该服务名写别名
- C/C++ code
RegistrySet("HKEY_LOCAL_MACHINE\Softare\Microsoft\MSSQLServer\Client\ConnectTo","192.168.0.1",RegString!,"DBMSSOCN," + "192.168.0.1,6000")