dbarkley (3/12/2012)
The error in the first part is from when I try using an ODBC connection using the IBM drivers that came with client access.The second part is when I try to use the providers in SQL to make a direct connection without ODBC, the mapping dont come across correctly.
Maybe you can try following the steps in this link.