Informix ODBC and asp
Posted in 1999
Topics: Connectivity: ODBC / JDBC / .NET, Internationalization & Character Sets
Hi, I have done an web-application using asp script. When using odbc drivers from oracle, sybase and MS it works fine, but when i use an informix driver it will not work. I have configure an odbc datasource which i can use with a query-tool, but when i use it in my asp it return: [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories. I have dowloaded a driver from openlink, but it also failed and return: [OpenLink][ODBC][Driver]Connection rejected by data source. There seems to bee some missconfiguration in my informix api. Is there anybody who can help me with this problem, please. best Lennart Johansson Lennart.Johansson@lule.frontec.se
Hi Lennart Connection Rejected by Datasource is a generic error message. You have not indicated whether you are using our MT(Client/Server) or ST(Client Installation) product. What I would suggest is that you initially try using the drivers with our sample application to get them working. It would be easier to debug that way. If you are using the ST drivers, you need to ensure that Informix-Connect is installed on the client. The advantage therefore would be to use the MT product as this way, you can connect to all your DB servers using the Openlink Agents. If you have not got Informix Connect installed, you will not be able to make a connection. Please indicate what product you are using. Look forward to hearing from you In article <3782F4D6.FD77F747@lule.frontec.se>, Lennart Johansson <Lennart.Johansson@lule.frontec.se> wrote: > Hi, > > I have done an web-application using asp script. When using odbc drivers > from oracle, sybase and MS it works fine, but when i use an informix > driver it will not work. I have configure an odbc datasource which i can > use with a query-tool, but when i use it in my asp it return: > [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale > categories. I have dowloaded a driver from openlink, but it also failed > and return: [OpenLink][ODBC][Driver]Connection rejected by data source. > > There seems to bee some missconfiguration in my informix api. Is there > anybody who can help me with this problem, please. > > best > Lennart Johansson > Lennart.Johansson@lule.frontec.se > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.
Also, on the server-side, the "locale categories" related message means that you haven't properly set up all your Informix environment variables, i.e., INFORMIXSERVER INFORMIXDIR HTH, Stephen In article <3782F4D6.FD77F747@lule.frontec.se>, Lennart Johansson <Lennart.Johansson@lule.frontec.se> wrote: > Hi, > > I have done an web-application using asp script. When using odbc drivers > from oracle, sybase and MS it works fine, but when i use an informix > driver it will not work. I have configure an odbc datasource which i can > use with a query-tool, but when i use it in my asp it return: > [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale > categories. I have dowloaded a driver from openlink, but it also failed > and return: [OpenLink][ODBC][Driver]Connection rejected by data source. > > There seems to bee some missconfiguration in my informix api. Is there > anybody who can help me with this problem, please. > > best > Lennart Johansson > Lennart.Johansson@lule.frontec.se > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.
Hi Lennart With regards this error. There is one thing I don;t believe I mentioned in our previous conversations. If you have Setnet Installed, please log in as the Informix DBA, run setnet and ensure that the Informixdir, InformixServer have been set up properly because without these been setup, you would not be able to connect at all. HTH In article <3782F4D6.FD77F747@lule.frontec.se>, Lennart Johansson <Lennart.Johansson@lule.frontec.se> wrote: > Hi, > > I have done an web-application using asp script. When using odbc drivers > from oracle, sybase and MS it works fine, but when i use an informix > driver it will not work. I have configure an odbc datasource which i can > use with a query-tool, but when i use it in my asp it return: > [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale > categories. I have dowloaded a driver from openlink, but it also failed > and return: [OpenLink][ODBC][Driver]Connection rejected by data source. > > There seems to bee some missconfiguration in my informix api. Is there > anybody who can help me with this problem, please. > > best > Lennart Johansson > Lennart.Johansson@lule.frontec.se > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.