一个关于注册 ODBC 的问题,请教高手

大家好:我现在遇到一个问题,就是在用 Access 数据库作系统打包时要注册 ODBC ,请问怎样才能注册.
---------------------------------------------------------------

这主要是写注册表的问题,你可以去分析一下hkey_local_machine/software/odbc和
hkey_current_user/software/odbc里面键值的意思。
---------------------------------------------------------------

Which mothed do you use?
if ADO,should be use directly
if ODBC, U can add a link into register just as zengmc at your packet
---------------------------------------------------------------

你可以预先写一个 odbc.reg文件,当安装完数据库第一次运行的时候运行regedit odbc.reg即可,另外,如果你使用了 dao 编程,dao模型本身就有 odbc注册功能,你可以用 注册 为关键词在帮助里面查找,我记得第3行就是 dao 模型如何注册odbc的说明
---------------------------------------------------------------

'我把我的odbc注册代码贴给你:
'我刚刚开始 access 编程的学习,希望能与你多多交流,

Private Sub RegisterDatabaseX()

Dim dbsRegister As Database
Dim strDescription As String
Dim strAttributes As String
Dim errLoop As Error

strAttributes = "Database=数据库名称" & _
vbCr & "Description=这个数据库的说明" & _
vbCr & "Server=...*"

On Error GoTo Err_Register
DBEngine.RegisterDatabase "odbcName", "SQL Server", _
True, strAttributes
DBEngine.LoginTimeout = 10
On Error GoTo 0

Exit Sub

Err_Register:

If DBEngine.Errors.Count > 0 Then
For Each errLoop In DBEngine.Errors
MsgBox "错误号为: " & errLoop.Number & _
vbCr & errLoop.Description
Next errLoop
End If

Resume Next

End Sub

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus