× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.




Thanks for the replies all. I found the solution so I will post it in case some else comes across this.

The latest service packs for iSeries Access, at least for V5R4 and up, contains two ODBC managers, one for 32 and one for 64 bit. A system DSN has to be created in both identically because some things want to use the 32 and some things the 64. Once I figured that out, the last thing stopping me was that I needed to add the connection string to the i in the advanced options when creating the ColdFusion ODBC Data Source specifying the User ID and Password.

Thanks, Jon




From: EDeLong@xxxxxxxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Subject: RE: ODBC 64 Bit
Date: Wed, 31 Aug 2011 15:51:23 +0000

Is Server 2008 64-bit supported? IBM isn't real clear on this...

http://www-03.ibm.com/systems/i/software/access/windows/supportedos.html

In the section for Windows Server 2008, there's a link that explains some of the noted limitations with this configuration. There seems to be all sorts of problems, but the document may be somewhat out of date...

Hth,
-Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon S
Sent: Wednesday, August 31, 2011 10:00 AM
To: midrange-l@xxxxxxxxxxxx
Subject: ODBC 64 Bit


All,

I have a customer that had a server crash and they are trying to reinstall it on Windows Server 2008 64 bit. I am trying to recreate their ODBC connections to the i. I now have two ODBC control panels, one for 32 bit and one for 64 bit. I am trying to use this through ColdFusion server. If I just create it in the 32 bit ODBC. ColdFusion does not see the data source. If I just create it in the 64 bit, I get an architecture mismatch.

If I create it in both 64 and 32 and dont specify a user name in ODBC, I get an invalid user name. If I specify the user name, I get an invalid password, length=0, so it's not sending the password and is definately using the user name from ODBC instread of ColdFusion, but there is no way to specify a password in ODBC. Does anyone have any ideas? I am chasing my tail on this one.

TIA, Jon
--
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.



--
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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.