• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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