Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Quick ODBC connectivity not working like DSN

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Quick ODBC connectivity not working like DSN

    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 Con1.Open "Driver={Client Access ODBC Driver (32-bit)};System=XYZ;Uid=ZZZZ;Pwd=ZZZZZ" in lieu of Con1.Open "DSN=USSO;UID=ZZZZ;PWD=ZZZZZ;" 'Connect to AS/400 this connects all right but get a run time error on line rs.Open Cmd1 and the recordset is not being returned. Any ideas would be appreciated.
    Code

  • #2
    Quick ODBC connectivity not working like DSN

    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: http://publib.boulder.ibm.com/infoce...aiiodbcadm.htm

    Comment


    • #3
      Quick ODBC connectivity not working like DSN

      Mike Gobbi wrote: > 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 > > Con1.Open "Driver={Client Access ODBC Driver > (32-bit)};System=XYZ;Uid=ZZZZ;Pwd=ZZZZZ" But Mike, you specifically refer to the Driver in this statement. If it's not installed, it's not going to work. > in lieu of > > Con1.Open "DSN=USSO;UID=ZZZZ;PWD=ZZZZZ;" 'Connect to AS/400 > > this connects all right but get a run time error on line > > rs.Open Cmd1 > > and the recordset is not being returned. > Any ideas would be appreciated. All you've accomplished is an attempt to use the ODBC driver without a pre-defined Data Source Name. As Pat mentions, the driver has to be installed on the PC. Bill

      Comment

      Working...
      X