Configuring SQL.INI For Connection To MS SQL Server 
Author Message
 Configuring SQL.INI For Connection To MS SQL Server
Hi All,

I'm trying to configure my Sybase SQL.INI file so that my DB-LIB applications
can connect to a MS SQL Server.  Could someone give me a hint as to how this
is done?

Thanks.

--
Robert A. Nurse

ICQ Network Number 207692
http://www.***.com/



Sun, 28 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server

[mssql_tcp]
query=NLWNSCK,host_name,1433
win3_query=NLWNSCK,host_name,1433

[mssql_namepipe]
query=NLMSNMP,\\computer_name\pipe\sql\query
win3_query=NLMSNMP,\\computer_name\pipe\sql\query

Quote:

> Hi All,
> I'm trying to configure my Sybase SQL.INI file so that my DB-LIB applications
> can connect to a MS SQL Server.  Could someone give me a hint as to how this
> is done?
> Thanks.
> --
> Robert A. Nurse

> ICQ Network Number 207692
> http://www.cudbytech.net/

--
JULY


Mon, 29 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Example entry of sql.ini for MSSQL:

[TESTSQLSERVER]
query=NLWNSCK,mymssql.test.com,1433

Quote:

> Hi All,

> I'm trying to configure my Sybase SQL.INI file so that my DB-LIB applications
> can connect to a MS SQL Server.  Could someone give me a hint as to how this
> is done?

> Thanks.

> --
> Robert A. Nurse

> ICQ Network Number 207692
> http://www.cudbytech.net/



Mon, 29 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Hi Ivan,

I gave this a try.  But I still can't connect.  I checked the events on the MS SQL
Server machine and I saw the following event:

"Connection opened but invalid login packet(s) sent.  Connection closed."

It sounds like the client is trying to communicate with a different protocol.

Quote:

> Example entry of sql.ini for MSSQL:

> [TESTSQLSERVER]
> query=NLWNSCK,mymssql.test.com,1433


> > Hi All,

> > I'm trying to configure my Sybase SQL.INI file so that my DB-LIB applications
> > can connect to a MS SQL Server.  Could someone give me a hint as to how this
> > is done?

> > Thanks.

> > --
> > Robert A. Nurse

> > ICQ Network Number 207692
> > http://www.cudbytech.net/

--
Robert A. Nurse

ICQ Network Number 207692
http://www.cudbytech.net/


Mon, 29 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Have you applied service pack on your MSSQL7?

Quote:

> Hi Ivan,
> I gave this a try.  But I still can't connect.  I checked the events on the MS SQL
> Server machine and I saw the following event:
> "Connection opened but invalid login packet(s) sent.  Connection closed."
> It sounds like the client is trying to communicate with a different protocol.

>> Example entry of sql.ini for MSSQL:

>> [TESTSQLSERVER]
>> query=NLWNSCK,mymssql.test.com,1433


>> > Hi All,

>> > I'm trying to configure my Sybase SQL.INI file so that my DB-LIB applications
>> > can connect to a MS SQL Server.  Could someone give me a hint as to how this
>> > is done?

>> > Thanks.

>> > --
>> > Robert A. Nurse

>> > ICQ Network Number 207692
>> > http://www.cudbytech.net/
> --
> Robert A. Nurse

> ICQ Network Number 207692
> http://www.cudbytech.net/

--
JULY


Tue, 30 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Norris,

I'm almost sure I did.  But I'll double check.

Quote:

> Have you applied service pack on your MSSQL7?


> > Hi Ivan,

> > I gave this a try.  But I still can't connect.  I checked the events on the MS SQL
> > Server machine and I saw the following event:

> > "Connection opened but invalid login packet(s) sent.  Connection closed."

> > It sounds like the client is trying to communicate with a different protocol.


> >> Example entry of sql.ini for MSSQL:

> >> [TESTSQLSERVER]
> >> query=NLWNSCK,mymssql.test.com,1433


> >> > Hi All,

> >> > I'm trying to configure my Sybase SQL.INI file so that my DB-LIB applications
> >> > can connect to a MS SQL Server.  Could someone give me a hint as to how this
> >> > is done?

--
Robert A. Nurse
Web Development
RCN Corporation

ICQ Network Number 15566746
http://members.tripod.com/~rnurse


Tue, 30 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Robert,
Its because in addition to the Service Pack 1 for MSSQL7, you need the hotfix s70723I
to be applied. It needs to copy a bunch of OPENDS60 DLLS to make the TDS layer
compatible with open client.
I had got the very similar message, and it went away with the hotfix apply.
Quote:

> Hi Ivan,

> I gave this a try.  But I still can't connect.  I checked the events on the MS SQL
> Server machine and I saw the following event:

> "Connection opened but invalid login packet(s) sent.  Connection closed."

> It sounds like the client is trying to communicate with a different protocol.


> > Example entry of sql.ini for MSSQL:

> > [TESTSQLSERVER]
> > query=NLWNSCK,mymssql.test.com,1433


> > > Hi All,

> > > I'm trying to configure my Sybase SQL.INI file so that my DB-LIB applications
> > > can connect to a MS SQL Server.  Could someone give me a hint as to how this
> > > is done?

> > > Thanks.

> > > --
> > > Robert A. Nurse

> > > ICQ Network Number 207692
> > > http://www.cudbytech.net/

> --
> Robert A. Nurse

> ICQ Network Number 207692
> http://www.cudbytech.net/



Tue, 30 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Thanks Ivan.  You were a great help.

Quote:

> Robert,

> You can get it from the FTP site.

> File Location

> ftp://ftp.microsoft.com/bussys/sql/transfer/sql70/sqlservr/s70723i.exe -
> Intel
> ftp://ftp.microsoft.com/bussys/sql/transfer/sql70/sqlservr/s70723a.exe -
> Alpha

> Bugs Fixed

> 55964   7.0 ODS does not send back login response to TDS 5.0 clients exactly
> as 6.5 ODS

> You may need the password to extract the files from this file

> s70723i.exe -s<passwd>

> You can call MS Support for the password.

> Ivan Santhumayor
> Firmwide database Support
> Goldman Sachs & Co.

> > -----Original Message-----

> > Sent: Friday, February 11, 2000 12:38 PM
> > To:   Santhumayor, Ivan
> > Subject:      Re: Configuring SQL.INI For Connection To MS SQL Server

> > Hi Ivan,

> > You wouldn't still happen to have that hotfix would you?  I'm searching
> > M$'s site now and they seem to have everything but this.


> > Robert,
> > Its because in addition to the Service Pack 1 for MSSQL7, you need the
> > hotfix s70723I
> > to be applied. It needs to copy a bunch of OPENDS60 DLLS to make the TDS
> > layer
> > compatible with open client.
> > I had got the very similar message, and it went away with the hotfix
> > apply.

> >  <http://www.cudbytech.net/>

> > --
> > Robert A. Nurse
> > Web Development
> > RCN Corporation

> > ICQ Network Number 15566746
> > <http://members.tripod.com/~rnurse>

--
Robert A. Nurse
Web Development
RCN Corporation

ICQ Network Number 15566746
http://members.tripod.com/~rnurse


Tue, 30 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Does anyone have the password for the patch archive S70723I.EXE?  This is the patch that
allows Sybase clients to connect to MS SQL Server.  It would save me the headache of
wading through the M$ support cesspool.

Quote:

> Robert,
> Its because in addition to the Service Pack 1 for MSSQL7, you need the hotfix s70723I
> to be applied. It needs to copy a bunch of OPENDS60 DLLS to make the TDS layer
> compatible with open client.
> I had got the very similar message, and it went away with the hotfix apply.


> > Hi Ivan,

> > I gave this a try.  But I still can't connect.  I checked the events on the MS SQL
> > Server machine and I saw the following event:

> > "Connection opened but invalid login packet(s) sent.  Connection closed."

> > It sounds like the client is trying to communicate with a different protocol.


> > > Example entry of sql.ini for MSSQL:

> > > [TESTSQLSERVER]
> > > query=NLWNSCK,mymssql.test.com,1433


> > > > Hi All,

> > > > I'm trying to configure my Sybase SQL.INI file so that my DB-LIB applications
> > > > can connect to a MS SQL Server.  Could someone give me a hint as to how this
> > > > is done?

> > > > Thanks.

> > > > --
> > > > Robert A. Nurse

> > > > ICQ Network Number 207692
> > > > http://www.cudbytech.net/

> > --
> > Robert A. Nurse

> > ICQ Network Number 207692
> > http://www.cudbytech.net/

--
Robert A. Nurse

ICQ Network Number 207692
http://www.cudbytech.net/


Tue, 30 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Ivan,

You've been a big help with this problem.  But my connection issues still remain.  I
installed the S70723I patch and when I try to connect to SQL Server from Sybase Central, I
get the error:

ct_cursor(): user api layer: external error: The connection's capabilities do not support
this type of request.

At first I was getting incorrect login errors.  Then I figured out that the login info that
Sybase Central is sending is not an NT user but an SQL Server login.  So I created a
matching SQL Server user and that's when I get this error.  I tried connecting with both
named pipes and TCP/IP.  Here are my SQL.INI settings just in case:

[MS_SQLNAMEDPIPES]
query=NLMSNMP,\\SERVERNAME\pipe\sql\query
win3_query=NLMSNMP,\\SERVERNAME\pipe\sql\query

[MS_SQLTCPIP]
query=NLWNSCK,SERVER_IP_ADDRESS,1433
win3_query=NLWNSCK,SERVER_IP_ADDRESS,1433

--
Robert A. Nurse

ICQ Network Number 207692
http://www.cudbytech.net/



Wed, 31 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Robert,
Sybase central uses "database cursors" native to sybase 10.x and above. So any MSSQL or even
Sybase 4.9.2 servers will not connect.
However, you should be fine with NT sybase isql, sqladvantage or even unix sybase clients with
this patch to sql7.

Quote:

> Ivan,

> You've been a big help with this problem.  But my connection issues still remain.  I
> installed the S70723I patch and when I try to connect to SQL Server from Sybase Central, I
> get the error:

> ct_cursor(): user api layer: external error: The connection's capabilities do not support
> this type of request.

> At first I was getting incorrect login errors.  Then I figured out that the login info that
> Sybase Central is sending is not an NT user but an SQL Server login.  So I created a
> matching SQL Server user and that's when I get this error.  I tried connecting with both
> named pipes and TCP/IP.  Here are my SQL.INI settings just in case:

> [MS_SQLNAMEDPIPES]
> query=NLMSNMP,\\SERVERNAME\pipe\sql\query
> win3_query=NLMSNMP,\\SERVERNAME\pipe\sql\query

> [MS_SQLTCPIP]
> query=NLWNSCK,SERVER_IP_ADDRESS,1433
> win3_query=NLWNSCK,SERVER_IP_ADDRESS,1433

> --
> Robert A. Nurse

> ICQ Network Number 207692
> http://www.cudbytech.net/

--
Ivan Santhumayor
Firmwide Database Support
Goldman Sachs & Co

Note: These are my own views and not that of Goldman Sachs



Wed, 31 Jul 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Sybase Central is used for Sybase database only.  You should use MS SQL Enterprise Manager to configure your MSSQL database.  I am wondering why you won't use this great front end tool which is suitable for both administrator and developer.

Quote:

> Ivan,
> You've been a big help with this problem.  But my connection issues still remain.  I
> installed the S70723I patch and when I try to connect to SQL Server from Sybase Central, I
> get the error:
> ct_cursor(): user api layer: external error: The connection's capabilities do not support
> this type of request.
> At first I was getting incorrect login errors.  Then I figured out that the login info that
> Sybase Central is sending is not an NT user but an SQL Server login.  So I created a
> matching SQL Server user and that's when I get this error.  I tried connecting with both
> named pipes and TCP/IP.  Here are my SQL.INI settings just in case:
> [MS_SQLNAMEDPIPES]
> query=NLMSNMP,\\SERVERNAME\pipe\sql\query
> win3_query=NLMSNMP,\\SERVERNAME\pipe\sql\query
> [MS_SQLTCPIP]
> query=NLWNSCK,SERVER_IP_ADDRESS,1433
> win3_query=NLWNSCK,SERVER_IP_ADDRESS,1433
> --
> Robert A. Nurse

> ICQ Network Number 207692
> http://www.cudbytech.net/

--
JULY


Thu, 01 Aug 2002 03:00:00 GMT
 Configuring SQL.INI For Connection To MS SQL Server
Robert I would like to get that password too. Has
anyone sent you the password so far? Could you
plese tell me what it is? Thanks!



Quote:
> Does anyone have the password for the patch

archive S70723I.EXE?  This is the patch that
Quote:
> allows Sybase clients to connect to MS SQL

Server.  It would save me the headache of

Quote:
> wading through the M$ support cesspool.

Sent via Deja.com http://www.deja.com/
Before you buy.


Fri, 23 Aug 2002 03:00:00 GMT
 
 [ 13 post ] 

 Relevant Pages 

1. sql.ini reqquired for ms-sql server ?

2. configuring SQL XML support in IIS for MS SQL Server 2000 Beta 2

3. Configuring MS SQL SERVER 6.5 first time

4. Trouble configuring TCPIP connection between SQL Server 6.5 and NT Workstation

5. Configure two nics on MS SQL 7.0 Server

6. Configuring the Client for MS SQL Server

7. Problem with Connection Pervasive SQL 2000 an MS SQL Server 7.0

8. Problem with Connection Pervasive SQL 2000 an MS SQL Server 7.0

9. Connecting to Sql Server from asp after upgrade from ms sql 7 to ms sql 2000

10. How to configure the SQL Server 6.5 Publisher to use a SQL Server 7.0 Distributor

11. GA-Alpharetta-110503--MS SQL Server-DBA Skills-Database Administrator (DBA)-MS SQL Server

12. Connecting to Sql Server from asp after upgrade from ms sql 7 to ms sql 2000


 
Powered by phpBB® Forum Software