ODBC issues running Notes agents on a Windows 2008 64 bit server

maximjon
maximjon used Ask the Experts™
on
I recently migrated one of our Lotus Notes databases over to a new Windows 2008 64 bit server.  This database was previously on a Windows 2003 32 bit server.  The database contains scheduled agents that query our DB2/400 files on our iSeries box via ODBC and then compose emails displaying the data in tables.

When these agents run now on the new 64bit server, all numeric values show up in the tables but for some reason, the text values are not displaying.

I'm guessing the problem has to stem from the ODBC drivers on the server?  I checked the system DSN's on both the Windows 2003 32bit and Windows 2008 64 bit servers and they're setup identically.

Any advice is appreciated.  Thanks,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Groupware Consultant
Commented:
There seem to be issues with 64-bit ODBC-drivers, I suggest searching the Internet.

Here's a page that might already help:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.odbc&tid=2578e110-e8b2-4ad0-9769-cb033dc999cf&cat=&lang=&cr=&sloc=&p=1

My 2 cents...
Agree with sjef_bosman.  If the agents are the same, they should still be using 32 bit ODBC drivers, which need to be checked by C:\Windows\SysWOW64\odbcad32.exe.  The ODBC drivers listed under Control Panel are 64bit.

Author

Commented:
We setup another Windows 32 bit server instead.  I ended up scheduling the agents to run on this box as a work around
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Sjef BosmanGroupware Consultant

Commented:
Wow, a "C"... Why?? Was it such a poor-quality answer, didn't it qualify as "any advice"?

Author

Commented:
I apologize for the 'C' rating.  I didn't realize what it entailed when I picked it or that it even effects the Experts overal performance score.  I just saw that it was labeled 'average' so I picked it.  Is there anyway I can change it now?
Sjef BosmanGroupware Consultant

Commented:
It does affect the score, albeit slightly. I'm not too fond of "C"'s, so I always ask why I got one, but in this case the answer I gave isn't excellent or beyond expectation ("A"), it isn't even a good answer ("B"), so a "C may be the right thing if the answer was barely helpful.

You can ask (Request Assistance) to reopen the question, or to modify the grade. It's up to you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial