Hellos,
I'm looking for an example code for a VBScript connection to a remote SQL 2000 server. I'm trying to avoid the system or file DSN requirement on the system running the script so I can move the script from one system to another wiht having to build a new DSN on each system. I do need to use SQL authentication in the connection. The idea is to use SQL as my data storage media for administration scripts instead of excel.
Any examples would be greatly appreciated.
Thanks in advance.
I'm looking for an example code for a VBScript connection to a remote SQL 2000 server. I'm trying to avoid the system or file DSN requirement on the system running the script so I can move the script from one system to another wiht having to build a new DSN on each system. I do need to use SQL authentication in the connection. The idea is to use SQL as my data storage media for administration scripts instead of excel.
Any examples would be greatly appreciated.
Thanks in advance.