Problems with IBX

[paweld]

If you are editing data in dataset, it is necessary to set the reverse conversion in SetText.

[FranEx]

Hi all, i've been investigating and testing. We have found that SQLdb componentes have an option UseConnectionCharSetIfNone that solve our problems with charset. And the question now, IBX has a similar option?

Wich are the diferences between IBX components and SQLdb? For me IBX seems more complete, but i don't know if SQLdb is updated (support) or have worst performance vs IBX.

Regards.

[ttomas]

Look to me like migration error from Firebird 1.5 to 3.
Can you try backup Fb1.5 database and restore in Fb3 with

Code: Pascal  [Select][+][-]

1. gbak.exe -c -user SYSDBA -pas masterkey -FIX_FSS_DATA win1252 -FIX_FSS_METADATA win1252 c:\test\mybackup.fbk localhost:c:\test\mybase.fdb
2.  

[zzzkkk]

Thanks Korba812, i've copied fbclient.dll to the lazarus directory and now IBX works in this computer.

When we connect to the db with lc_ctype = 'UTF_8' the Ñ character shows wrong, but if we put a button with this character it showns right.

pls, where specifically did you copied the dll?

[tonyw]

Thanks Korba812, i've copied fbclient.dll to the lazarus directory and now IBX works in this computer.

When we connect to the db with lc_ctype = 'UTF_8' the Ñ character shows wrong, but if we put a button with this character it showns right.

pls, where specifically did you copied the dll?

The user guide for the Firebird Pascal Interface is where you should look for guidance on where to locate the fbclient2 dll. This guide is provided with the fbintf package.

If you use the Firebird installer then IBX should always be able to find this dll. If you can't do this then the app folder should be used. Although not recommended, \windows\system32 should work. You also need firebird.msg in the same folder as the dll.

Be careful to install the 32 bit or 64 bit version appropriate to your app. These days, the 64 bit is typically the one you want.