How to Connect to Remote Database

[cmorrell]

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:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
Connection serverConnect = DriverManager.getConnection
("jdbc:odbc://<ip_address>;dsn=<dsn_name>;uid=<user_id>;pwd=<password>");

Do I need to use a different driver? Is the connection string incorrect? Any ideas?

Thanks in advance for your help.

[gertcuppens]

If you're adding a try catch arond these lines, you could take a look at the errors you're getting. It might help us to know what kind of errors you're getting.