RE: ODBC 64 Bit

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.