VMware Horizon Community
mohankc
Enthusiast
Enthusiast

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.

Reply
0 Kudos
3 Replies
DJMGWizard
Contributor
Contributor

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?

Reply
0 Kudos
mohankc
Enthusiast
Enthusiast

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.

Reply
0 Kudos
DJMGWizard
Contributor
Contributor

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.

Reply
0 Kudos