17857.html
来自「VB技巧问答10000例 VB技巧问答10000例」· HTML 代码 · 共 23 行
HTML
23 行
<html> <head> <title>Re: About Access97 DataBase</title> </head> <body bgcolor="#FFFFFF" vlink="#808080"> <center> <h1>Re: About Access97 DataBase</h1> </center><hr size=7 width=75%><hr size=7 width=75%><p>Posted by 大汉堡 on August 25, 1999 at 15:05:20:<p>In Reply to: <a href="17832.html">Re: About Access97 DataBase</a> posted by Fai on August 25, 1999 at 10:17:01:<p>: : OLEDB Provider:使用Microsoft Jet 3.51 OLE DB的话,将无<br>: : 法连接上,此时必须要用 MicroSoft OLEDB Provider for ODBC Drivers <br>: : 才能连上<p>: 本人用这Connection Command:<br>: ConnStr = "Provider=MSDASQL.1;" & _<br>: "DRIVER=Microsoft Access Driver (*.mdb);" & _<br>: "UID=Admin;" & _<br>: "UserCommitSync = Yes;" & _<br>: "Threads = 3;" & _<br>: "SafeTransactions = 0;" & _<br>: "PageTimeout = 5;" & _<br>: "MaxScanRows = 8;" & _<br>: "MaxBufferSize = 512;" & _<br>: "ImplicitCommitSync = Yes;" & _<br>: "FIL=MS Access;" & _<br>: "DriverId = 25;" & _<br>: "DefaultDir=D:\mdb;" & _<br>: "DBQ=D:\ESU.mdb;"<br>: 却出现Error:<br>: [Microsoft][ODBC Microsoft Access 97 Driver]<br>: General error unable to open registry key <br>: 'SOFTWARE\ODBC\ODBC.INI\(Null)' <p>: 小弟已经用了MicroSoft OLEDB Provider for ODBC Drivers<br>: 但仍出现Error,我的DataBase的UserName是Admin,而<br>: Password 是"ABCDE",请问应怎样写呢?<p>老实说,这么长的字串我并没有去看,不过你可先试着用<br>ADODC这个Control的属性去Connect,其中有一个功能可<br>以就你的ConnectionString做连接测试,若设定正确,会<br>传回连接成功的Message,如果正确的话,这个ConnectionString<br>就可用于ADO Object了,另,我刚测试了ADODC的属性用<br>MicroSoft OLEDB Provider for ODBC Drives<br>的连接方式,无论'指明资料来源'中使用'使用资料来源名称'<br>or'使用连接字串',经设定Password后,皆确定可开启<br>Connection,也就是说这两组ConnectionString确定可用<p><br><br><hr size=7 width=75%><p><a name="followups">Follow Ups:</a><br><ul><!--insert: 17857--></ul><!--end: 17857--><br><hr size=7 width=75%><p></body></html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?