Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Posts
    17

    Unanswered: ADO/OLEDB (Visual Basic/Universe)

    Im developing program in Visual Basic conecting Universe by
    ADODB connection . I not got the connection and I need some
    sample to continue my project.
    IBM and Informix doesn't help me this way . I really need some help, because I dont
    know what else I can do , its very dificulty to understant
    without sample.
    PLEASE, HELP ME

    Thank you for all

    Scipione.

  2. #2
    Join Date
    Nov 2002
    Posts
    10

    Re: ADO/OLEDB (Visual Basic/Universe)

    You can try this, I successfully create connetion from VB to Informix.
    Using the following connection codes:

    This is use to establish the connection.
    Set rdoCon = New rdoConnection
    With rdoCon
    .Connect = "DSN=odbcname;uid=username;pwd=password"
    .LoginTimeout = 14400
    .EstablishConnection rdDriverNoPrompt
    End With

    This is how I use to get/query data from Informix
    strSQL = "select * from table where id = '" & txtid.Text & "'"
    Set rdoRes = rdoCon.OpenResultset(strSQL)
    If rdoRes.EOF Then
    MsgBox ("Invalid Login! Please Try Again!")
    Else
    row_count = rdoRes.RowCount
    End If
    After the rdoRes executed, you can use the rdoRes(#) to refer to the field.

  3. #3
    Join Date
    Nov 2002
    Posts
    17

    OLEDB

    tn5353,

    In fact Ive tried to do this but I couldnt get successfull... I dont know what happens. Could I send my project for you in order you take a look and help me???

    Thanks a lot!!!

    Scipione.

  4. #4
    Join Date
    Nov 2002
    Posts
    10

    Re: OLEDB

    Yes, you can!

  5. #5
    Join Date
    Dec 2002
    Posts
    12

    Re: OLEDB

    I am trying to import some data into sql server from unidata rdbms on a unix machine. Can you pass on some info of how to do this one.
    Please

    I was trying to connect to unidata rdbms by using unidata odbc driver but for some reason this driver is not able to recognize sql complaint unidata tables.
    Please throw some light on this

    Thank You
    Krishna

Posting Permissions

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