Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Posts
    7

    Unanswered: Cannot connect to Informix database via ODBC

    I can't seem to connect my MRP system that uses IBM Informix. I'm trying to connect to it via ODBC(can do it fine in access) but I keep on getting an error when setting it up. I've attached a screen shot fo the error. Oh yeah, I'm trying to use Crystal Reports to connect to the informix database.
    Attached Thumbnails Attached Thumbnails crystal2.bmp  

  2. #2
    Join Date
    Aug 2006
    Location
    The Netherlands
    Posts
    248
    But why do you try to connect to the physical DB utility? Database Name is a logical entity and the entry should just express the name of a database that is managed by the databaseserver refered to with the Server Name entry. This Server Name should be the same as the value for the DBSERVERNAME or DBSERVERALIASES variables in the onconfig file of the databaseserver.

    Regards

  3. #3
    Join Date
    Aug 2007
    Posts
    7
    I'm using crystal reports(on a seperate server) to connect(link to the database) to my MRP server(linux based and uses IBM informix) so that I can make daily and weekly reports from production. I just cant seem to get the crystal reports server to connect to the MRP servers database, although Access can link to the database fine.

    The first attachment is a new error I'm getting now(after reinstalling Informix driver). And the other attachments are the settings I use when selecting a datasource.

    Thanks,
    Ronak
    Attached Thumbnails Attached Thumbnails crystal1.jpg   crystal2.jpg   crystal3.jpg   crystal4.jpg  

Posting Permissions

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