Export/import ODBC connections?

  • Thread starter Thread starter Hank Arnold
  • Start date Start date
H

Hank Arnold

I am attempting to set up a workstaiton so that anyone logging onto the
workstation will have the necessary applications working and require
some simple setup the first time they log on.

I have it so that all the installed applications are available to any
new user. The problem is that there is at least one ODBC connection
(created during an application install) that is not being created when
the user logs on. All users are doing a domain logon and are restricted
from installing *anything*.

Any ideas on how to duplicate the ODBC connection on "Al Users" or
"Default User" profiles? Or can I export something that can be imported
when the new user is logged on?

TIA,
Hank Arnold
 
For system DSNs you can use RegWrite method to create the keys/ values.
HKLM\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

and also the subkey for each DSN
HKLM\SOFTWARE\ODBC\ODBC.INI\

http://www.databasejournal.com/features/mssql/article.php/2238221
http://cwashington.netreach.net/depo/view.asp?Index=1010&ScriptType=vbscript
http://cwashington.netreach.net/depo/view.asp?Index=388&ScriptType=vbscript


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
 
Back
Top