0

I'm going to make a batch script to do some basic troubleshooting. Among other things, I want to test 32-bit MySQL ODBC's for connectivity. This script will run locally on each workstation. There doesnt appear to be any option in odbcconf.exe for this.

2

1 Answer 1

0

Something like:

sqlcmd.exe -U MyLogin -P MyPassword -S ComputerName\InstanceName | find "connected"

If the connection succeeds, then you know your ODBC connection is good.

Also, check out this big article on scripting with sqlcmd:

https://msdn.microsoft.com/en-us/library/ms188714.aspx

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .