SQL Server Driver and Classpath problem
SQL Server Driver and Classpath problem
- Subject: SQL Server Driver and Classpath problem
- From: TW <email@hidden>
- Date: Thu, 4 Sep 2008 23:34:41 -0700
All:
I'm stumped. I have a working model and app that accesses a remote db
server running SQL Server 2000. This service is being upgraded to
SQLServer 2005 so I have test server to, um, test against.
The drivers for the old server are embedded in my model and plist
containing the data for the connection dictionary is in by the app
Resources. This all works great for connecting to the old server.
Testing the new server: I am removing the old drivers from my model
and embedding the new SQLServer 2005 driver in the model. To do this
I'm dropping the jar into Libraries and then selecting "Add to Build
Path." To remove the old one's I'm using "Remove from Build Path" and
then deleting them from the project. Then, in my app, I change the url
for my connection dictionary to the url to connect to the new server
-- jdbc:sqlserver://server.ucla.edu:1433;DatabaseName=db
Running a query against the connection gives me this error:
"JDBC connection failed for
driver :'com.microsoft.jdbc.sqlserver.SQLServerDriver'. Driver not
found in Java Runtime!"
I've tried putting the driver everywhere including adding it to the
app itself and also /Library/Java/Extensions and /Library/WebObjects/
Extensions -- just to be thorough. When I do make changes in Eclipse
the .classpath file looks to be appropriately updated and sqljdbc.jar
is always in the build path.
I just can't for the life of me figure out why I'm having so much
difficulty with this. So, I need help to save my sanity.
Tim
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden