ODBC connection setup
I need to go into Data Sources (ODBC), System DSN tab and add a new data source using a specific driver. Is there any easy way to automate this that I am not aware of? Thanks, Morgan
Forum Discussion
Hi Morgan,
The 'vbscript create system DSN' google request returned quite a few results. The first two of them were
http://blogs.technet.com/b/heyscriptingguy/archive/2004/11/10/can-i-create-and-delete-a-dsn-using-a-script.aspx
and
http://www.visualbasicscript.com/Create-an-ODBC-system-DSN-for-connecting-m39361.aspx
I did not check if they operate as expected, but hopefully they will provide you with the general idea at least.
The 'vbscript create system DSN' google request returned quite a few results. The first two of them were
http://blogs.technet.com/b/heyscriptingguy/archive/2004/11/10/can-i-create-and-delete-a-dsn-using-a-script.aspx
and
http://www.visualbasicscript.com/Create-an-ODBC-system-DSN-for-connecting-m39361.aspx
I did not check if they operate as expected, but hopefully they will provide you with the general idea at least.