Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

MS SQL Server 7.0 error when trying to insert or delete a record in sybase base from SQL 7.0 analyser

4 posts in ,  General Discussion Windows NT Last posting was on 2001-04-05 14:03:50.0Z
frederic.cardoso Posted on 2001-04-03 10:32:39.0Z
From: frederic.cardoso@dcmc.creditlyonnais.fr
Date: Tue, 3 Apr 2001 06:32:39 -0400
Newsgroups: sybase.public.sqlserver.general,sybase.public.sqlserver.nt
Subject: MS SQL Server 7.0 error when trying to insert or delete a record in sybase base from SQL 7.0 analyser
Message-ID: <B79DABF7F2807C890039EC0485256A23.0039EC1385256A23@webforums>
Lines: 32
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.general:2052 sybase.public.sqlserver.nt:401
Article PK: 1073042

Hello do you do know why when i try to delete an existing sybase server
record or insert or call a stocked procedure i get an error message : (with
client sybase 12)

SQL analyzer code for delete :
"delete from DS_CATS_INT.cats_int.dbo.TmpProduct where productId='riri'"

i get this error message :
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: You can't have multiple recordsets with
this cursor type (in a transaction.) Either change the cursor type, commit
the transaction, or close one of the record sets.]

If i made a select : everything is ok :
select * from DS_CATS_INT.cats_int.dbo.TmpProduct
i got a correct reply.

If i try an insert via a stored procedure :
"exec DS_CATS_INT.cats_int.dbo.ProductManager 'riri'"

I got this error message :
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionCheckForData
(PeekNamedPipe()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connexion interrompue.
Connection Broken

Anyone got an idea about this problem ?

Thanks a lot
Frederic


Bret Halford Posted on 2001-04-04 23:15:34.0Z
Message-ID: <3ACBAB16.249BBE24@sybase.com>
Date: Wed, 04 Apr 2001 17:15:34 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: MS SQL Server 7.0 error when trying to insert or delete a record in sybasebase from SQL 7.0 analyser
References: <B79DABF7F2807C890039EC0485256A23.0039EC1385256A23@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.general,sybase.public.sqlserver.nt
Lines: 38
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.general:1992 sybase.public.sqlserver.nt:398
Article PK: 1073052

Are you using the DirectConnect for MS-SQL or DirectConnect Anywhere between
the Sybase ASE and the MS-SQL Server? Microsoft made changes to the
TDS protocol so that direct connections no longer work properly in many cases.

-bret

frederic.cardoso@dcmc.creditlyonnais.fr wrote:

> Hello do you do know why when i try to delete an existing sybase server
> record or insert or call a stocked procedure i get an error message : (with
> client sybase 12)
>
> SQL analyzer code for delete :
> "delete from DS_CATS_INT.cats_int.dbo.TmpProduct where productId='riri'"
>
> i get this error message :
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: Unspecified error]
> [OLE/DB provider returned message: You can't have multiple recordsets with
> this cursor type (in a transaction.) Either change the cursor type, commit
> the transaction, or close one of the record sets.]
>
> If i made a select : everything is ok :
> select * from DS_CATS_INT.cats_int.dbo.TmpProduct
> i got a correct reply.
>
> If i try an insert via a stored procedure :
> "exec DS_CATS_INT.cats_int.dbo.ProductManager 'riri'"
>
> I got this error message :
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionCheckForData
> (PeekNamedPipe()).
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connexion interrompue.
> Connection Broken
>
> Anyone got an idea about this problem ?
>
> Thanks a lot
> Frederic


Bret Halford Posted on 2001-04-05 05:42:12.0Z
Message-ID: <3ACC05B3.D55BA2EC@sybase.com>
Date: Wed, 04 Apr 2001 23:42:12 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: MS SQL Server 7.0 error when trying to insert or delete a record in sybasebase from SQL 7.0 analyser
References: <B79DABF7F2807C890039EC0485256A23.0039EC1385256A23@webforums> <3ACBAB16.249BBE24@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.general,sybase.public.sqlserver.nt
Lines: 15
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.general:1979 sybase.public.sqlserver.nt:395
Article PK: 1073032


Bret Halford wrote:

> Are you using the DirectConnect for MS-SQL or DirectConnect Anywhere between
> the Sybase ASE and the MS-SQL Server? Microsoft made changes to the
> TDS protocol so that direct connections no longer work properly in many cases.
>
> -bret

Just to clarify: What I mean is that on earlier versions, Sybase clients were
perfectly
compatible with MS-SQL. With the new change, Sybase clients may sometimes work,
but there are some problems, and you have to use DirectConnect to get a
trouble-free
connection.

-bret


frederic.cardoso Posted on 2001-04-05 14:03:50.0Z
From: frederic.cardoso@dcmc.creditlyonnais.fr
Date: Thu, 5 Apr 2001 10:03:50 -0400
Newsgroups: sybase.public.sqlserver.general,sybase.public.sqlserver.nt
Subject: Re: MS SQL Server 7.0 error when trying to insert or delete a record in sybasebase from SQL 7.0 analyser
Message-ID: <7779D2C9120B64F4004D419885256A25.00225BDC85256A25@webforums>
References: <B79DABF7F2807C890039EC0485256A23.0039EC1385256A23@webforums> <3ACBAB16.249BBE24@sybase.com> <3ACC05B3.D55BA2EC@sybase.com>
Lines: 8
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.general:1973 sybase.public.sqlserver.nt:394
Article PK: 1073044

In fact i just use odbc with a user dsn declare in odbc administrator (i
don't know what is directconnect)
to connect from Msq Sql Analyser to Sybase serveur.
The driver odbc is provided with open client 12 (idem with odbc driver
provided with infomaker)!
and i'm just able to query select * but no delete or insert !?
thanks a lot
Frederic