System.BadImageFormatException error while opening connection using firebird

Question

Trying to use Firebird db with c# win forms. While trying to open connection its showing me the following error.

An unhandled exception of type 'System.BadImageFormatException' occurred in FirebirdSql.Data.FirebirdClient.dll

Additional information: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

my connection string is

        <add name="dbConFirebirdSQL" connectionString="User Id=locuser_r;Password=locpassword_r;Database=LOCDBOES_R.FDB;ServerType=Embedded;" />


string sql5 = "sql query here";
                                try
                                {
                                    FbConnection con95 = new FbConnection(connectionString);
                                    con95.Open();
                                    FbCommand cmd95 = new FbCommand(sql5, con95);
                                    cmd95.Parameters.Add("@t_id", FbDbType.Integer).Value = tid;

                                    cmd95.CommandType = CommandType.Text;
                                    cmd95.ExecuteNonQuery();
                                }
                                catch (FbException ex)
                                {
                                    MessageBox.Show("4--" + ex.Message);
                                }

Please advise what could be wrong.

32 bit or 64 bit? that can cause System.BadImageFormatException — Amitd, Jan 01 '16 at 15:31
Use the x86 as target Platform for your application not AnyCPU (or x64) — Steve, Jan 01 '16 at 15:31
MyProject properties->Build->Platform target->x86 set even then it shows me the above mentioned error :( — gomesh munda, Jan 01 '16 at 15:49
Possible duplicate of [Firebird db connection string using c#](http://stackoverflow.com/questions/34561399/firebird-db-connection-string-using-c-sharp) — Mark Rotteveel, Jan 02 '16 at 08:19

score 0 · Answer 1 · edited May 21 '23 at 01:31

0

I had the same problem, and I fixed it by setting "Platform target" to "x64" instead of "Any CPU" or "x86" in the project properties:

edited May 21 '23 at 01:31

ascpixi

529
4
13

answered May 19 '23 at 21:29

Daniel Fernandez

11
3

System.BadImageFormatException error while opening connection using firebird

1 Answers1