[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Roll out ODBC link to windows clients

Posted on 2007-07-25
7
Medium Priority
?
358 Views
Last Modified: 2008-05-30
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.
0
Comment
Question by:sid20vt
  • 3
4 Comments
 
LVL 19

Expert Comment

by:MrLonandB
ID: 19564829
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).
0
 

Author Comment

by:sid20vt
ID: 19573197
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?

0
 

Author Comment

by:sid20vt
ID: 19573225
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!
0
 

Accepted Solution

by:
sid20vt earned 0 total points
ID: 19591484
I've sorted this myself using Kix.

Can be closed.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to deal with a specific error when using the Enable-RemoteMailbox cmdlet to create a mailbox in the cloud-based service, for an existing user in an on-premises Active Directory.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question