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.
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.
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?
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?
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!
So the odbc connection gets created everytime time the machine starts up but at least its the correct one!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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).