cnt.Open "Provider=SQLOLEDB;Data Source=192.168.1.25;initial catalog=pubs;user id=sa;password="
解决方案 »
- 如何获取当前窗口的图片
- VB6.0调用存储过程时提示Timeout expired,以前都很正常,现在突然冒出这个问题来了,急!
- 请问如何进行图形比较(分不够另开贴给分,顶者有分)
- !!送分了送分了送分了送分了!!
- 如何把picture控件里所画的曲线图复制到剪贴板等?
- 关于验证码图片转数值技术的探讨....(原创贴)
- vb的定时器有丢失数据的问题?
- 不知道timer能不能实现这个功能?
- y1g1y1(袁飞☆曾经沧海难为水,除却VB不是云☆),please come in.
- VB多线程!高手低手都请进!
- Blowfish加密算法问题求解100分不够再加
- 软件(ESee v1.30)发布,敬请批评指正。
cnt.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Data001;Data Source=Server"
cnt.Open注:其中Data001为数据库名,Server为数据库所在的服务器名称
Private Function ConnectSQLServer(ByVal ServerName As String, ByVal DataBase As String, ByVal UID As String, ByVal PWD As String, ByVal Timeout As Integer) As Boolean
Dim strConnect As String
On Error GoTo Error_ConnectServer
cn.CursorLocation = adUseClient
strConnect = "Driver={SQL Server};Server=" & ServerName & ";DataBase=" & DataBase & ";UID=" & UID & ";PWD=" & PWD & ";"
cn.ConnectionString = strConnect
cn.ConnectionTimeout = Timeout
cn.Open
ConnectSQLServer = True
Exit Function
Error_ConnectServer:
ConnectSQLServer = FalseEnd Function
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.Open ConnectString
在98里的ADO版本问题
你装MDAC试试
还有,在建立Connection时候可以用
Dim NewConn as Adodb.connection
Set NewConn = new Adodb.connection最好不用Set NewConn=CreateObject("Adodb.connection")
容易出问题!