If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Connecting to MS SQL through a remoter DSN

:) Hi,
I'm trying to connect to a remote MS SQL server through DSN(that is on a different computer than the SQL server is)
I have succeeded to define a DSN, and by using Microsoft Access i can connect to the server after SQL login server request.

When i try to do this from Java, after defining the following code:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
strURL = "jdbc:odbc:remoteDSN";
myConnection = DriverManager.getConnection(strURL);