| Hi,
We are trying to upgrade our DB to SQLServer 2000 to SQLServer 2012 (yeah, it's a huge leap), and I'm having a bit of trouble getting it going.
I've installed Microsoft's jdbc driver sqljdbc4.jar in /Library/Java/Extensions.
And setup the connection dictionary as follows:
URL: jdbc:sqlserver://tracker_host:1433;databaseName=Tracker Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
When I run the app, I get the following database exception:
1102 [main] INFO er.transaction.adaptor.Exceptions - Database Exception occured: java.lang.IllegalStateException: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext com.webobjects.eoaccess.EODatabaseContext@17bf9b45: failed to open database channel. Check your connection dictionary, and ensure your database is correctly configured. 1109 [main] INFO er.extensions.eof.ERXDatabaseContextDelegate - WOTracker: {username = "ACG"; driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; password = "<password deleted for log>"; URL = ""; } 1110 [main] INFO er.transaction.adaptor.ConnectionAnalyzer - Checking JDBC connection with information {username = "ACG"; driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; password = "<password deleted for log>"; URL = ""; }
Am I missing anything? Like a JDBC Driver plugin or something?
Thanks in advance,
Anil |