Link to home
Start Free TrialLog in
Avatar of sid20vt
sid20vt

asked on

Roll out ODBC link to windows clients

Hi,

I need to roll out ODBC links to SQL database for xp clients in a 2000 AD domain.
Is there anyway I can do this via GPO or a startup script?

Thanks.
Avatar of MrLonandB
MrLonandB

http://www.enterpriseitplanet.com/resources/scripts_win/article.php/3089341

The document contains an example of a VB Script for ODBC Connections to SQL. You could place the script in a GPO: User Configuration > Windows Settings > Scripts (Logon/Logoff).
Avatar of sid20vt

ASKER

That vb script works to create a new connection but if one already exists by the same name it cannot modify it.  I couldnt find a way of deleting the existing connection first and then creating a a newone using the above vb script.

So I've done it using KIX script and can use it to modify an existing registry key but, the default connection can be one of three different ones.  
There is another registry key which gives the default connection being used but the first 4 characters of the registry key value are not needed.

Is there a kix command which looks at the registry key and returns the value from the 5th character onwards?  Like the Left and Mid functions in excel?

Avatar of sid20vt

ASKER

Or an addition to the vb script which will check for an existing connection and delete it if it exists.

So the odbc connection gets created everytime time the machine starts up but at least its the correct one!
ASKER CERTIFIED SOLUTION
Avatar of sid20vt
sid20vt

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial