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 .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
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 .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