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

[David C. <Dav...@ve...>]

To all -

Yeah, I can believe that we may both be 'correct'.

And, that the explanation is that we are each using a
DIFFERENT variant of the 'SQL Server' client JDBC driver.

(In our emails, we should probably be specifying the full 'JDBC class-name'
of which driver we are each referring to.)

It is (probably) because the description '2005' MS SQLServer
JDBC does not UNIQUE-ly define which driver we are each
talking about.

(Which is why I used the word 'try' in my posting.)

Hope this explanation is correct and clarifies things...

Cheers...

	Dave




-----Original Message-----
From: Robert Manning [mailto:rob...@gm...]
Sent: Saturday, June 03, 2006 8:15 AM
To: Gentoo @ Paradyme
Cc: Matthew Dahlman; David Cook;
squ...@li...; Rainer F. Cornely
Subject: Re: [Squirrel-sql-users] can't connect to MS SQL Server


On 6/2/06, Gentoo @ Paradyme <ge...@pa...> wrote:
> On Thu, 2006-05-11 at 09:26 +0800, Matthew Dahlman wrote:
> > 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.
>
> Then what is the proper connection string? I too have this problem.
>

For me, the following form works:

jdbc:sqlserver://hostname:port/database=dbname

Of course, you will need to substitute the correct values for :

hostname
port
dbname

Rob