Mathematica 7 and ODBC problems on Windows OS 2008

I'm setting up a replacement server. Mostly it runs Mathematica jobs. I set up the ODBC connections on the new box to be the same as on the old box, but when Mathematica tries to conn开发者_开发问答ect, using

testConn=OpenSQLConnection[JDBC["odbc","MyODBCName"]]  

I get

JDBC::error: [Microsoft][ODBC Driver Manager] Invalid string or buffer length  

Searching on this mostly finds other people with related problems. Some references to 32/64 bit Java issues. I have Java 1.6.0_24 (32 bit) on the new server, 1.6.0 on the old. And Wolfram has not responded yet. Some programs that don't use ODBC to connect work fine on the new box.

Software versions are Mathematica 7, MS SQLServer 2008 on both boxes, Windows Server 2008 on the new one and Server 2003 on the old one. I created ODBC connections using both the 32 and 64 bit versions of odbcad32.exe

What am I missing, what didn't I tell you and what do you suggest? Thanks, **kent

---

Some people have had success by installing the Microsoft Access Database Engine 2010 Redistributable. Even though this update says "Access" in the title, it might be relevant to your problem because it also updates the ODBC framework itself.