菜菜鸟欲连接sql server服务器,可是有错.请高人指点.Option Explicit
Public cn_dk As New ADODB.Connection
Public rs_dk As New ADODB.Recordset
Sub main()cn_dk.ConnectionString = "uid=client;pwd=client;driver={SQL Server}; server=wwwjdec ;database=testtab"
cn_dk.ConnectionTimeout = 30
cn_dk.OpenSet rs_dk.ActiveConnection = cn_dk
rs_dk.CursorLocation = adUseClient
rs_dk.CursorType = adOpenStatic
rs_dk.LockType = adLockBatchOptimisticForm1.ShowEnd Sub执行时,总出错.
错误为>>>>>>>>>>
编译错误:
用户定义类型未定义
Public cn_dk As New ADODB.Connection
Public rs_dk As New ADODB.Recordset
Sub main()cn_dk.ConnectionString = "uid=client;pwd=client;driver={SQL Server}; server=wwwjdec ;database=testtab"
cn_dk.ConnectionTimeout = 30
cn_dk.OpenSet rs_dk.ActiveConnection = cn_dk
rs_dk.CursorLocation = adUseClient
rs_dk.CursorType = adOpenStatic
rs_dk.LockType = adLockBatchOptimisticForm1.ShowEnd Sub执行时,总出错.
错误为>>>>>>>>>>
编译错误:
用户定义类型未定义
然后在form上拉一个adodc
就是 cn_dk As New ADODB.Connection 这里出错了~~
我加上adodc就好了.但是,我希望是直接代码联,不安装任何额外的控件.不可以么?我记得好多种连接数据库的方法.可是,我都是稀里糊涂的.能给小弟额外举几个例子么?例如ado,dao,odbc,等等.谢谢了.
请看小弟这个代码,是连接本地access的.这个算是哪种连接方式呢?Option Explicit
Public adoCnn As New ADODB.Connection
Public adoCmm As New ADODB.Command
Public adoRec As New ADODB.RecordsetSub main()
adoCnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\testdb.mdb;Persist Security Info=False"
adoCmm.ActiveConnection = adoCnn
adoCmm.CommandType = adCmdText
Form1.Show
End SubPrivate Sub Form_Load()
adoCmm.CommandText = "select * from tab1"
Set adoRec = adoCmm.ExecuteEnd Sub
Public rs_dk As New ADODB.Recordset
Sub main()cn_dk.ConnectionString = "uid=client;pwd=client;driver={SQL Server}; server=wwwjdec ;database=testtab"
cn_dk.ConnectionTimeout = 30
cn_dk.OpenSet rs_dk.ActiveConnection = cn_dk
rs_dk.CursorLocation = adUseClient
rs_dk.CursorType = adOpenStatic
rs_dk.LockType = adLockBatchOptimisticForm1.ShowEnd Sub=======================================
ADO的ConnectionString字符串可以用ADODC控件进行连接来得到其他的你写的是正确的
然后加上你的code就算代码连了!呵呵