[AccessD] Connection to AS400?

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




More information about the AccessD mailing list