Hi,

perhaps someone need a script like this....

This script creates or make changes to a SYSTEM-DNS SQL-Server ODBC Connection...

code:
  
;Create a System-DNS ODBC Entry in the Registry
;M.Szekely
;
;Variables
$regODBC="HKLM\Software\ODBC\ODBC.ini"
$regDBSName="ZMDB"
$regDBSDescription="Zentrales Management"
$regDBSDriver="%systemroot%\system32\SQLSRV32.dll"
$regDBSUser="%Username%"
$regDBSServer="SM009"

;Write the values to the registry
if not keyexist("$regODBC\$regDBSName")
 $RC=addkey("$regODBC\$regDBSName")
 $RC=writevalue("$regODBC\ODBC DATA Sources","$regDBSName","SQL Server","REG_SZ")
endif

$RC=writevalue("$regODBC\$regDBSName","Database",$regDBSName,"REG_SZ")
$RC=writevalue("$regODBC\$regDBSName","Description",$regDBSDescription,"REG_SZ")
$RC=writevalue("$regODBC\$regDBSName","Driver",$regDBSDriver,"REG_SZ")
$RC=writevalue("$regODBC\$regDBSName","LastUser",$regDBSUser,"REG_SZ")
$RC=writevalue("$regODBC\$regDBSName","Server",$regDBSServer,"REG_SZ")
$RC=writevalue("$regODBC\$regDBSName","Trusted_Connection","Yes","REG_SZ")

[ 05 February 2002: Message edited by: MasterOfDesaster ]

[ 06 February 2002: Message edited by: MasterOfDesaster ]

_________________________
Greetings,

Michael