客戶機上的注冊表中如何寫連接引數啊。
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\aQC]
"AutoStop"="YES"
"Description"="aQC"
"Driver"="D:\\PROGRA~1\\SQLANY~1\\Bin32\\dbodbc12.dll"
"UserID"="DBA"
"EncryptedPassword"="25a8c008641a8b"
"Server"="aQC"
"Host"="192.200.67.197:2372"
服務器段啟動資料庫的引數為:
dbsrv12.exe -x tcpip(PORT=2372)
客戶機端的如何寫啊?我連接不上
uj5u.com熱心網友回復:
我使用的是開發者版本。uj5u.com熱心網友回復:
if profilestring(is_app_path + '\salesystem.ini','SYSTEM PROFILE','ERGEDIT','0') = '1' thenRegistrySet( "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Anywhere 11.0","Driver", RegString!, is_app_path + "\dbms\dbodbc11.dll")
RegistrySet( "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Anywhere 11.0","Setup", RegString!, is_app_path + "\dbms\dbodbc11.dll")
RegistrySet( "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Anywhere 11.0 Translator","Driver", RegString!, is_app_path + "\dbms\dbctrs11.dll")
RegistrySet( "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Anywhere 11.0 Translator","Setup", RegString!, is_app_path + "\dbms\dbctrs11.dll")
RegistrySet( "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Anywhere 11.0 Translator","Translator", RegString!, is_app_path + "\dbms\dbctrs11.dll")
RegistrySet( "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers","SQL Anywhere 11.0", RegString!, "Installed")
RegistrySet( "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Translator","SQL Anywhere 11.0 Translator", RegString!, "Installed")
RegistrySet( "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\dbeng11.exe","path", RegString!, is_app_path)
RegistrySet( "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\dbeng11.exe","", RegString!, is_app_path + "\dbms\dbeng11.exe")
RegistrySet( "HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources","WRM", RegString!, "SQL Anywhere 11.0")
RegistrySet( "HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\WRM","AutoStop", RegString!, "yes")
RegistrySet( "HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\WRM","DatabaseFile", RegString!, is_app_path + "\dbms\sale.db")
RegistrySet( "HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\WRM","DatabaseName", RegString!, "Sale")
RegistrySet( "HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\WRM","Driver",RegString!,is_app_path + "\dbms\dbodbc11.dll")
RegistrySet( "HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\WRM","PWD",RegString!,"sql")
RegistrySet( "HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\WRM","Start", RegString!,is_app_path + "\dbms\dbeng11.exe")
RegistrySet( "HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\WRM","UID",RegString!,"dba")
setprofilestring(is_app_path + '\salesystem.ini','SYSTEM PROFILE','ERGEDIT','0')
end if
uj5u.com熱心網友回復:
上面的是本機的寫法,局域網的應該差不多,只是引數不同而已uj5u.com熱心網友回復:
樓上是本機連接資料庫的寫法吧。我看對局域網的連接沒什么參考的內容uj5u.com熱心網友回復:
給你一個參考:Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\WellSoft]
"AutoStop"="yes"
"Driver"="dbodbc8.dll"
"AutoCommit"="false"
"Language"="ZH"
"EngineName"="ASAServer"
"Commlinks"="TCPIP{}"
局域網我這樣可以連接。
uj5u.com熱心網友回復:
帳號密碼我寫在程式里面了uj5u.com熱心網友回復:
沒用處嗎,你就算是遠程連接你不配置odbc嗎?你不用dbodbc11.dll這些dll嗎?uj5u.com熱心網友回復:
我的客戶端是使用delphi和odbc連接網路資料庫,可以這樣寫注冊表:[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\jzxj]
"Driver"="D:\\機動車駕駛證申請人學籍檔案管理資訊系統\\dbodbc8.dll"
"UID"="DBA"
"EncryptedPassword"="0d3ac2a255ebe294f1f194ed57"
"EngineName"="jzxj"
"AutoStop"="Yes"
"Integrated"="No"
"Delphi"="Yes"
"Compress"="No"
"DisableMultiRowFetch"="No"
"Debug"="No"
"CommLinks"="TCPIP{host=51.17.189.215}"
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/82599.html
標籤:數據庫相關
