dim conn as new adodb.connection If conn.State = adStateOpen Then conn.Close conn.ConnectionString = "driver=SQL Server;server=SQL所在计算机名或IP地址;uid=sa;pwd=sa的密码;database=数据库名" conn.CommandTimeout = 120 conn.Open
conn? 无效外部过程还得麻烦
要设好源先.你的单机还是远程?在控件面板,管理工具,数据源,增加,SQL SERVER,下一步,本机的话,服务器那里不用填,如果远程,填入SQL服务器的IP即可,下边的就是SA的密码之类的,最后点一下测试成功没有...,呵, 再按这个...肯定连上 dim conn as new adodb.connection If conn.State = adStateOpen Then conn.Close conn.ConnectionString = "driver=SQL Server;server=SQL所在计算机名或IP地址;uid=sa;pwd=sa的密码;database=数据库名" conn.CommandTimeout = 120 conn.Open
先引用Microsoft ActiveX Data Objects 2.5 Library的DLL
菜单上的工程->引用->Microsoft ActiveX Data Objects 2.5(6,7,8) Library 打钩,确定
If conn.State = adStateOpen Then conn.Close
conn.ConnectionString = "driver=SQL Server;server=SQL所在计算机名或IP地址;uid=sa;pwd=sa的密码;database=数据库名"
conn.CommandTimeout = 120
conn.Open
再按这个...肯定连上
dim conn as new adodb.connection
If conn.State = adStateOpen Then conn.Close
conn.ConnectionString = "driver=SQL Server;server=SQL所在计算机名或IP地址;uid=sa;pwd=sa的密码;database=数据库名"
conn.CommandTimeout = 120
conn.Open
打钩,确定