Script to test an ODBC connection?
Posted on 2006-04-24
I am not sure if this is the right place to ask but here goes:
I have a user who manually setup a System DSN ODBC connection for SQL 2000.
I can only as for a name of that connection such as "ODBC_SQL", this name is the DSN configuration for SQL 2000 that he allready stated the server, the user name and password and which database to connect to in the setting.
He is running window 2000.
I know the driver he use is " sun.jdbc.odbc.JdbcOdbcDriver",
I am unsure but the URL can be "jdbc:odbc:ODBC_SQL "
Is there a vb script that I can use to connect to his datbase to test if certain table exists? so that when I run the script, if the table exists then I get a pop up message saying good connection, else saying bad connection?