Have the following program that pulls a recordset from the AS/400 from Excel. It runs great as long as an ODBC driver is created and referred to for connectivity. However, would like to avoid installing the driver manually on every users PC so tested the following line <p>Con1.Open "Driver={Client Access ODBC Driver (32-bit)};System=XYZ;Uid=ZZZZ;Pwd=ZZZZZ" <p>in lieu of <p>Con1.Open "DSN=USSO;UID=ZZZZ;PWD=ZZZZZ;" 'Connect to AS/400 <p>this connects all right but get a run time error on line <p>rs.Open Cmd1 <p>and the recordset is not being returned. <BR>
Any ideas would be appreciated. <p><!--mccodelink_begin--> <BR>
<!-- do not remove --> <BR>
<hr width=50 align=left><small><a href='http://www.mcpressonline.com/mc/showcode@@.6b3a42f3' target='_blank'>Code</a></small> <BR>
<!--mccodelink_end-->

The IBM ODBC driver is a component of iSeries Access for Windows. You will need to install and configure it on each machine using your process. For further information refer to the following link: <p><a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzaii/rzaiiodbcadm.htm">http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzaii/rzaiiodbcadm.htm</a>

Mike Gobbi wrote:<BR>
> Have the following program that pulls a recordset from the AS/400<BR>
> from Excel. It runs great as long as an ODBC driver is created and<BR>
> referred to for connectivity. However, would like to avoid installing<BR>
> the driver manually on every users PC so tested the following line<BR>
><BR>
> Con1.Open "Driver={Client Access ODBC Driver<BR>
> (32-bit)};System=XYZ;Uid=ZZZZ;Pwd=ZZZZZ"<BR>
<P>
<P>
But Mike, you specifically refer to the Driver in this statement. If it's <BR>
not installed, it's not going to work.<BR>
<P>
<P>
> in lieu of<BR>
><BR>
> Con1.Open "DSN=USSO;UID=ZZZZ;PWD=ZZZZZ;" 'Connect to AS/400<BR>
><BR>
> this connects all right but get a run time error on line<BR>
><BR>
> rs.Open Cmd1<BR>
><BR>
> and the recordset is not being returned.<BR>
> Any ideas would be appreciated.<BR>
<P>
<P>
All you've accomplished is an attempt to use the ODBC driver without a <BR>
pre-defined Data Source Name. As Pat mentions, the driver has to be <BR>
installed on the PC.<BR>
<P>
Bill <BR>
<P>
<P>