I have a sql server box setup and I have about 30 different databases. I was wondering if there was a way to write and run a script to set these databases up as system datasources rather than having to go into ODBC datasources and create the system datasources manually..
Basically, Im asking, once I have the databases setup in SQL server, I still have to setup the system datasource mappings in the ODBC datasource administrator. Is there a way I can run a script to do this for 30+ datasources rather than doing each one manually?
Basically, Im asking, once I have the databases setup in SQL server, I still have to setup the system datasource mappings in the ODBC datasource administrator. Is there a way I can run a script to do this for 30+ datasources rather than doing each one manually?