×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

insert in to DB2 Z/vse via SQL 2005 linked server

insert in to DB2 Z/vse via SQL 2005 linked server

insert in to DB2 Z/vse via SQL 2005 linked server

(OP)
Good day,
Hopefully I'm posting in the right forum. My question is regarding record inserts from MS SQL 2005 via IBM OLE DB linked server. I'm able to select, delete and update records but for some strange reason i cannot insert records via linked server. I can insert them via ODBC just fine.. using same credentials. Of course only thing that I need to do at the moment is insert records smile.Here is my query:
INSERT INTO OPENQUERY (TSTESA5, 'SELECT ENTRY_KEY FROM DON1.ETAX_ENTRY') VALUES (7)
very simple.. just add another records and make the Entry_Key 7. Entry_Key is the index..
i get the error that object has no columns or the current user doesn't have permission on that object.
I have tried different approach;
insert OPENQUERY(TSTESA5,'select Entry_Key from DON1.ETAX_ENTRY') values(8)
and get Provide could not support an interface required for the insert statment. error #7320.
Again I can update and delete just fine, and insert via ODBC so this leads me to beleive that there is something going on with linked server so i have added certain values
[TSTESA5]
DISABLEKEYSETCURSOR=1
DISABLEUNICODE=1
PATCH2=6
QUERYTIMEOUTINTERVAL=0
USESERVERKEYSETCURSOR=0
DBALIAS=TSTESA5 to the db2cli.ini file and deleted and re-created the linked server after server restart. And error persists.
Anyone have any other ideas? I'm fresh out.

Thanks

Amir


 

RE: insert in to DB2 Z/vse via SQL 2005 linked server

(OP)
We have been able to narrow it down to the IDB DB2 9.5 driver and switched to Microsoft D2 OLD DB driver and its now performing inserts just fine but seems to be performing slower the IBM driver. We are still looking for solution involving IBM driver and any help would be appriciated.

Thanks


Amir

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close