connection problems
This could well be a very simple problem, but I am stumped.
I am working on a servlet that connects to a database to grab some data (I am developing it in BEA weblogic 9.0 for whatever that's worth). When I was testing the program I had no problems at all and everything worked great. However, when I set up the program on the server running Tomcat I could no longer get a connection.
The line that is throwing the error is simply:
Connection connection= DriverManager.getConnection(URL, UserName, Password);
The exception I get is:
java.sql.SQLException: [Microsoft] [ODBC SQL Server Driver] [SQL Server] Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
The URL is of the form : jdbc:odbc:serverName, and an ODBC datasource has been created on the server(I have also double checked the URL, username and password more times than I can count!)
Does anyone have any ideas as to what could be causing these problems?
