squirrel-sql-users

[Squirrel-sql-users] Cant connect SQL

[krishna <kri...@gm...>]

Hi 
I am trying to connect Squirrle SQL client 2.2 with the server MS sql 7.0. I
am getting an error message saying unable to connect. check your url". I
have tried with different options. Can you help me what could be the
problem? 
Thanks
Krishna
-- 
View this message in context: http://www.nabble.com/Cant-connect-SQL-tf2225264.html#a6166363
Sent from the squirrel-sql-users forum at Nabble.com.

Re: [Squirrel-sql-users] Cant connect SQL

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

On 9/6/06, krishna <kri...@gm...> wrote:
>
> Hi
> I am trying to connect Squirrle SQL client 2.2 with the server MS sql 7.0. I
> am getting an error message saying unable to connect. check your url". I
> have tried with different options. Can you help me what could be the
> problem?

Can you give us the JDBC URL that you are using, along with the driver
class name? (This will help us to tell you what the problem is)

Rob

Re: [Squirrel-sql-users] Cant connect SQL

[krishna <kri...@gm...>]

Hi 
The the JDBC URL that you  I am  using is 
jdbc:microsoft:<aliasname>:\\<SQL-server-name>\<database-name>

Driver class name is - microsft NS sql server jdbc driver

Thanks
Krishina


manningr wrote:
> 
> On 9/6/06, krishna <kri...@gm...> wrote:
>>
>> Hi
>> I am trying to connect Squirrle SQL client 2.2 with the server MS sql
>> 7.0. I
>> am getting an error message saying unable to connect. check your url". I
>> have tried with different options. Can you help me what could be the
>> problem?
> 
> Can you give us the JDBC URL that you are using, along with the driver
> class name? (This will help us to tell you what the problem is)
> 
> Rob
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Cant-connect-SQL-tf2225264.html#a6184275
Sent from the squirrel-sql-users forum at Nabble.com.

Re: [Squirrel-sql-users] Cant connect SQL

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

On 9/7/06, krishna <kri...@gm...> wrote:
>
> Hi
> The the JDBC URL that you  I am  using is
> jdbc:microsoft:<aliasname>:\\<SQL-server-name>\<database-name>
>
> Driver class name is - microsft NS sql server jdbc driver

I don't recognize that driver class name.  In the SQL-Server 2005 version
of the JDBC driver it looks like:

com.microsoft.sqlserver.jdbc.SQLServerDriver

The URL look for the SQL-Server 2005 version of the JDBC driver looks like:

jdbc:sqlserver://<SERVER>:<PORT>/database=<DATABASE_NAME>

At the very least, I believe your backslashes ("\") should be forward
slashes ("/")

You probably want to go and get the latest SQL-Server 2005 version of the
JDBC driver from Microsoft.  It seemed compatible with SQL-Server 2000
when I had tested it in the past.

Rob