squirrel-sql-users

[Squirrel-sql-users] SQL 7.0 compatability

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

Hi 
I am using Squirrle SQL Ver 2.2 final. Can I connect to SQL 7.0 using this?
I can able to connect to my  SQL server 2000. But when I tried to connect to
my SQL 7.0 server I am getting an error message "The TDS prelogin response
is incomplete. The target server must be SQL Servr 2000 or later." - Can
anybody clarify on this?

Thanks
Krishna
-- 
View this message in context: http://www.nabble.com/SQL-7.0-compatability-tf2262898.html#a6278782
Sent from the squirrel-sql-users forum at Nabble.com.

Re: [Squirrel-sql-users] SQL 7.0 compatability

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

On 9/13/06, krishna <kri...@gm...> wrote:
>
> Hi
> I am using Squirrle SQL Ver 2.2 final. Can I connect to SQL 7.0 using this?
> I can able to connect to my  SQL server 2000. But when I tried to connect to
> my SQL 7.0 server I am getting an error message "The TDS prelogin response
> is incomplete. The target server must be SQL Servr 2000 or later." - Can
> anybody clarify on this?
>

I'll guess that the driver you are using (which works fine for
SQLServer 2000) isn't
compatible with version 7.0 (what's that like 98 or something :)  My
guess would
be that you need an earlier version of the JDBC driver to connect to version 7.0
based on my limited knowledge of MS SQLServer.

Rob

Re: [Squirrel-sql-users] SQL 7.0 compatability

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

ok. Thanks for your response. One basic question. Will Squirrel SQL works on
SQL SERVER 7.0?

Thanks
KRishina

manningr wrote:
> 
> On 9/13/06, krishna <kri...@gm...> wrote:
>>
>> Hi
>> I am using Squirrle SQL Ver 2.2 final. Can I connect to SQL 7.0 using
>> this?
>> I can able to connect to my  SQL server 2000. But when I tried to connect
>> to
>> my SQL 7.0 server I am getting an error message "The TDS prelogin
>> response
>> is incomplete. The target server must be SQL Servr 2000 or later." - Can
>> anybody clarify on this?
>>
> 
> I'll guess that the driver you are using (which works fine for
> SQLServer 2000) isn't
> compatible with version 7.0 (what's that like 98 or something :)  My
> guess would
> be that you need an earlier version of the JDBC driver to connect to
> version 7.0
> based on my limited knowledge of MS SQLServer.
> 
> 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/SQL-7.0-compatability-tf2262898.html#a6299801
Sent from the squirrel-sql-users forum at Nabble.com.

Re: [Squirrel-sql-users] SQL 7.0 compatability

[Gerd W. <bir...@t-...>]

krishna wrote:
> ok. Thanks for your response. One basic question. Will Squirrel SQL works on
> SQL SERVER 7.0?
It's quite some time ago that I used it on SQL SERVER 7.0. At this time it 
worked fine. I can't see no reason why it shouldn't if you use a suiting driver.

Gerd