Automatic ODBC Creation 2

[scottyjohn]

Hi all,
I have a registry update file which I can execute to create 3 ODBC connections which I use in an access front end used for reporting.
This all works fine, except if I need to then create another linked table using one of the ODBC connections. When I create these ODBCs using the registry update, the connections work but dont appear in the ODBC manager, and therefore I cannot select them. Is there a way round this?

John
ski_69@hotmail.com

 

[jsteph]

Are you updating both sets of keys? I can't recall offhand but there's an odbcini and an odbc sub-hive. I've done the same thing and I see all of mine in the odbc dialog.
--Jim

 

[PHV]

Don't forget this key:
...\ODBC\odbc.ini\ODBC Data Sources

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[scottyjohn]

Thanks Guys,
Sorted me out just as required!

John
ski_69@hotmail.com