vbscript, Can you create ODBC connections using VBScript?

Can you create ODBC connections using VBScript?

Author	Message
Ryan Rinehar #1 / 3	Can you create ODBC connections using VBScript? I am wanting to setup the actual ODBC connection parameters using VBScript. Is this possible?
Sat, 15 Jan 2005 22:44:34 GMT

Bill Tillso #2 / 3	Can you create ODBC connections using VBScript? Yes you can... Check out this page for a great script. http://www.swynk.com/winscript/DOCS_AutoDSN.asp This requires the database server to use windows integrated authentication however.. Not SQL authentication. If anyone knows how to configure a script for SQL authentication please let me know. I've been searching for weeks with no luck so far. Thanks. Bill Tillson Quote: > I am wanting to setup the actual ODBC connection parameters using > VBscript. Is this possible?
Sat, 15 Jan 2005 23:00:10 GMT

Ryan Rinehar #3 / 3	Can you create ODBC connections using VBScript? Thanks Bill, It looks like this might be possible with WMI & VBScript as well. I have posted on the WMI board to try to find the classes and properties I need to set. I found some WMI classes that relate to ODBC, but am not advanced enough to know exactly what to set. Ryan Quote: > Yes you can... Check out this page for a great script. > http://www.swynk.com/winscript/DOCS_AutoDSN.asp > This requires the database server to use windows integrated authentication > however.. Not SQL authentication. > If anyone knows how to configure a script for SQL authentication > please let me know. I've been searching for weeks with no luck so far. > Thanks. > Bill Tillson > > I am wanting to setup the actual ODBC connection parameters using > > VBscript. Is this possible?
Sat, 15 Jan 2005 23:26:33 GMT

Page 1 of 1

[ 3 post ]