Thread: RE: [Squirrel-sql-users] can't connect to MS SQL Server
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: David C. <Dav...@ve...> - 2006-05-10 13:31:19
Attachments:
winmail.dat
|
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 |
From: David C. <Dav...@ve...> - 2006-06-03 11:23:08
|
'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 |
From: Matthew D. <mda...@su...> - 2006-05-11 01:27:11
Attachments:
winmail.dat
|
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 |
From: Gentoo @ P. <ge...@pa...> - 2006-06-02 20:43:55
|
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. |
From: Robert M. <rob...@gm...> - 2006-06-03 12:22:24
|
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 |