0

I want to connect the Firebird database with Entity Framework Model. Completed the successful installation and created the database. But, I am facing the issue 'Index was outside the bounds of the array' while connecting the database. Refer the below image. enter image description here

  • Visual Studio 2015
  • Firebird client version 4.10.0.0
  • DDEX Provider version 3.0.2.0
  • Firebird setup v3.0.4

I followed the steps as suggested in this link. But I choose 'Embedded Server' as server type. https://firebirdsql.org/file/documentation/reference_manuals/fbdevgd-en/html/fbdg30-efw-vs-prepare.html

After done the above configurations, I faced the below.

Unable to load dll 'fbembed': The specified module could not be found. (Exception from HRESULT:0x8007007E)

So, I set 'fbclient.dll' as a client library in the advanced option. After that I am facing this error 

Index was outside the bounds of the array

enter image description here

What I have done wrong here? Please correct me.

Kathir Subramaniam
  • 1,195
  • 1
  • 13
  • 27
  • What version of Visual Studio, what version of the Firebird ado.net provider, what version of the Firebird DDEX provider? Exactly what steps did you follow to get to this error? – Mark Rotteveel Feb 28 '19 at 14:16
  • while probably not related here, "NONE" for Charset is dangerous settings – Arioch 'The Feb 28 '19 at 15:17
  • @MarkRotteveel, Now I have added those details in the description. I followed the steps as suggested in this link https://firebirdsql.org/file/documentation/reference_manuals/fbdevgd-en/html/fbdg30-efw-vs-prepare.html – Kathir Subramaniam Mar 01 '19 at 05:24
  • @Arioch'The I tried the charset 'UTF-8' and that too not working. But I dont know what should be the correct charset settings here. – Kathir Subramaniam Mar 01 '19 at 05:26
  • 1
    Have you tried upgrading to a more recent version of the Firebird ado.net provider? – Mark Rotteveel Mar 01 '19 at 07:18
  • 1
    @KathirSubramaniam UTF-8 is ok, or any other where exist all letters you and your clients might need. Just Firebird need to know to which encoding to translate texts when shuffling between your program and database. – Arioch 'The Mar 01 '19 at 08:10
  • @MarkRotteveel, I tried with the latest Firebird version (6.4.0), but 'Firebird Data Sources' was not listed in Data Sources list. So, I again downgraded them to v4.10.x and now I am facing that previous error 'Index was outside the bounds of the array'. I set 'fbclient.dll' as client library in 'Advanced' option. Is that correct? – Kathir Subramaniam Mar 04 '19 at 06:39
  • @KathirSubramaniam That is only used when you use an embedded connection, and the default doesn't use that. I suggest that you take this to the firebird-net-provider Google group. – Mark Rotteveel Mar 04 '19 at 08:17

0 Answers0