Unanswered: Connecting to MS SQL through a remoter DSN
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:
strURL = "jdbc:odbc:remoteDSN";
myConnection = DriverManager.getConnection(strURL);
i get error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
If i do this localy (the DSN and SQL server on the same computer , there is no problem.