Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Unanswered: IBM-Informix Setnet32

    Hi there any Informix ODBC experts,
    Need your help here.
    I was configuring the datasource using above when I had
    this error when i try to save the configuration.

    "Could not open the registry"

  2. #2
    Join Date
    Oct 2003
    Posts
    20
    Try to fill INFORMIXSQLHOST=<machine> environment variable

    Marcelo E.

  3. #3
    Join Date
    Oct 2003
    Posts
    5
    Originally posted by marceloespinosa
    Try to fill INFORMIXSQLHOST=<machine> environment variable

    Marcelo E.

    Thanks Marcelo.
    I have now solved the problem and is able to connect to the database.
    I could now see the tables after the connection.
    However when I execute the VB programs, I get an error
    "Informix ODBC Driver-No SELECT permission"
    It also has this message
    "Method 'Refresh of object IAdodc' failed.
    Following is the VB code:
    ---------------------------------
    Private Sub disp_Click()

    adodc1.RecordSource = "select t_suno, t_nama, t_namb from baan.ttccom020800 where t_suno >= " & Trim$(rm1.Text) & " and t_suno <= " & Trim$(rm2.Text)

    adodc1.Refresh


    Set DataGrid1.DataSource = adodc1

    End Sub
    ---------------------------------------------------------------------
    I am using VB6 and Informix 7.3 and SDK2.81 for access.

    What is this error???
    Thanks and best regards,

    ks wong
    Last edited by kswong; 10-14-03 at 21:50.

  4. #4
    Join Date
    Oct 2003
    Posts
    20
    Hi,

    If you have some tool to view the data like dbaccess, try to put your SELECT statement in this and run, if you get a same error then give GRANT permissions to user:

    GRANT CONNECT TO PUBLIC

    Marcelo E.

  5. #5
    Join Date
    Oct 2003
    Posts
    5

    ODBC -call failed

    Hi Marcelo,
    Thanks again for the idea, we have change the user to informix
    and the program does not show the error anymore. However
    no data are returned.
    When I use Visdata in VB6 to open the ODBC, I have this error
    ODBC - called failed, Number 3146
    Pls help.

  6. #6
    Join Date
    Oct 2003
    Posts
    20
    Hi,

    ODBC - called failed, Number 3146

    It is not an informix error message, I don't have VB error message guide, Question: your statement work in dbaccess ?

    Don´t forget that all table and field names must be in lower case.

    Marcelo E.

Posting Permissions

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