<div>
Are you using Client Access as means of connecting to AS400?<br />

</div>


Are you using Client Access as means of connecting to AS400?


<div>
I've experience this same problem. &nbsp;I beleive it may be a shortcoming of the Client Access OLE DB provider. &nbsp;A workaround would be to create an ODBC datasource to the 400 and connect through that instead. &nbsp;We've done this and it works well.
</div>


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.

<div>
Please update and finalize this old, open question.<br />
Moondancer
</div>


Please update and finalize this old, open question.
Moondancer

<div>
<div class="content wysiwyg-content">
Hi.. &nbsp;I am trying to connect SQL server to AS/400. &nbsp;<br />
I believe we setup a DSN to AS/400 and use OLE DB to connect SQL Server to that DSN and get this problem.. <br />
Any suggestions?<br />
<br />
Server: Msg 7399, Level 16, State 1<br />
OLE DB provider `MSDASQL` reported an error. A provider-specific error<br />
occurred.<br />
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver`s<br />
SQLSetConnectAttr failed]<br />
[OLE/DB provider returned message: [IBM][Client Access ODBC Driver<br />
(32-bit)][DB2/400 SQL]Communication link failure. COMM RC=0x3]&quot;<br />

</div>
</div>


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]"


SQL Server to AS/400

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.