I am writing a service for editing sql server data tables from a java web front end. I am using the jtds jdbc driver. It has been relatively painless until now. I've had some performance issues but it hasn't been bad enough to track down the root cause.
Yesterday the server that I've been using for testing died completely. No hope of rebuilding for a few days, no backups available :(. So I downloaded the SQL Server 2005 express edition and installed it on my laptop. A new feature for MS-SQL since the last time I used it is instance names. I made the mistake of giving my SQL install an instance name and no matter what I did I couldn't get the jtds driver to connect. Supposedly you can create an instance property to be passed when creating a connection but I never got that to work.
So today I re-installed with the default instance name and badabing it all works. No great lesson here but perhaps a bit of help to someone else having the same issue.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment