Hi,

i'm using Gen Pro Version 2.0.0.0 Final (with selfservicing) for a Firebird 2.0 database (in .Net 2.0). First i have connected to a Firebird (Super-)Server, which is no problem. Now i want to connect via the embeded dll (Firebird-2.0.0.12748-0_embed) to a local db-file, but this fails everytime. i've copied all dll's and conf's and so on, which were in the zip file. But there comes always this message:

ORMQueryExecutionException:

An exception was caught during the execution of a retrieval query: No message for error code 335544854 found.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.

the connect to the local file via the server (parameter:severtype=0) is successfull. I can read all data. But with embeded it fails.

Does anybody know how to handle this problem???

thanks,

shennig

Hello,

with the embeded dll, this message can be throw when data are in 'uknown' charset. Could you check your fields charset?

Thanks for answering.

The database is in ISO8859_1. But if i use the parameter charset=ISO8858_1 the answer is, that this charset is unknown! This is also the case if i use the embeded version without gen pro - directly with the .net client provider for Firebird 2.0. But if i use charset=none in this case, i could access the database. With gen pro the exception above is shown.

Have i to use special charactersets? Or have i to take a special parameter for the connect string with gen pro? Or is this a problem of the dll from firebird?

Does this error happen in the connection open (so could you paste the stacktrace as well?) ? or when you want to access data? Could you also mail carlos alvarez about this (the author of the firebird provider). He has access to llblgen pro so he can test if he wants to.

Otis wrote:

Does this error happen in the connection open (so could you paste the stacktrace as well?) ? or when you want to access data? Could you also mail carlos alvarez about this (the author of the firebird provider). He has access to llblgen pro so he can test if he wants to.

I have found a solution in this thread of a firebird forum:

http://forums.devshed.com/firebird-sql-development-61/vb-6-0-odbc-fb-embed-problem-with-character-set-417804.html

With the embeded zip is provided a directory 'intl'. There are two files 'fbintl.dll' and 'fbintl.conf'. Amongst others the charset ISO8859_1 is configured in these files. You must place this directory in the directory with your application. After this you can use charset=ISO8859_1 in the connect-string and it works!