Pages

Friday, September 24, 2010

Creating odbc link for MS Access database simply by windows registry......

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBCL]
"Driver"="%SystemDirectory%\\odbcjt32.dll"
"DBQ"= Your MS Access database file name with full path in double quotes("")
"Description"= discription of your db in double quotes("")
"DriverId"=dword:00000019
"FIL"="MS Access;"
"SafeTransactions"=dword:00000000
"UID"=""

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBCL\Engines]

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBCL\Engines\Jet]
"ImplicitCommitSync"=""
"MaxBufferSize"=dword:00000800
"PageTimeout"=dword:00000005
"Threads"=dword:00000003
"UserCommitSync"="Yes"

[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources]
"ODBCL"="Microsoft Access Driver (*.mdb)"




*Note- copy above code in a file and save it by [.reg] extension....
replace every "ODBCL" by your "data source name" and change line 4 & 5 by instructions which are given with them....

No comments:

Post a Comment