Urgent SQL Sybase linked server insert problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Urgent SQL Sybase linked server insert problem

Author

Topic

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-11-30 : 06:23:49

I am getting error when I try Inserting data in sybase 12.5 using linked server from SQL2K5

I am able to select

Following is the code i am using.error is same for both stmts
insert into l_syb_ibt.ibtqa.dbo.rajtest (id)values (1)
insert openquery(l_syb_ibt, 'select id from rajtest where 1=0') values (1000)

please help.thanks in advance

following is the error
OLE DB provider "MSDASQL" for linked server "l_syb_ibt" returned message "Transaction cannot have multiple recordsets with this cursor type. Change the cursor type, commit the transaction, or close one of the recordsets.".
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "MSDASQL" for linked server "l_syb_ibt" could not INSERT INTO table "[l_syb_ibt].[ibtqa].[dbo].[rajtest]".

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-02 : 01:00:08

Tried create linked server with SyBase provider?

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-12-02 : 05:22:31

I am using ODBC provider
if I change the behavior of the default cursor settings:
from 1-Direct to 0-Cursor, then the insert will work.
however, this is a shared datasource,
and i am not certain what effects it could have on other queries that rely on this system DSN
please advice

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-02 : 16:21:27

Possible to create a separate dsn with proper settings?

rajkumarrai_bis
Yak Posting Veteran

78 Posts

Posted - 2007-12-03 : 01:44:32

no not possible,DSN is used by various applications
it would require change in their code
just want to know if the changed settings can cause any kind of trouble
please advice

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-03 : 22:22:45

Then you have to test new setting with all apps.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources