Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: connect to informix

    I use query string

    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open = "Dsn='iqdb'; " & _
    "Driver={INFORMIX 3.81 32 BIT}; " & _
    "Host=name; " & _
    "Server=sname; " & _
    "Service=sqlturbo; " & _
    "Protocol=onsoctcp; " & _
    "Database=iqdb; " & _
    "UID=user; " & _

    connect to informix But It's not work.
    This is Error Message
    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    I use windows XP
    Driver Informix 3.81 32 BIT
    Who has problem like me or know something to correct it plz tell me.
    (This Driver download form

    I Think I use the wrong query string that not support this driver????
    I'm not sure.
    Or I must change driver??????......where I can download????

    Thank for your help!!

  2. #2
    Join Date
    Apr 2003
    In order for this connection to work you must have already set up a DSN called "iqdb" on your XP machine. Once you've done this correctly then you only need to quote the DSN name in your connection string as follows:

    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open = "Dsn=iqdb"

    It's as simple as that.

    Good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts