squirrel-sql-users

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

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

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: 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



 

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

 

 

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

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

'Gentoo' -


Try a url of the FORM:

	jdbc:jtds:sqlserver://localhost:3048/employees

substituting, of course, your OWN correct values for 'host', and 'port' and
'db-name',
instead of the ones I'm showing here.  In other words, try the fixed
'prefix':

	jdbc:jtds:sqlserver://

and then supply your own values in the form shown on the tail-end.

Hope this works for you...that's what works for me.

Cheers...

	Dave



-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of
Gentoo @ Paradyme
Sent: Friday, June 02, 2006 4:42 PM
To: Matthew Dahlman
Cc: 'David Cook'; squ...@li...; 'Rainer F.
Cornely'
Subject: Re: [Squirrel-sql-users] can't connect to MS SQL Server


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.



_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

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

[Matthew D. <mda...@su...>]

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: 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 -
 
    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: 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



 

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

 

 

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

[Gentoo @ P. <ge...@pa...>]

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.

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

[Robert M. <rob...@gm...>]

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