Re: Provider Strings for AS400 data on Windows Server 2008R2 64Bit

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

What versions of iseries access, are you using 64bit versions of it as well.

On Mon, Oct 22, 2012 at 2:22 PM, Brian Piotrowski <
bpiotrowski@xxxxxxxxxxxxxxx> wrote:

> Hi All,
>
> We're in the process of migrating our web pages from Windows Server 2003
> 32bit to Windows Server 2008r2 64bit.  I've installed the 64bit ODBC
> drivers, IIS and all relative code for the website.
>
> However, when I try to connect to the AS400 I am getting this error:
>
> ==========================
>
> ADODB.Connection error '800a0e7a'
>
> Provider cannot be found. It may not be properly installed.
> ==========================
>
> I rechecked and ensured the driver was installed.  I have these two
> drivers in the ODBC manager on the 2008r2 64bit server:
>
> Name: Client Access ODBC Driver (32-bit)
> Version: 12.64.00.00
> Company: IBM Corporation
> File: CWBODBC.DLL
> Date: 11/12/2007
>
> Name: iSeries Access ODBC Driver
> Version: 12.64.00.00
> Company: IBM Corporation
> File: CWBODBC.DLL
> Date: 11/12/2007
>
>
> The connection string I am trying to use is this:
> adoCon.Open "Provider=IBMDA400.DataSource.1;Persist Security
> Info=False;User ID=<user>;Password=<password>;Data Source=<AS400 IP
> Address>"
>
> When I use the identical connect string on the old webserver I do not get
> any nasty errors.  When I try on the new webserver, I get the one above.
>
> Any ideas where I might be going wrong??  I've tried changing the
> connection strings, trying new drivers, etc., etc., but I end up with the
> same result (or some variant that is still not letting me connect).
>
> Thankee-sai!
>
> /b;
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Brian Piotrowski
> Manager - I.T.
> Simcoe Parts Service, Inc.
> Ph: 705-435-7814 x343
> Fx: 705-435-5029
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> http://www.simcoeparts.com<http://www.simcoeparts.com/>
>
> Please consider the environment. Don't print this e-mail unless you really
> need to.
>
> The information contained in this communication is confidential and
> intended only for the use of those to whom it is addressed.  If you have
> received this communication in error, please notify me by telephone
> (collect if  necessary) and delete or destroy any copies of it.  Thank you!
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.