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

2 posts in Windows NT Last posting was on 2001-04-05 03:36:48.0Z
frederic.cardoso Posted on 2001-04-03 10:34:46.0Z
From: frederic.cardoso@dcmc.creditlyonnais.fr
Date: Tue, 3 Apr 2001 06:34:46 -0400
Newsgroups: 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: <01F5FFDB151D9A37003A1D9885256A23.003A1DA685256A23@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.nt:997
Article PK: 1087604

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


Jim Egan Posted on 2001-04-05 03:36:48.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: MS SQL Server 7.0 error when trying to insert or delete a record in sybase base from SQL 7.0 analyser
Date: Wed, 4 Apr 2001 21:36:48 -0600
Message-ID: <MPG.15359639570dc3c998b24e@forums.sybase.com>
References: <01F5FFDB151D9A37003A1D9885256A23.003A1DA685256A23@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.nt
Lines: 9
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:988
Article PK: 1087596

Is it possible that you are trying to perform multiple operations on the same connection.
In the past the connection was a like a pipeline. You could only have stuff going one way.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com