- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Making ODBC connections persistent
We thinapp'd Office 2007 suite (with applinks to Oracle) and included ODBC administrator as an entry point so users can create ODBC connections and access data from from Oracle servers in Excel or Access. All ODBC connections are currently defined within the sandbox and we are trying to make them persistent so users don't have to re-create them every time they wipe their sandbox. Any ideas on how to make this happen?
We already tried setting the isolation mode for HKCU\Software\ODBC, HKCU\software\ODBC\ODBC.INI and HKCU\software\ODBC\ODBC.INI\Data Source to merged. It did not work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I take it you go throught your created entry point for the ODBC administrator (using a new shortcut)?
Have you tried any other isolation mode?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes. it's the virtual entry point that we go through. We tried the default isolation mode which is full. And this works as intended.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi again
I realise you set the isolation mode for those registry hives to merged - did these registry hive have any entries? If so delete these out your package and rebuild.
If they are in your package, even in merged mode the changes will be saved to the sandbox - however if they are not in your package or sandbox in merged mode they will save to the computer.