Calling an INFORMIX datababse form ASP

When I try connection to an INFORMIX database using an ODBC connection (driver= intersolv 3.01 32bit informix)
everything goes just fine.. I can see it in the data view in Visual InterDev, but when i try

OBJdbConn.Open Session("DataConn_ConnectionString") in a page the server just says

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories.

anyone know what to do??
lulleAsked:
Who is Participating?
 
ShootThemLaterCommented:
I proposed an answer to something similar in another topic area.  Does the following help?

It may be due to user registry setup.  When you're querying with Visual Interdev, your Informix config info is stored in the
Registry key HKEY_CURRENT_USER\Software\Informix\ENVIRONMENT - this may not be set up for the user that the web is accessing Informix as (possibly, although this is drawing from experience of something else that's similar).

It is possible that even if you have everything set up correctly, for some reason it will still be trying to access as the default user.

Try copying the Informix keys from the above location to the default user (HKEY_USERS\.Default) so you will have a directory something like  HKEY_USERS\.Default\Software\Informix\ENVIRONMENT\INFORMIXDIR etc.

Also, the data source should be set up as a system DSN not a user DSN, for the same sort of reason...
0
 
lulleAuthor Commented:
Thanks for the help... but I managed to solve the problem by my "self".. found a FAQ on the net where someone told me to run regcopy... dunno why.. but it started to work...so well u´ll get the points anyway..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.