Link to home
Start Free TrialLog in
Avatar of Itatsumaki
Itatsumaki

asked on

MS ODBC Crashes on All Connection Tests

Hi,

Weird bug with XP ODBC Administrator: is this normal?

It's a patched version of XP, with the most recent Oracle server (9.2+).  I didn't add the client libs on top, and I removed the Apache post-install.

I'm trying to set up a DSN for DBD::ODBC perl access.

From the ODBC Administrator I select:
System DSN->Add->Oracle in OraHome92

Now, no matter what I enter/select clicking test connection gives the error dialogue:

Unable to connect
SQLState=IM004
[Microsoft][ODBC Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV

I tried looking up SQLAllocHandle, and it looks like it should be deprecated in ODBC 3+, so I checked the ODBC Core components versions, and all are 3.520.7713 or 3.520.9030 or 3.520.9041

Any suggestions for a work-around, and can anyone replicate?
ASKER CERTIFIED SOLUTION
Avatar of seazodiac
seazodiac
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Itatsumaki
Itatsumaki

ASKER

Thanks seazodiac, I'll try it.  I won't get back to that site until Monday, so I haven't forgotten the question.  Thanks also for mentioning metalink: I didn't know it existed until I wondered and googled it just now.
Worked like a charm, thanks.