Prev: Shared memory issue
Next: Change column Data Type from Integer to Decimal
From: cliffeh on 28 Nov 2006 14:05
Hello, I'm trying to create a linked server in Microsoft SQL Server
2005 x64 with SP1 on Windows 2003 Standard x64 with SP1 to an iSeries
with V5R2, using Client Access V5R3, service level SI24723.

I have this working using an ODBC connection on Windows 2003/SQL 2005
x86 edition, but can't get it working on the x64 version.

I'm getting various errors when I execute queries, including:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "IBMDA400" for linked server "MYISERIES" reported
an error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE
DB provider "IBMDA400" for linked server "MYISERIES"

This in spite of the fact that I've set up the remote login to run
under my name, which has appropriate permissions.

Does anyone have this configuration working? Is there a way I can link
it using ODBC? Can anyone suggest how I can look at logs or tracing
information for the request?

Thanks,
Cliffe Hodgkinson
Nichirin Inc.

 | 
Pages: 1
Prev: Shared memory issue
Next: Change column Data Type from Integer to Decimal