MartyConnelly
martyconnelly at shaw.ca
Wed Jun 9 19:44:12 CDT 2004
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#OLEDBProviderForAS400FromIBM 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