January 11, 2007 at 8:44 am
Hi All,
I have seen numerous threads related to the above, however nothing seems to help me with the errors as stated below. I have tried numerous formats to no avail :
dbcc traceon (7300, 3604)
insert OPENQUERY(INVENT, 'select servername, databasename from sqlserver_backup')
values('TEST', 'TEST')
insert into INVENT.foo.dbo.sqlserver_backup' values('TEST', 'TEST')
All fail with :
Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IColumnsInfo::GetColumnsInfo returned 0x80004005: The provider did not give any information about the error.].
This is from Sql Server 2000 to Sybase 12.5.1.
Select statements work fine. Any help would be greatly appreciated.
January 12, 2007 at 6:37 am
Hello,
The Hexadecimal error returned by OLEDB (0x80004005) is 'Access Denied' which could indicate a permissions problem.
Does the user have permission to insert data?
Can you try specifiying the columns explicitly in the insert?
January 12, 2007 at 9:41 am
I'm using the sa account, which also created the object.
I've also tried the full column list and still have the same problem.
Cheers
January 12, 2007 at 9:52 am
Can you perform an insert using a different client and the same ODBC DSN that you are using in the linked server? (suggesting perhaps a linked table in access)
Also, have you tried an OLEDB driver for sybase instead of ODBC? I've had numerous problems getting ODBC drivers to work, and much better luck with OLEDB.
January 12, 2007 at 10:25 am
Another thing would be to try:
SET XACT_ABORT ON
before the update.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply