#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2004
    Posts
    4
    Rep Power
    0

    Numeric fields always 0 with FB ODBC driver


    Hi,

    I am using XTG Systems FB ODBC driver to acces a FB database from Visual Basic using ADO Objects. Everything works fine except for numeric -non integer- fields, I always get a 0 for those fields. I don't know if I am doing something wrong in Visual Basic, or the problem comes from the driver ???
    In Visual Basic I just use a ADODB Recordset and access the fields with the ! operator.

    Thanks,

    Trini.
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24
    Originally Posted by trini
    Hi,

    I am using XTG Systems FB ODBC driver to acces a FB database from Visual Basic using ADO Objects. Everything works fine except for numeric -non integer- fields, I always get a 0 for those fields. I don't know if I am doing something wrong in Visual Basic, or the problem comes from the driver ???
    In Visual Basic I just use a ADODB Recordset and access the fields with the ! operator.

    Thanks,

    Trini.
    Try the open source version , see if it works for you .
    Click on the first link "Installable Windows Snapshot"
    http://ibphoenix.com/main.nfs?a=ibph...ge=ibp_60_odbc
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2004
    Posts
    4
    Rep Power
    0
    Thanks for the reply ... Ok, in Visual Basic, with the driver you suggested I get the right values for the numeric fields, but unfortunately, in VBA, from where I need to access the database, the driver does not work -I get an exception when trying to access data in a recordset-

    Could anyone suggest any other driver or solution to this?

    Thanks a lot.

IMN logo majestic logo threadwatch logo seochat tools logo