The system is ready for me! ODBC connection Access database ~
Release the installer to do this step! Is really can't find the ODBC example of automatic registration data source and the registry or practice
Adjure everybody to help me! ACCESS database in no OFFICE machines how to run? What a DLL and document need?
Bother everybody to help me!!!!!!! Thank you sincerely! And don't copy + paste trouble! There is a example of automatic registration data source in baidu ` of false
I want to change ~ but changed or wrong! The novice hard! Trouble master help!!!!! Making the installer software I use
Wise Installation System9.02 localization and
Setup Factory localization version 7.0 these two!
Have some specific detailed steps to trouble you! Write up! Please try to detail! When writing a tutorial! Thank you very much!
I am a newcomer few points! Please help a lot! Be very grateful!
CodePudding user response:
On the registry, if not find relevant information, you can try to export the configuration before and after the ODBC registry, compare and contrast tool (command) can use application UltraEdit or fc command,CodePudding user response:
String ls_sys []Ls_sys [1]="HKEY_LOCAL_MACHINE \ Software \ ODBC \ ODBCINST INI \ ODBC DRIVERS"
Ls_sys [2]="HKEY_LOCAL_MACHINE \ Software \ ODBC \ ODBCINST INI"
Ls_sys [3]="HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ ODBC Data Sources,"
Ls_sys [4]="HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini"
String ls_install
RegistryGet (ls_sys [1], "Microsoft Access Driver (*. MDB)", RegString! , ls_install)
If the trim (ls_install) "Installed" then
Messagebox (" error ", "Microsoft Access Driver does not setup!" )
The halt
End the if
String ls_dsn
//ls_dsn=profileString (" KJS. Ini ", "ini", "dsn_def", "")
//if len (trim (ls_dsn))=0 then
//messagebox (" error ", "the ini file error!" )
//the halt
//end if
Ls_dsn=fs_dsn
RegistrySet (ls_sys [3], ls_dsn RegString! , "Microsoft Access Driver (*. MDB)")
RegistrySet (ls_sys [4] + "" + ls_dsn, "DBQ RegString! , gs_current_directory + "\ db \ KJS MDB")
RegistrySet (ls_sys [4] + "" + ls_dsn, "Driver", RegString! , "C: \ WINDOWS \ SYSTEM \ odbcjt32 DLL")
RegistrySet (ls_sys [4] + "" + ls_dsn, FIL, RegString! , "MS Access;" )
RegistrySet (ls_sys [4] + "" + ls_dsn, "PWD", RegString! , "SQL")
RegistrySet (ls_sys [4] + "" + ls_dsn, "UID", RegString! , "dba")
Ulong lu_driverid, lu_SafeTransactions lu_driverid=25 lu_SafeTransactions=0
RegistrySet (ls_sys [4] + "" + ls_dsn, "DriverId", Regulong! , lu_driverid)
RegistrySet (ls_sys [4] + "" + ls_dsn, "SafeTransactions Regulong! , lu_SafeTransactions)
CodePudding user response:
If you don't set up the data source and two methods1. Direct connection
Don't need to configure the odbc, the SQLCA DBParm="ConnectString='DSN=MS Access Database; The PWD=password; DBQ database name='
"MS Access Database that is installed after the MDAC default had such an ODBC DSN, can use them directly,
//Profile
The SQLCA. DBMS="ODBC"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="ConnectString='DSN=MS Access Database; UID=admin; The PWD=000000; DBQ=XTKTV. MDB '
"
2. OLE DB
//Profile
The SQLCA. DBMS="OLE DB"
The SQLCA. The AutoCommit=False
SQLCA. DBParm="PROVIDER='4.0'. Microsoft Jet. The OLEDB., DATASOURCE='H: \ js. MDB'"
CodePudding user response:
Help you to the topCodePudding user response:
http://blog.csdn.net/wfliu/archive/2006/03/17/627143.aspxCodePudding user response:
Assces need not registered, directly set the sqlca canThe SQLCA. DBParm="ConnectString='DSN=MS Access Database; DBQ=yourpath/yourdb MDB '
"