Use Group Policy to set ODBC

S

Simon

Hello all,

We are running a single 2000 domain and currently manually set a db
connection on each client so they can open a connection to SQL 2005.

Is there any way to automate the ODBC connection setup using group policy?

Thanks, Simon
 
M

Mark Heitbrink [MVP]

Hi,
We are running a single 2000 domain and currently manually set a db
connection on each client so they can open a connection to SQL 2005.
Is there any way to automate the ODBC connection setup using group policy?
Click to expand...

At least one Vista Client, RSAT + GPMC and the new 943729 CSE to
handle it in "native GPO" or you can apply it with a custom ADM Template.

Both solution can not provide SQL Authentication, because the SQL driver
restricts the use of passwords by scripts.

ADM could look like this: Cahnge NameofServer + NameofDatabase
Sample of an SQL Database ODBC Connection
--------------------------------
CLASS MACHINE

CATEGORY "ODBC"

POLICY "ODBC Database"
KEYNAME "SOFTWARE\ODBC\ODBC.INI\NameofDatabase"
PART "Driver:" EDITTEXT
DEFAULT "C:\WINDOWS\System32\SQLSRV32.dll"
VALUENAME Driver
END PART
PART "Server:" EDITTEXT
DEFAULT "NameofServer"
VALUENAME Server
END PART
PART "Database:" EDITTEXT
DEFAULT "NameofDatabase"
VALUENAME Database
END PART
PART "LastUser:" EDITTEXT
DEFAULT "%username%"
VALUENAME LastUser
EXPANDABLETEXT
END PART
PART "Trusted_Connection:" EDITTEXT
DEFAULT "yes"
VALUENAME Trusted_Connection
END PART
END POLICY
END POLICY

POLICY "Data Source Typ of NameofDatabase"
KEYNAME "SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources"
PART "Databasetyp NameofDatabase:" EDITTEXT
DEFAULT "SQL Server"
VALUENAME NameofDatabase
END PART
END POLICY

END CATEGORY
 
R

Richard Weaver

I have a problem which is like this. I am trying to create a .adm file from an ODBC connector registry file. The .reg file looks like this:



[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ISTraka]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="SQL"
"Database"="IStraka"
"LastUser"="manager"
"Trusted_Connection"="Yes"

When i use a progarm to convert it the results are:

CLASS MACHINE

CATEGORY "SOFTWARE\ODBC\ODBC.INI\ISTraka"
KEYNAME "SOFTWARE\ODBC\ODBC.INI\ISTraka"

POLICY "Driver"
PART "Driver"
EDITTEXT
DEFAULT "C:\WINDOWS\system32\SQLSRV32.dll"
VALUENAME "Driver"
END PART
END POLICY

POLICY "Server"
PART "Server"
EDITTEXT
DEFAULT "SQL"
VALUENAME "Server"
END PART
END POLICY

POLICY "Database"
PART "Database"
EDITTEXT
DEFAULT "IStraka"
VALUENAME "Database"
END PART
END POLICY

POLICY "LastUser"
PART "LastUser"
EDITTEXT
DEFAULT "manager"
VALUENAME "LastUser"
END PART
END POLICY

POLICY "Trusted_Connection"
PART "Trusted_Connection"
EDITTEXT
DEFAULT "Yes"
VALUENAME "Trusted_Connection"
END PART
END POLICY

END CATEGORY

Is this converting correct or is the program wrong?
 
N

Neato

I have a problem which is like this. I am trying to create a .adm file from an ODBC connector registry file. The .reg file looks like this:



[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ISTraka]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="SQL"
"Database"="IStraka"
"LastUser"="manager"
"Trusted_Connection"="Yes"

When i use a progarm to convert it the results are:

CLASS MACHINE

CATEGORY "SOFTWARE\ODBC\ODBC.INI\ISTraka"
KEYNAME "SOFTWARE\ODBC\ODBC.INI\ISTraka"

POLICY "Driver"
PART "Driver"
EDITTEXT
DEFAULT "C:\WINDOWS\system32\SQLSRV32.dll"
VALUENAME "Driver"
END PART
END POLICY

POLICY "Server"
PART "Server"
EDITTEXT
DEFAULT "SQL"
VALUENAME "Server"
END PART
END POLICY

POLICY "Database"
PART "Database"
EDITTEXT
DEFAULT "IStraka"
VALUENAME "Database"
END PART
END POLICY

POLICY "LastUser"
PART "LastUser"
EDITTEXT
DEFAULT "manager"
VALUENAME "LastUser"
END PART
END POLICY

POLICY "Trusted_Connection"
PART "Trusted_Connection"
EDITTEXT
DEFAULT "Yes"
VALUENAME "Trusted_Connection"
END PART
END POLICY

END CATEGORY

Is this converting correct or is the program wrong?
 
N

Neato

I have a problem which is like this. I am trying to create a .adm file from an ODBC connector registry file. The .reg file looks like this:



[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ISTraka]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="SQL"
"Database"="IStraka"
"LastUser"="manager"
"Trusted_Connection"="Yes"

When i use a progarm to convert it the results are:

CLASS MACHINE

CATEGORY "SOFTWARE\ODBC\ODBC.INI\ISTraka"
KEYNAME "SOFTWARE\ODBC\ODBC.INI\ISTraka"

POLICY "Driver"
PART "Driver"
EDITTEXT
DEFAULT "C:\WINDOWS\system32\SQLSRV32.dll"
VALUENAME "Driver"
END PART
END POLICY

POLICY "Server"
PART "Server"
EDITTEXT
DEFAULT "SQL"
VALUENAME "Server"
END PART
END POLICY

POLICY "Database"
PART "Database"
EDITTEXT
DEFAULT "IStraka"
VALUENAME "Database"
END PART
END POLICY

POLICY "LastUser"
PART "LastUser"
EDITTEXT
DEFAULT "manager"
VALUENAME "LastUser"
END PART
END POLICY

POLICY "Trusted_Connection"
PART "Trusted_Connection"
EDITTEXT
DEFAULT "Yes"
VALUENAME "Trusted_Connection"
END PART
END POLICY

END CATEGORY

Is this converting correct or is the program wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group Policy for Terminal Server not working 2
Group Policy Refresh - block on vpn laptops 0
ODBC settings for all users on one PC 1
Group Policy Registry Wizard 2008 Server 2
Manage ODBC 2
Using Group Policy to define a Password Policy 1
Group Policy 1
Group policy 2

Top