PLS TRY:
Provider=SQLOLEDB;Network Library=DBMSSOCN;Password=168;Persist Security Info=True;User ID=sa;Initial Catalog=hjzw;Data Source=218.75.228.111,1433
Provider=SQLOLEDB;Network Library=DBMSSOCN;Password=168;Persist Security Info=True;User ID=sa;Initial Catalog=hjzw;Data Source=218.75.228.111,1433
俺干过的。。哈哈
你将ERROR MESSAGE TELL ME!
它提示[dbmssocn]general network error check you network docmentation
When you use ActiveX Data Objects (ADO) to connect to a SQL Server 7.0 or SQL Server 2000 server that is behind a firewall, consider the following:
1.The firewall must be configured to permit port 1433 incoming (or the port numbers that SQL Server listens to on TCP/IP), and ports 1024 to 65535 outgoing.
2.The connection string must specify the SQL Server address: the IP address, the server DNS name, or a name inside the hosts file.
3.The connection string should specify the Network Library type, in this case "dbmssocn" (without the quotes) for TCP/IP Sockets Net-Library.
WARNING: Opening up the ports on the firewall may pose security issues; consult with your System Administrator or Security Administrator to configure the firewall.
MORE INFORMATION
In the following sample code, servername should be the server DNS name, IP address, or a name inside the hosts file:
Set Conn = CreateObject("ADODB.Connection")
Set Rs = CreateObject("ADODB.Recordset")
Set Cmd = Createobject("ADODB.Command")
Conn.Open "Provider=SQLOLEDB;Password=password;Persist Security Info=True;User ID=username;Initial Catalog=DBNAME;Data Source=servername;Network Library=dbmssocn"
Cmd.ActiveConnection=ConnSQL = "Select * from TABLE"Cmd.CommandText = SQL
Set Rs = Cmd.Execute
在你那dos下用:
telnet ip地址 1433会报错吗?????????