Option Explicit
Public conn As New ADODB.Connection
Public strConn As StringPublic Function Make_Connection() As Boolean On Error GoTo err: 'strConn = "driver={SQL Server}; server=david; uid=sa; pwd=sa; database=pub" 'strConn = "Provider=SQLOLEDB.1;Persist Security Info=true;Uid=sa;Initial Catalog=pub;Data Source=david" 'strConn = "Driver={SQL Server}; Server=david; Address=192.107.2.13,1433; Network=dbmssocn; Database=pub; Uid=sa; Pwd=sa;" 'strConn = "Driver=SQLOLEDB.1;Server=david;Address=192.107.2.13;Network=domain4-4;Database=pub; Uid=sa;Pwd=sa;"
strConn = "Driver={SQL Server}; Server=david; Uid=sa; Pwd=sa; Database=pub"
'strConn = "Provider=SQLOLEDB.1; Server=david; Uid=sa; Pwd=sa; Database=pub;" 'strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=david"
conn.Open strConn
Make_Connection = Trueerr:
Make_Connection = False
err.Clear
End Function
以上的每个连接都尝试过了,但是就是不能连接上去.请问还需要那里设置还是语句本身有问题呢?分数不多,敬请赐教!
Public conn As New ADODB.Connection
Public strConn As StringPublic Function Make_Connection() As Boolean On Error GoTo err: 'strConn = "driver={SQL Server}; server=david; uid=sa; pwd=sa; database=pub" 'strConn = "Provider=SQLOLEDB.1;Persist Security Info=true;Uid=sa;Initial Catalog=pub;Data Source=david" 'strConn = "Driver={SQL Server}; Server=david; Address=192.107.2.13,1433; Network=dbmssocn; Database=pub; Uid=sa; Pwd=sa;" 'strConn = "Driver=SQLOLEDB.1;Server=david;Address=192.107.2.13;Network=domain4-4;Database=pub; Uid=sa;Pwd=sa;"
strConn = "Driver={SQL Server}; Server=david; Uid=sa; Pwd=sa; Database=pub"
'strConn = "Provider=SQLOLEDB.1; Server=david; Uid=sa; Pwd=sa; Database=pub;" 'strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=david"
conn.Open strConn
Make_Connection = Trueerr:
Make_Connection = False
err.Clear
End Function
以上的每个连接都尝试过了,但是就是不能连接上去.请问还需要那里设置还是语句本身有问题呢?分数不多,敬请赐教!
你把SQL的密码设为空在试试看,万一不行用ADODC用鼠标界面连接一下看,看自动生成的代码,复制过来就OK
控制面板-管理工具-数据源(ODBC)-系统DSN-添加-选“Sql Server”-按“完成”-输入“名称”和“服务器”,下一步-选“使用用户输入登录ID...”,然后单击“客户端配置”-“网络库”选“TCP/IP”,按“确定”,然后一路下一步就好了。
不然每次都执行err了,当然错了
Public conn As New ADODB.Connection
Public strConn As StringPublic Function Make_Connection() As Boolean On Error GoTo err: 'strConn = "driver={SQL Server}; server=david; uid=sa; pwd=sa; database=pub" 'strConn = "Provider=SQLOLEDB.1;Persist Security Info=true;Uid=sa;Initial Catalog=pub;Data Source=david" 'strConn = "Driver={SQL Server}; Server=david; Address=192.107.2.13,1433; Network=dbmssocn; Database=pub; Uid=sa; Pwd=sa;" 'strConn = "Driver=SQLOLEDB.1;Server=david;Address=192.107.2.13;Network=domain4-4;Database=pub; Uid=sa;Pwd=sa;"
strConn = "Driver={SQL Server}; Server=david; Uid=sa; Pwd=sa; Database=pub"
'strConn = "Provider=SQLOLEDB.1; Server=david; Uid=sa; Pwd=sa; Database=pub;" 'strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=david"
conn.Open strConn
Make_Connection = True
Exit Function ' -------------------------->加在这里哦
err:
Make_Connection = False
err.Clear
End Function
你可以先在控制面板里创建一个ODBC数据源,里面有测试连接,看看能否能正常连接。╭═══════════════════╮
║ 免费的源码、工具网站,欢迎大家访问!║
║ http://www.j2soft.cn/ ║
╰═══════════════════╯