Using iSeries as linked server in SQL Server 2012 Express

5,020 pts.
Tags:
AS/400
iSeries
Linked Server
SQL Server
I downloaded SQL Server 2012 Express in order to attempt to create a database on a PC which has links to data living on our iSeries. I can't use the OLE DB2 extension from Microsoft since it doesn't work on SQL Server Express. So, I figured out (with Google's help) that I could run this script to get a linked table: (redacted)
USE main_db
GO
EXEC sp_addlinkedserver 
   @server = 'iSeries', 
   @srvproduct = '',
   @provider = 'MSDASQL',
   @provstr = 'DRIVER={iSeries Access ODBC Driver};SYSTEM=275.96.445.92;DBQ=mydefaultlib'
GO
This got it to show up as a linked server. Then, I go into the properties for that linked server and set the security to use my iSeries username/password. I can drill down into the list of files in the library I specified, but when I try to execute a select statement (select * from [ISeries].[serial#].[ELEMENTB].[file];), I get:
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "MSDASQL" for linked server "iSeries" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7330, Level 16, State 2, Line 2
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "iSeries".
What do I need to do? Am I missing a step?

Software/Hardware used:
Windows 7 Pro, SQL Server 2012 Express RC0, iSeries, AS400
ASKED: January 13, 2012  6:12 PM
UPDATED: March 17, 2012  6:02 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following