Hi I am trying to execute LOAD TABLE using client file on Sybase IQ. I am using ianywhere JDBC driver and I am getting the following exception.
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at ianywhere.ml.jdbcodbc.jdbc3.IDriver.makeODBCConnection(Native Method) at ianywhere.ml.jdbcodbc.jdbc3.IDriver.connect(IDriver.java:633)
I am using the following code. Please help. Thanks a lot.
Class.forName("ianywhere.ml.jdbcodbc.jdbc3.IDriver").newInstance(); String url = "jdbc:ianywhere:some.com:2740"; String userName = "sa"; String password = "pass"; dbConn = DriverManager.getConnection(url, userName, password);
asked 01 Jul '13, 02:22
Your URL is incorrect. The above URL format looks more like a jConnect URL than an iAnywhere JDBC URL.
Can you please provide some more details so that we can help you better. In particular, can you tell us:
Note, that question 2 above may cause you confusion given that you are using IQ instead of SQL Anywhere, but in reality, the SQL Anywhere JDBC Driver works quite well with IQ and is a better alternative to the iAnywhere JDBC Driver. If you can provide the above information, then we can help you construct a proper DSN-less URL.
answered 01 Jul '13, 10:35