c# - Firebird connection DB_E_ERRORSOCCURRED(0x80040E21) -

c# - Firebird connection DB_E_ERRORSOCCURRED(0x80040E21) -

i utilize firebird database. , c# connection utilize oledb. service running localhost alter connection string localhost ip adress dont connection error. error description 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>' email"+ " personel p"+ " left bring together telelink l on l.internal = p.personel_no"+ " , l.sinternal = 'pers' , l.varsayilan = 'e'"+ " left bring together telefonl t on t.telefon_no = l.telefon_no"+ " web_aktif = 'e' , personel_no > 0 , bloke = 'h'"+ " order personel_kodu";

i utilize debug error point sorgu.

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

finally i'm running :) alter connection string , running.

provider=lcpi.ibprovider.3; info 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

c# asp.net web-services connection firebird