ODBC .NET & Informix

[DanSheath]

Hi

I am trying to connect .NET to Informix via ODBC

This is my connection string,

Dsn=authlive;Driver={INFORMIX 3.32 32 BIT};Host=uranus;Server=authlive;Service=sqlexec1;Protocol=olsoctcp;Database=authority;UID=gis;PWD=5eemap5

However, I get this error when I try to connect

Message: ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [IM009] [Informix][Informix ODBC Driver]Unable to load translation DLL.

Has anyone got any idea what could be causing this.

Many thanks

Dan

 

[vpshriyan]

Dan, not very sure but it looks some access componants are missing at local setup.

Have you installed/updated your MDAC (Microsoft Data Access Componants)? If not go to the Microsoft website and do a search on MDAC.