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

    Join Date
    Apr 2006
    Posts
    5
    Rep Power
    0

    [VB 6.0 + ODBC + Fb Embed] Problem with character set...


    Hi !


    I'm using WIN1250 character set in my database.


    But i can't configure properly my ODBC driver...
    (Control Panel -> Administrative Tools -> Data Sources (ODBC) -> System DNS -> Firebird Driver -> Character set)


    When I set it to "NONE" I can compile and run my program. But it crashes when I'm trying to add new record to my database - I receive an error during insert statement ( [ODBC Firebird Driver][Firebird] CHARACTER SET WIN1250 is not installed)


    And when i set it to "WIN1250" and compile my program it crashes instantly and displays an error:
    [ODBC Firebird Driver] bad parameters on attach or create database. CHARACTER SET WIN1250 is not defined.



    I think I know where the problem may be... Embedded version of Firebird contains "intl" directory with "fbintl.conf" and "fbintl.dll" files. And these must be in the same directory as my program.


    And when i publish my program, vb 6.0 makes a .exe of my program, i copy these 2 files to the same catalog and i run my program from .exe everything works OK. ( no matter what character set i choose in System DNS configuration panel)


    Question is - what should I do to work correctly with my database from VB 6.0 ?

    Please help...
    maciak
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    540
    Originally Posted by maciak
    ... I think I know where the problem may be... Embedded version of Firebird contains "intl" directory with "fbintl.conf" and "fbintl.dll" files. And these must be in the same directory as my program.
    ...
    I seem to remember that it's a known problem and your diagnosys should be right.
    Act accordingly
  4. #3
  5. #4
  6. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2006
    Posts
    5
    Rep Power
    0
    Thanks pabloj



    I think i know the answer.

    To get everything work these three steps must be done:

    1) Charset properity in ODBC driver must be set to "NONE",

    2) In vb 6.0 you must compile your program by choosing "File" -> "make abc.exe" ( where "abc" is your program's name) instead of Run -> Start (or just pressing F5 key). Doing so makes a .exe file of your program.

    3) In the same place, where is your .exe program, you must copy "intl" directory with "fbintl.conf" and "fbintl.dll" files.

    Now, when you run your program by clicking twice on .exe file, everything works ok

    Hope these helps anybody in the future

    maciak

IMN logo majestic logo threadwatch logo seochat tools logo