November 30, 2004 at 12:43 pm
I am a newbie to SQL Server and need some assitance. We are running SQL Server 2000 with SP3 on Windows 2000. we have a linked server to a DB2 environment (z/OS) using an IBM DB2 OLEDB driver. We are using OPENQUERY to insert data into the DB2 tables on z/OS. We could not insert until we enabled the "allow in process" memory option. When we disabled it and rebooted the server the insert still works as if it were still enabled. We don't want it enabled as we ran out of memory once already and it brought the server to it's knees. We assumed the insert would not work after disabling it but it does. Has anyone out there run into this before? I welcome any input! Here is the error we were getting:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]
[OLE/DB provider returned message: [IBM][CLI Driver] SQLSTATE=]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].
November 30, 2004 at 1:33 pm
I need to clarify this from my original post (sorry, I was unaware of some changes):
We are running SQL Server 2000 with SP3a and DB2 Connect Enterprise Edition 7 fixpack 13.
AND...we get a 7311 message when the "allow in process" option is disabled not the 7399 as originally posted.
Error 7311: Could not obtain the schema rowset for OLE DB provider "UNKNOWN". The provider supports the interface, but returns failure code when it is used. OLE DB error trace [OLD/DB Provider "UNKNOWN" IDBSchema Rowset::Getrowset returned 0x800703e6:]
THANKS in advance for any input on this thread!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply