This topic is locked

dbcommon.asp, line 161 error

3/4/2010 1:46:30 PM
ASPRunnerPro General questions
A
adamsville2k author

Hi,
We use ASPrunner for a while and use to query an Informix database stored on a SCO Unix server. We replaced it wuth Linux and nos use infomix-Connect instead of SQL Retriever. I try to recreate the script and always end up with the following:
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/ASP/Employes/output/include/dbcommon.asp, line 16
DBconection.asp file seems not to have all the DSN entry and only got this:
<%

strConnection = "DSN=OGCInformix;UID=sqlret;PWD=sqlret"

%>
I did configure ODBC connection well because I usee it with MS SQuery and the connection to the Informix server works just well. It's like ASP Runner doesn't include the whole string... What should be there in this file to make it work? Same result if I use ODBC driver dialogue.
Thanks in advance.
Amiro2k

Sergey Kornilov admin 3/4/2010

Amiro2K,
if you know the whole connection string - put it to include/dbconnection.asp file and give it a try.
Btw, ASPRunnerPro 6.2 is able to connect via connection string as well.

A
adamsville2k author 3/5/2010



Amiro2K,
if you know the whole connection string - put it to include/dbconnection.asp file and give it a try.
Btw, ASPRunnerPro 6.2 is able to connect via connection string as well.


well I don't know the conection string or the syntax so I can't do it manually.

Sergey Kornilov admin 3/5/2010

I see what you saying.
Two things you can check:

  1. Make sure you create System ODBC DSN so IIS user can access it as well.
  2. If you run generated app on the server make sure the same DSN (OGCInformix) is created on the server as well.
    Just in case here are examples of connection strings for Informix:

    http://www.connectionstrings.com/informix

A
adamsville2k author 3/8/2010



I see what you saying.
Two things you can check:

  1. Make sure you create System ODBC DSN so IIS user can access it as well.
  2. If you run generated app on the server make sure the same DSN (OGCInformix) is created on the server as well.
    Just in case here are examples of connection strings for Informix:

    http://www.connectionstrings.com/informix


Thanks. i'll have a look at those connection strings and see whether or not it works.