This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- how to register ODBC connection in a InstallScript project?
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 09, 2008
09:43 PM
how to register ODBC connection in a InstallScript project?
Now I'm working on a InstallScript project.
I want to register ODBC connection using installer(Microsoft ACCESS).
The information is all about how to do it in other kinds of project, dose anyone know how to do it in a InstallScript project??
thanks in advance
I want to register ODBC connection using installer(Microsoft ACCESS).
The information is all about how to do it in other kinds of project, dose anyone know how to do it in a InstallScript project??
thanks in advance
(4) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 09, 2008
11:17 PM
Back in the day I just installed mdac_typ and wrote out the driver and dsn info to the registry. It just worked...
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 10, 2008
12:15 AM
hi, Christopher. Thank you for your quick response.
I wrote it in this way but it still doesn't work:-(
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\test]
Default blank
DBQ C:\Project\data.MDB
Driver C:\Windows\system32\odbcjt32.dll
DriverId 0x00000019(25)
FIL MS Access;
PWD blank
SafeTransactions 0x00000000(0)
systemDB C:\Project\SYSTEM.MDA
UID admin
I can find it in registry editor, but if i check control panel--admin tools--Data Sourc(ODBC)--System DSN, it is not there.
help!
I wrote it in this way but it still doesn't work:-(
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\test]
Default blank
DBQ C:\Project\data.MDB
Driver C:\Windows\system32\odbcjt32.dll
DriverId 0x00000019(25)
FIL MS Access;
PWD blank
SafeTransactions 0x00000000(0)
systemDB C:\Project\SYSTEM.MDA
UID admin
I can find it in registry editor, but if i check control panel--admin tools--Data Sourc(ODBC)--System DSN, it is not there.
help!
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 10, 2008
12:47 AM
It's been a long time ( MSI makes me lazy and forgetfull ) so setup your DSN by hand and go into regedit and export the key.
Reimage the machine and then apply the reg file and see if it comes back. If so, migrate that over into your install. Rinse and repeat with automation.
Edit: Flashback.... your missing a registry entry value under ODBC.INI\ODBC DAta Sources that points to the DSN registry key you created.
Reimage the machine and then apply the reg file and see if it comes back. If so, migrate that over into your install. Rinse and repeat with automation.
Edit: Flashback.... your missing a registry entry value under ODBC.INI\ODBC DAta Sources that points to the DSN registry key you created.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Jul 10, 2008
01:35 AM
thank you soooooooo much,Christopher!! It works now!!!:p