ODBC Drivers

[Ed]

Does anyone know how to deploy and configure odbc drivers via group policy or
any other means, except for physically going around to each workstation?

Thanks,
Ed

[Mark Heitbrink [MVP]]

Ed schrieb:

> Does anyone know how to deploy and configure odbc drivers via group policy or
> any other means, except for physically going around to each workstation?

Depending on your configuration, they are stored in the registry.
Create a ADM Template out of it.

http://www.oreilly.de/catalog/winsyspe/chapter/ch08.html

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
Homepage: www.gruppenrichtlinien.de
extend GPO: www.desktopstandard.com
PM: Vorname@Homepage, Versende-Adresse wird nicht abgerufen.