原来的連接串:
Set wrkjet = CreateWorkspace("", "", "", dbUseODBC)
Set db = wrkjet.OpenDatabase("bank", dbDriverComplete, False, "ODBC;uid=sxciqbank;pwd=sxciqbankpwd;DSN=bank")
有许多下面的类似语句:
commandtext = "select FEE_OPERATOR_CODE,FEE_DATE from t_bank_unsend_record where decl_no='" + temp1 + "' and fee_no='" + temp2 + "'"
Set myset11 = db.OpenRecordset(commandtext)现在想改成ado連接,怎么用最方便的语句转换呢?请提供代码!!!谢谢,急啊!!!!
Set wrkjet = CreateWorkspace("", "", "", dbUseODBC)
Set db = wrkjet.OpenDatabase("bank", dbDriverComplete, False, "ODBC;uid=sxciqbank;pwd=sxciqbankpwd;DSN=bank")
有许多下面的类似语句:
commandtext = "select FEE_OPERATOR_CODE,FEE_DATE from t_bank_unsend_record where decl_no='" + temp1 + "' and fee_no='" + temp2 + "'"
Set myset11 = db.OpenRecordset(commandtext)现在想改成ado連接,怎么用最方便的语句转换呢?请提供代码!!!谢谢,急啊!!!!
Private Sub Command1_Click()
Dim cn As New ADODB.Connection, rs As New ADODB.RecordSet '连接Access:
'cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Test.mdb;Jet OLEDB:DataBase password=12345;"
'SQL连接:
混合验证方式的连接:
'cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=数据库名;Data Source=服务器别名/IP"
'集成验证的连接:
cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名;Data Source=服务器别名/IP" cn.Open
rs.CursorLocation=adUseClient'设置客户端游标
rs.Open "select * from 表 where ......", cn, 3, 2
Set DataGrid1.DataSource = rs '把记录集的记录显示到DataGrid1
End Sub
直接写个连接的函数
function DBCon() as ADODB.connection
'连接数据库
end function
替换原来的写法 另外Access的SQL语法和Oracle 有差别,需要改写SQL语法
Set db = wrkjet.OpenDatabase("bank", dbDriverComplete, False, "ODBC;uid=sxciqbank;pwd=sxciqbankpwd;DSN=bank")改为:Set db = OpenDatabase(App.Path & "\bank.mdb", False, False, "UID=sxciqbank;Pwd=sxciqbankpwd")
crycoming(瞎编)说得对,有些sql语句必须修改,Access的SQL语法和Oracle 有差别
Set db = OpenDatabase(App.Path & "\bank.mdb", False, False, "UID=sxciqbank;Pwd=sxciqbankpwd")