I am using sql 7.0. I have tried with all the options by connection squirrel
sql client with MS sql server. But it is giving the error message unable to
connect chek url. Can you guide me where was the problem.
Advanced thanks
Krishna
Matthew Dahlman wrote:
>
> Hi Ranier,
>
> In case you are still working on this problem...
> "TCP/IP connection could not be established" generally happens when the
> client can't connect to the database server at all. The reasons are
> usually
> things like these:
> - The server isn't running
> - The server is listening on a different port
> - With SQL Server, TCP/IP access isn't always activated
> - A firewall is blocking your access
>
> Your problem may be different, but it's likely to be similar to something
> like this.
>
> I troubleshoot this sort of error like this:
> 1. Confirm that ping mobil-cor works.
> 2. Confirm that telnet mobil-cor 1433 works.
>
> Good luck.
>
> Regards,
> Matt
>
> _____
>
> From: Rainer F. Cornely [mailto:Cornely@...]
> Sent: Thursday, May 11, 2006 17:18 PM
> To: Matthew Dahlman; David Cook; squirrel-sql-users@...
> Subject: AW: [Squirrel-sql-users] can't connect to MS SQL Server
>
>
>
> Hi, thanks for Your reply.
>
>
>
> 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
>
>
>
>
>
>
>
> _____
>
> Von: Matthew Dahlman [mailto:mdahlman@...]
> Gesendet: Donnerstag, 11. Mai 2006 03:27
> An: 'David Cook'; Rainer F. Cornely;
> squirrel-sql-users@...
> Betreff: RE: [Squirrel-sql-users] can't connect to MS SQL Server
>
>
>
> 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 vsjust 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@... 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
>
>
>
>
>
>
>
--
View this message in context: http://www.nabble.com/can%27t-connect-to--MS-SQL-Server-tf1590611.html#a6166041
Sent from the squirrel-sql-users forum at Nabble.com.
|