Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Use Group Policy to set ODBC

102 views
Skip to first unread message

Simon

unread,
Apr 23, 2008, 8:48:13 AM4/23/08
to
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


Mark Heitbrink [MVP]

unread,
Apr 24, 2008, 10:28:22 AM4/24/08
to
Hi,

Simon schrieb:


> 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?

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

--------------------------------

Mark
--
Mark Heitbrink - MVP Windows Server - Group Policy

Homepage: www.gruppenrichtlinien.de - deutsch
Blog: gpupdate.spaces.live.com - english

richardweaver

unread,
Jun 12, 2008, 2:23:03 AM6/12/08
to
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?

Neato

unread,
Jun 12, 2008, 2:23:13 AM6/12/08
to
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

VALUENAME "Trusted_Connection"
END PART
END POLICY

END CATEGORY

Neato

unread,
Jun 12, 2008, 2:23:45 AM6/12/08
to
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

VALUENAME "Trusted_Connection"
END PART
END POLICY

END CATEGORY

0 new messages