Scripting ODBC Connection

[dodge20]

I am trying to script an odbc connection to multiple servers using odbcconf.exe and remote shell (rsh). I can't seem to make it work correctly. When I run the following script, it doesn't appear to do anything after it does the cmd.exe.

@echo off
setlocal

for /F %%G in (serverlist.txt) do (
rsh %%G cmd.exe
odbcconf.exe /Ln log.txt /a {CONFIGSYSDSN "SQL Server" "DSN=perfmon|Description=Perfomance Monitor on MyServer|SERVER=MyServer\sql1|Trusted_Connection=Yes|Database=MyDB"} 
exit
)

Any Ideas?



Dodge20

 

[markdmac]

Use VBScript instead. You will find many samples with a quick google search for "create ODBC vbscript"



I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.