Dan Waters
dwaters at usinternet.com
Thu Jun 10 08:44:29 CDT 2004
Marty, I did try this yesterday and got the following error: Provider cannot be found. It may not be properly installed. Thanks for this info! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly Sent: Wednesday, June 09, 2004 7:44 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Connection to AS400? Have used not this in a couple of years but there are two OLEDB providers one from MS and one from IBM This site lists a lot of valid connection strings. For IBM you will have to read their "Red Books" http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDB ProviderForAS400FromIBM Dan Waters wrote: >I am trying to connect from AXP to and AS400 MRP system using OLEDB, and I >am trying to confirm what the connection string should be. > > > >I believe this is correct: > > > >stgOLEDBProviderName = "IBMDA400" > >stgDataSource = "AS400" > >stgUserID = "UserID" '-Some UserID > >stgUserPassword = "UserPassword" '-Some User Password > > > >cnn.Open "Provider=" & stgOLEDBProviderName & ";Data Source=" & >stgDataSource & ";", stgUserID, stgUserPassword > > > > > >Also, are there any 'switches' that need to be set on the MRP side to allow >the use of OLEDB technology? > > > >Thanks! > >Dan > > > -- Marty Connelly Victoria, B.C. Canada -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com