Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=密码;Initial Catalog=数据库名称;Data Source=服务器名称
解决方案 »
- 我做了一个VB的登陆窗体不知道为什么说我第1句错误,求大大帮看!
- 请教一个VB中口mscomm控件问题:
- ado控件的插入的问题
- 软件项目申报的经费怎么填?有什么技巧呀?
- VB访问注册表的小问题
- 哪位大虾能给我E_mail一份odbc32.txt,用API TEXT VIEWER 可以读得
- 能用api在有背景的picture上面作图吗???
- 呵呵!谈谈初用VS.net bate2的感觉
- 怎样使一个无标题栏窗口,在任务栏上显示出来?
- 我有时觉得自己很笨!给我一个这样的原代码好吗?
- 在数据环境里设定了分组,commandtext还能被重新设定吗?
- 随机函数的问题.打开此帖者有分!!!!!!!!!!!!
dim ds As New ADODB.Connection
dim rs As New ADODB.Recordset
str"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=DATABASEname;Data Source=SERVER_Name;password="
ds.open
rs.ActiveConnection = ds
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
rs.open "select * from tablename"
dim ds As New ADODB.Connection
dim rs As New ADODB.Recordset
str="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=DATABASEname;Data Source=SERVER_Name;password="
ds.open str
rs.ActiveConnection = ds
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
rs.open "select * from tablename"
引用 ado2.6
Dim conn As New ADODB.Connection
Private Sub Command1_Click()
On Error Resume Next
pass = Text1.Text
conn.Open ("driver={SQL Server};server=(local);uid=sa;database=Master;pwd=" & pass)
If Err.Number <> 0 Then
MsgBox Err.Description & Chr(13) & "检查一下数据库是否启动,和密码是否正确", vbDefaultButton1, "错误"
conn.Close
Err.Clear
Exit Sub
Else
'可用
msgbox "可用"
End If
conn.Close
End Sub
在VB中必须安装mdac2.6及以上。引用ADO2.5以上才行。
dim ds As New ADODB.Connection
dim rs As New ADODB.Recordsetstr="Driver=SQL SERVER;SERVER=你的实例名;UID=sa;PWD=xx;DATABASE=ds"
ds.CursorLocation = adUseClient
ds.open str