Hi Rainer,
Dave is correct.
To add a little explanation: the url that you used is correct for the MS SQL
Server 2000 driver, but it won't work for the 2005 driver.
By the way, property names like 'databaseName' are case insenstive--no
problems there. But it's standard practice to follow the suggested format
(databaseName, lastUpdateCount, etc.).
Regards,
Matt
_____
From: squirrel-sql-users-admin@...
[mailto:squirrel-sql-users-admin@...] On Behalf Of David
Cook
Sent: Wednesday, May 10, 2006 21:31 PM
To: 'Rainer F. Cornely'; squirrel-sql-users@...
Subject: RE: [Squirrel-sql-users] can't connect to MS SQL Server
Rainer -
Hmm...that looks like the same driver's JAR name that I use. So, here;s
some differences I noticed between your URL and what my working URL looks
like:
You used: jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=xyz
Try taking the 'microsoft' part out of your URL 'prefix'...e.g.
jdbc:sqlserver://mobil-cor:1433;databaseName=xyz
Also, I notice I use a CAPITAL N in 'databaseName'...don't know whether that
key is case-sensitive.
(I don't know anything about 'Extra' classpath vs just classpath, so I can't
speak
to how you have that part set up.)
Hope this helps...
Dave
-----Original Message-----
From: squirrel-sql-users-admin@...
[mailto:squirrel-sql-users-admin@...]On Behalf Of Rainer
F. Cornely
Sent: Wednesday, May 10, 2006 6:07 AM
To: squirrel-sql-users@...
Subject: [Squirrel-sql-users] can't connect to MS SQL Server
Hi to all.
I'm new to SquirreL which is the best tool I've seen.
Everything is fine with all features including the plugins while connected
to Oracle 10g.
But I can't make it to get a connection to MS SQL
The System is XP Pro
Squirrel is 2.2 final
The Settings are:
Class Path: com.microsoft.sqlserver.jdbc.SQLServerDriver
Extra Class Path: .....\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar
Release Information
Microsoft SQL Server 2005 JDBC Driver
Version 1.0
January 2006
The database is up and running.
The URL's used: jdbc:microsoft:sqlserver://mobil-cor:1433
jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=xyz
The Error Message: Test: Unable to create connection. Check your URL.
Can somebody help me?
Thanks in advance
Rainer