AW: [Squirrel-sql-users] can't connect to MS SQL Server

[Rainer F. C. <Co...@ls...>]

Hi,  thanks for Your reply.

=20

If I use the URL without the "microsoft." Then I get another error :

test: Es konnte keine TCP/IP-Verbindung zu Host "" hergestellt werden

(Translation: TCP/IP connection could not be established to Host "")

. java.net.ConnectException: Connection refused: connect

This Error message  is thrown even with the URL: jdbc:sqlserver://

That means for me it seems to be a version problem not a URL problem

Regards

Rainer

=20

=20

=20

________________________________

Von: Matthew Dahlman [mailto:mda...@su...]=20
Gesendet: Donnerstag, 11. Mai 2006 03:27
An: 'David Cook'; Rainer F. Cornely;
squ...@li...
Betreff: RE: [Squirrel-sql-users] can't connect to MS SQL Server

=20

Hi Rainer,

=20

Dave is correct.

=20

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.

=20

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.).

=20

Regards,

Matt

=20

________________________________

From: squ...@li...
[mailto:squ...@li...] On Behalf Of
David Cook
Sent: Wednesday, May 10, 2006 21:31 PM
To: 'Rainer F. Cornely'; squ...@li...
Subject: RE: [Squirrel-sql-users] can't connect to MS SQL Server

Rainer -

=20

    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:

=20

You used:     =
jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=3Dxyz

=20

Try taking the 'microsoft' part out of your URL 'prefix'...e.g.

      jdbc:sqlserver://mobil-cor:1433;databaseName=3Dxyz

=20

Also, I notice I use a CAPITAL N in 'databaseName'...don't know whether
that

key is case-sensitive.

=20

(I don't know anything about 'Extra' classpath vsjust classpath, so I
can't speak

to how you have that part set up.)

=20

Hope this helps...

=20

        Dave

	-----Original Message-----
	From: squ...@li...
[mailto:squ...@li...]On Behalf Of
Rainer F. Cornely
	Sent: Wednesday, May 10, 2006 6:07 AM
	To: squ...@li...
	Subject: [Squirrel-sql-users] can't connect to MS SQL Server

	=20

	Hi to all.

	I'm new to SquirreL which is the best tool I've seen.

	=20

	Everything is fine with all features including the plugins while
connected to Oracle 10g.

	=20

	But I can't make it to get a connection to MS SQL

	=20

	The System is XP Pro

	Squirrel is 2.2 final

	=20

	The Settings are:

	=20

	Class Path: com.microsoft.sqlserver.jdbc.SQLServerDriver

	Extra Class Path: .....\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.0\enu\sqljdbc.jar

	=20

	Release Information

	Microsoft SQL Server 2005 JDBC Driver

	Version 1.0

	January 2006

	=20

	The database is up and running.

	=20

	The URL's used: jdbc:microsoft:sqlserver://mobil-cor:1433

=09
jdbc:microsoft:sqlserver://mobil-cor:1433;databasename=3Dxyz

	=20

	The Error Message: Test: Unable to create connection. Check your
URL.

	=20

	Can somebody help me?

	Thanks in advance

	=20

	Rainer

	=20

	=20