[AccessD] ODBC connection to AS400

Hello,

I know that he following link gives somme info about the connection string to use when linking Access with AS400, using ADO and OLEDB.
There is also a link to the IBM redbook.

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForAS400FromIBM

HTH,

Philippe




----- Original Message ----- 
From: "James Hale" <jhale at houston.rr.com>
To: <AccessD at databaseadvisors.com>
Sent: Thursday, March 06, 2003 4:24 AM
Subject: [AccessD] ODBC connection to AS400


> Using the IBM client Access ODBC driver I have links to tables residing on
> the AS400. If I open these tables to view the AS400 gives me exclusive use
> of the file. The problem is it never releases the table for use by others
> until I quit Access. Does anyone know how to release the table? Similarly,
> if someone has use of the table and I try to open it I get an ODBC
> connection failed error. What is the correct way to trap for this error? TIA
> Jim Hale
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030306/a33e8687/attachment-0001.html>