Hello. I am trying to connect to an access database on my company's web host. I have tried a number of possibilities without success. Here is what I'm trying right now:
Do I need to use a different driver? Is the connection string incorrect? Any ideas?Code:Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection serverConnect = DriverManager.getConnection ("jdbc:odbc://<ip_address>;dsn=<dsn_name>;uid=<user_id>;pwd=<password>");
Thanks in advance for your help.