Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

SQL Server to AS/400

Hi..  I am trying to connect SQL server to AS/400.  
I believe we setup a DSN to AS/400 and use OLE DB to connect SQL Server to that DSN and get this problem..
Any suggestions?

Server: Msg 7399, Level 16, State 1
OLE DB provider `MSDASQL` reported an error. A provider-specific error
occurred.
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver`s
SQLSetConnectAttr failed]
[OLE/DB provider returned message: [IBM][Client Access ODBC Driver
(32-bit)][DB2/400 SQL]Communication link failure. COMM RC=0x3]"
0
Sieger
Asked:
Sieger
1 Solution
 
samic400Commented:
Are you using Client Access as means of connecting to AS400?
0
 
SiegerAuthor Commented:
Yes i am.
0
 
mfaustCommented:
I've experience this same problem.  I beleive it may be a shortcoming of the Client Access OLE DB provider.  A workaround would be to create an ODBC datasource to the 400 and connect through that instead.  We've done this and it works well.
0
 
MoondancerCommented:
Please update and finalize this old, open question.
Moondancer
0
 
aaronkempfCommented:
ive had the same problem; and i dont think that mFausts' answer is anything revolutionary..

i cant create the ODBC, or the OLE connection using V4 of the As400 Client Access Express drivers.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now