Firebird connection DB_E_ERRORSOCCURRED(0x80040E21)

Question

I use firebird database. and C# connection use Oledb. My service running my localhost but change connection string localhost to Ip adress dont connection an error. Error description is DB_E_ERRORSOCCURRED(0x80040E21)

Web.Config Code

<?xml version="1.0"?>
<configuration>
  <appSettings/>

  <system.web>
    <compilation debug="true" targetFramework="4.5"/>

    <authentication mode="Windows"/>

    <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>
  </system.web>
<connectionStrings>
    <add name="baglantiCumlesi"        
         connectionString="Provider=LCPI.IBProvider.3;Data Source=DEDEDE; Location=E:\Publish\Data\B2C.FDB; Integrated Security=True; User Instance=True ctype=WIN1254; Persist Security Info=True; auto_commit=True; auto_commit_level=4096;dbclient_library=fbclient.dll; dbclient_type=fb2.0; Trusted_Connection=yes; connection reset=false; connection lifetime=0; enlist=true; min pool size=1; max pool size=100; User ID=SYSDBA; Password=masterkey;" 
         providerName="System.Data.OleDb"
    />
</connectionStrings>
</configuration>

C# Code

string baglantiCumlesi = ConfigurationManager.ConnectionStrings["baglantiCumlesi"].ConnectionString;

OleDbConnection baglanti = new OleDbConnection(baglantiCumlesi);
            baglanti.Open();

            string sorgu = "SELECT P.ADISOYADI, UNVANI, T.DAHILI ,'<a href=mailto:'||EMAIL||'>'||EMAIL||'</a>' AS EMAIL"+
                           " FROM PERSONEL P"+
                           " LEFT JOIN TELELINK L ON L.INTERNAL = P.PERSONEL_NO"+
                           " AND L.SINTERNAL = 'PERS' AND L.VARSAYILAN = 'E'"+
                           " LEFT JOIN TELEFONL T ON T.TELEFON_NO = L.TELEFON_NO"+  
                           " WHERE WEB_AKTIF = 'E' AND PERSONEL_NO > 0 AND BLOKE = 'H'"+
                           " ORDER BY PERSONEL_KODU";

I use debug error point sorgu.

http://i61.tinypic.com/2lapopv.png

in the oledberr.h I see this text for the error DB_E_ERRORSOCCURRED: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. — magicandre1981
– magicandre1981, Commented Oct 31, 2014 at 16:00
thx for comment but running local host I dont understand this error. Change location to localhost running but this state not running — metin
– metin, Commented Nov 1, 2014 at 7:15
Why do you use OleDB at all? Why don't you use the Firebird .Net Provider? — magicandre1981
– magicandre1981, Commented Nov 1, 2014 at 7:20
if lots of users will use this program, I have connection error — metin
– metin, Commented Nov 1, 2014 at 7:26

metin · Accepted Answer · 2014-11-01 08:54:17Z

1

Finally i'm running :) change connection string and running.

Provider=LCPI.IBProvider.3; Data Source=DEDEDE;
                Location=DEDEDE:E:\Publish\Data\B2C.FDB;ctype=WIN1254; Persist Security Info=True; 
                    auto_commit=True; auto_commit_level=4096;dbclient_library=fbclient.dll; dbclient_type=fb2.0; Trusted_Connection=yes;
                connection reset=false;connection lifetime=0; enlist=true; min pool size=1; max pool size=100;User ID=SYSDBA; Password=masterkey

answered Nov 1, 2014 at 8:54

metin

338 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dmitry Kovalenko · Accepted Answer · 2014-11-06 11:34:26Z

0

Seem, your original connection string contains the mistake:

"User Instance=True >>>;<<<< ctype=WIN1254"

:)

answered Nov 6, 2014 at 11:34

Dmitry Kovalenko

11 bronze badge

Collectives™ on Stack Overflow

Firebird connection DB_E_ERRORSOCCURRED(0x80040E21)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related