JustinW
asked on
Batch File to Remove ODBC Connection
I've figured out how to create an ODBC connection through a batch file that
runs like this:
I'm trying to figure out how to delete this connection through the same process.
Thanks,
-JW
runs like this:
ODBCConf ConfigSysDSN "MySQL ODBC 5.1 Driver" "DSN=test;SERVER=cpucnd1277xr9.mycompany.com;UID=%USERNAME%;PWD=today123;DATABASE=arms;PORT=3306"
I'm trying to figure out how to delete this connection through the same process.
Thanks,
-JW
i believe u jsut need to use the instodbc utility and write the necessary code in a batch file
ASKER
The delete portion of the batch file is going to be run by a lot of different computers.
Is instodbc a native windows utility?
Is instodbc a native windows utility?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Reason I suggested that, was is that its just a simpler method, instead of the above.....
ASKER
@john,
How to remove from //ODBC Data Sources?
When I go to odbc source admin, it still lists 'TEST' as an active ODBC
How to remove from //ODBC Data Sources?
When I go to odbc source admin, it still lists 'TEST' as an active ODBC
Should be gone after a reboot.....
this might help