Menu
▾
▴
firebird-net-provider
|
From: xu y. <ank...@gm...> - 2006-09-11 02:16:41
|
how many rows in your table? it may be slowly when a lot of rows in your table 2006/9/9, Carlos Guzm=E1n =C1lvarez <car...@mu...>: > > Hello: > > > > I'm sure that the C# code is ok, I have execute the query with other > > data and it go ok. > > > > I'm using Firebird Server 1.5 and Firebird Net Provider 1.6 > > > Can you send a test case ?? What is the isolation level you are using > for the transactions ( if you are using a non default one ) ?? > Is the same thing happening on v1.7 of the provider ?? > > -- > Carlos Guzm=E1n =C1lvarez > Vigo-Spain > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim= o > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat= =3D121642 > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: Juanma f. <pa...@ho...> - 2006-09-11 11:22:47
|
<html><div style='background-color:'><DIV class=RTE>
<P>Hi, I send the next message the last week:</P>
<P>---------------------------------------------------------------------------------------<BR>I am executing the following query:<BR> <BR>SELECT * FROM HISTPRECONTA <BR>WHERE (FECHALTA IS NULL OR FECHALTA='') <BR>OR FECHALTA IN('20060907') <BR>AND NUMEMP=2<BR>AND CODEMPRESA=1<BR> <BR>When I do the query with SQL Manager 2005 Lite for Interbase and Firebird, it go well. But when I execute the query from this C# code, the dataset never is filled, and the program execution is locked, in other words, the method adapter.Fill(ds) never terminates<BR>adapter.SelectCommand=command; <BR>command.CommandText = <BR>"SELECT * FROM HISTPRECONTA <BR>WHERE (FECHALTA IS NULL OR FECHALTA='') <BR>OR FECHALTA IN('20060907') <BR>AND NUMEMP=2<BR>AND CODEMPRESA=1"<BR>ds = new DataSet();<BR>adapter.Fill(ds); //Here the program is locked and the method never returns, no exception is throwed</P>
<P>I'm sure that the C# code is ok, I has executed the query with other data and it goes ok.</P>
<P>I'm using Firebird Server 1.5 and Firebird Net Provider 1.6<BR>---------------------------------------------------------------------------------------</P>
<P>Well, in the table HISTPRECONTA there are 56 records, and the query must return 2. Before executing this query, I do the same<BR>query twice, but with NUMEMP = 0 and NUMEMP = 1, and it go ok, and execution of "adapter.Fill(ds);" is not locked. This is<BR>the C# code of the method, that is called by a foreach loop with diferents values for the parameter "codigoEmpleado":</P>
<P>public DataTable obtenerRegistrosHistorico(ConfiguracionBD conf, <BR> ArrayList columnas, <BR> string nombreTabla, <BR> string campoEmpleado, <BR> int codigoEmpleado, <BR> string campoFecha, <BR> string fecha, <BR> string campoEmpresa, <BR> int codEmpresa,<BR> IDbConnection connection,
<BR> IDbTransaction transaction) //transaction is passed null<BR>{<BR> <BR> //IDbConnection connection= factoriaConexiones.getConnection(conf);<BR> IDbCommand command= connection.CreateCommand();<BR> command.Transaction=transaction;<BR> IDbDataAdapter adapter= factoriaDataAdapter.getDataAdapter();<BR> DataSet ds = new DataSet();</P>
<P> <BR> string cols ="";<BR> if(columnas == null || columnas.Count== 0)<BR> cols ="*";<BR> else<BR> cols = new Cadenas().convertirAString(columnas);</P>
<P> command.CommandText="SELECT MAX("+campoFecha+") FROM "+nombreTabla<BR> +" WHERE "+campoEmpleado+"="+codigoEmpleado<BR> +" AND "+campoEmpresa+"="+codEmpresa<BR> +" AND "+campoFecha+" <= '"+fecha+"'";<BR> <BR> try<BR> {<BR> adapter.SelectCommand=command; <BR> adapter.Fill(ds);<BR> DataTable dtFecha = ds.Tables[0];<BR> string maxFecha = dtFecha.Rows[0][0].ToString();<BR> command.CommandText="SELECT "+cols+" FROM "+nombreTabla<BR> +" WHERE (FECHALTA IS NULL OR FECHALTA='') OR" <BR> + campoFecha+" IN('" +
maxFecha + "')"<BR> +" AND "+campoEmpleado+"="+codigoEmpleado<BR> +" AND "+campoEmpresa+"="+codEmpresa;<BR> ds = new DataSet();<BR> adapter.Fill(ds); //This is the locked query in the third called of the method <BR> //obtenerRegistrosHistorico<BR> }<BR> catch(Exception e)<BR> {<BR> Excepcion ex= new Excepcion(new Exception("WMNDAC_ErrorBaseDatos",e));<BR> ArrayList exN=new ArrayList();<BR> ArrayList exV=new
ArrayList();<BR> exN.Add("conf");exV.Add(conf);<BR> exN.Add("columnas");exV.Add(columnas);<BR> exN.Add("nombreTabla");exV.Add(nombreTabla);<BR> exN.Add("campoEmpleado");exV.Add(campoEmpleado);<BR> exN.Add("codigoEmpleado");exV.Add(codigoEmpleado);<BR> exN.Add("campoFecha");exV.Add(campoFecha);<BR> exN.Add("fecha");exV.Add(fecha);<BR> exN.Add("campoEmpresa");exV.Add(campoEmpresa);<BR> exN.Add("codEmpresa");exV.Add(codEmpresa);<BR> exN.Add("connection");exV.Add(connection);<BR> exN.Add("transaction");exV.Add(transaction);<BR> ex.lanzar(this,ex.formatearParametros("OperadorBD.obtenerRegistrosHistorico",exN,exV),new WMNDACConfiguracion().HacerLogExcepciones);<BR> }</P>
<P> return ds.Tables[0];<BR>}</P>
<P><BR>Column FECHALTA, can`t be NULL in the table, and it isn't necesary to apply the condition "FECHALTA IS NULL" of the query,<BR>but FECHALTA = '' is really necesary. I tell this because, if I delete the condition "(FECHALTA IS NULL OR FECHALTA='')"<BR>from the query, it goes ok in C# code. If I only delete "FECHALTA IS NULL" or ("FECHALTA = '') the query continues blocking<BR>when it is called 3 times. I don't Know what is happening. The transaction property of the object command is null. I've never<BR>used v1.7 of Firebird Net Provider. </P>
<P>I'm don't know english, I'm sorry the errors in my message.</P>
<P>Thanks.<BR></P></DIV>
<DIV></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #a0c6e5 2px solid; MARGIN-RIGHT: 0px"><FONT style="FONT-SIZE: 11px; FONT-FAMILY: tahoma,sans-serif">
<HR color=#a0c6e5 SIZE=1>
<DIV></DIV>From: <I>Carlos Guzmán Álvarez <car...@mu...></I><BR>Reply-To: <I>"For users and developers of the Firebird .NET providers" <fir...@li...></I><BR>To: <I>"For users and developers of the Firebird .NET providers" <fir...@li...></I><BR>Subject: <I>Re: [Firebird-net-provider] (no subject)</I><BR>Date: <I>Fri, 08 Sep 2006 22:27:59 +0200</I><BR>MIME-Version: <I>1.0</I><BR>Received: <I>from lists-outbound.sourceforge.net ([66.35.250.225]) by bay0-mc11-f1.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2444); Fri, 8 Sep 2006 13:27:51 -0700</I><BR>Received: <I>from sc8-sf-list2-new.sourceforge.net (unknown [10.3.1.94])by sc8-sf-spam2.sourceforge.net (Postfix) with ESMTPid E0F8F12DBF; Fri, 8 Sep 2006
13:27:50 -0700 (PDT)</I><BR>Received: <I>from sc8-sf-mx2-b.sourceforge.net ([10.3.1.92]helo=mail.sourceforge.net)by sc8-sf-list2-new.sourceforge.net with esmtp (Exim 4.43)id 1GLmx2-0003RW-O3 for fir...@li...;Fri, 08 Sep 2006 13:27:48 -0700</I><BR>Received: <I>from smtp2.mundo-r.com ([212.51.32.187])by mail.sourceforge.net with esmtp (Exim 4.44) id 1GLmx2-0002Bf-Qifor fir...@li...;Fri, 08 Sep 2006 13:27:49 -0700</I><BR>Received: <I>from cm172154.red.mundo-r.com (HELO [213.60.172.154])([213.60.172.154])by smtp2.mundo-r.com with ESMTP; 08 Sep 2006 22:27:46 +0200</I><BR>>Hello:<BR>> ><BR>> > I'm sure that the C# code is ok, I have execute the query with other<BR>> > data and it go ok.<BR>> ><BR>> > I'm using Firebird Server 1.5 and Firebird Net Provider 1.6<BR>>
><BR>>Can you send a test case ?? What is the isolation level you are using<BR>>for the transactions ( if you are using a non default one ) ??<BR>>Is the same thing happening on v1.7 of the provider ??<BR>><BR>>--<BR>>Carlos Guzmán Álvarez<BR>>Vigo-Spain<BR>><BR>>-------------------------------------------------------------------------<BR>>Using Tomcat but need to do more? Need to support web services, security?<BR>>Get stuff done quickly with pre-integrated technology to make your job easier<BR>>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo<BR>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642<BR>>_______________________________________________<BR>>Firebird-net-provider mailing list<BR>>Fir...@li...<BR>>https://lists.sourceforge.net/lists/listinfo/firebird-net-provider<BR></FONT></BLOCKQUOTE></div></html>
|
|
From:
<car...@mu...> - 2006-09-11 19:34:09
|
Hello: > > adapter.Fill(ds); //Here the program is locked and the method never > returns, no exception is throwed > What is the value of ds.Tables.Count here ?? -- Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@mu...> - 2006-09-11 20:54:51
|
Hello: > > When I do the query with SQL Manager 2005 Lite for Interbase and > Firebird, it go well. But when I execute the query from this C# code, > the dataset never is filled, and the program execution is locked, in > other words, the method adapter.Fill(ds) never terminates > Can you send a test case ?? ( with a test database ), please > > I'm using Firebird Server 1.5 and Firebird Net Provider 1.6 > Is the same happening with v1.7 of the provider ?? -- Carlos Guzmán Álvarez Vigo-Spain |
|
From: Balla I. <bal...@gm...> - 2006-09-11 06:02:51
|
> adapter.Fill(ds); //Here the program is locked and the method never returns,
> no exception is throwed
I had the same problem with embedded server, when I used character set
and collations, because I did not copy the intl directory to the
proper place. Maybe this can be also the case for you somehow?
Imre
|
|
From: Nithin <nm...@so...> - 2007-11-20 06:28:22
|
I've tried to connect using firebird and C# with a SharpDevelop. My test connection features and all are working fine the DSN name as specified is also ok .Let me know why my tables are not seen on the sharp develop.If anyone can help please mail me fast . The error is "use .net framework Dataprovider for ODBC.Can you help me out to get this driver as well. I need a fast reply please do make it if you can Thanks |
|
From: Jiri C. <di...@ci...> - 2007-11-20 08:50:37
|
On 11/20/07, Nithin <nm...@so...> wrote:
> I've tried to connect using firebird and C# with a SharpDevelop.
> My test connection features and all are working fine the DSN name as
> specified is also ok .Let me know why my tables are not seen on the sharp
> develop.If anyone can help please mail me fast . The error is "use .net
> framework Dataprovider for ODBC.Can you help me out to get this driver as
> well. I need a fast reply please do make it if you can
First, this isn't ODBC support list, sorry. Second, for next time, try
to write some subject if you're asking in maling-list.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
|
|
From: Database T. <ki...@4c...> - 2007-12-24 11:30:30
|
Hello, I am sending the stacktrace information about the Exception. This exception occurred when I restored my backup database file. Using following Code FbBackupFile restorefile = new FbBackupFile(@"c:\kixzofdb\myback.fbk",2048); FbRestore fbrestore = new FbRestore(); fbrestore.BackupFiles.Add(restorefile); fbrestore.ConnectionString = @"DATABASE=C:\kixzofdb\testingBackup.FDB; User=sysdba; password= masterkey;"; fbrestore.Verbose = true; fbrestore.PageSize = 2048; fbrestore.Options = FbRestoreFlags.Create | FbRestoreFlags.Replace; fbrestore.Execute(); The exception generated was "FirebirdSql.Data.Common.IscException" Please have look on that. at FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector() at FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse() at FirebirdSql.Data.Client.Gds.GdsServiceManager.Query(ServiceParameterBuffer spb, Int32 requestLength, Byte[] requestBuffer, Int32 bufferLength, Byte[] buffer) at FirebirdSql.Data.Services.FbService.QueryService(Byte[] items) at FirebirdSql.Data.Services.FbService.GetNextLine() at FirebirdSql.Data.Services.FbService.ProcessServiceOutput() at FirebirdSql.Data.Services.FbRestore.Execute() at firebirdBackup.Form1.button2_Click(Object sender, EventArgs e) in D:\Nikita\firebirdBackup\firebirdBackup\Form1.cs:line 53 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.Unsaf eNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(Form mainForm) at firebirdBackup.Program.Main() in D:\Nikita\firebirdBackup\firebirdBackup\Program.cs:line 17 at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() Regards, Rakesh singh http://www.4colordesign.com |
|
From: Jiri C. <di...@ci...> - 2007-12-24 11:52:56
|
Why are you creating new thread?! Your problem is http://tracker.firebirdsql.org/browse/DNET-120 . -- Jiri {x2} Cincura (Microsoft Student Partner) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
|
From: Vladislav P. <pa...@ma...> - 2008-01-06 02:00:52
|
Hi! I have to return FbDataReader object from function. So I write this: public static FbDataReader getReader(string sql) FbConnection conn = new FbConnection(MF.constr); FbCommand command = new FbCommand(sql, conn); conn.Open(); FbDataReader reader = command.ExecuteReader(); return reader; } But when I run the application and rise the function many times per minute I've grtting "Timeout exceed" exception write on conn.Open() method rising. I think this because of I havn't close the connection and garbage collector do not clean the memory quickly enought, but I can't to rise conn.Close() before I return reader. So what should I do to solve this problem? Vlad Panteleev, http://panvladislav.1gb.ru http://mobile.1gb.ru |
|
From: Dean H. <dea...@dl...> - 2008-01-06 03:39:52
|
Vladislav Panteleev wrote:
> But when I run the application and rise the function many
> times per minute I've grtting "Timeout exceed" exception write on
> conn.Open() method rising. I think this because of I havn't
> close the connection and garbage collector do not clean the
> memory quickly enought, but I can't to rise conn.Close()
You should never rely on the garbage collection to close database
connections!
> before I return reader. So what should I do to solve this
> problem?
If you pass CommandBehavior.CloseConnection to the ExecuteReader()
method, then the FbDataReader will automatically close the connection
when you call it's IDispose.Dispose method. So you can do something like
this:
using(FbDataReader reader = getReader("blah"))
{
// Use FbDataReader here
} // On this line, FbDataReader will automatically close the connection
Dean.
|
|
From: nasim <nas...@gm...> - 2008-01-29 05:31:17
|
hi; i have one question. i work with data provider of firebird and my program work very well. but when i setup from my project and move to other pc it doesn't work. my question is, is it need to install dat provider in every coputer that it want use firebird database? best regards; |
|
From: Dean H. <dea...@dl...> - 2008-01-29 05:40:19
|
nasim wrote: > i have one question. i work with data provider of firebird and my > program work very well. but when i setup from my project and move to > other pc it doesn't work. > my question is, is it need to install dat provider in every coputer that > it want use firebird database? You can just copy FirebirdSql.Data.FirebirdClient.dll into your application's directory. There's no real *need* to install it into the GAC. Dean. |
|
From: Rene P. <rpi...@qu...> - 2010-05-11 05:08:51
|
Hello
var query = from res in ResultSet
select new {res.RES_PERIODE,Debet=(res.RES_AMOUNT <= 0.00 ? res.RES_AMOUNT :
0.00 ),Credit=(res.RES_AMOUNT > 0.00 ? res.RES_AMOUNT : 0.00 )};
query.Dump();
Linqpad accept the syntax
But when it runs it throws me error that looks to be originating from the
firebird driver
Is it possible to make case like statements with the Linq to Entity provider
for Firebird
Am using firebird 2.1
|
|
From: Erick P. <web...@ya...> - 2012-08-28 21:16:47
|
Look! http://naamatkadid.info/cnbcnews.php?igoogleid=a4jx |
|
From: Roberto C. | U. <rob...@un...> - 2012-08-29 12:30:33
|
How do I install Firebird. NET Provider in visual studio 2012? Firebird. NET Provider is already supporting. NET 4.0 and 4.5? thank you Roberto Carlos Analyst Information Technology Unimed São Lourenço Work Cooperative Medical |
|
From: Mark R. <ma...@la...> - 2012-08-29 12:40:07
|
On Wed, 29 Aug 2012 09:12:46 -0300, "Roberto Carlos | Unimed" <rob...@un...> wrote: > How do I install Firebird. NET Provider in visual studio 2012? > Firebird. NET Provider is already supporting. NET 4.0 and 4.5? Did you realise you just replied all to a spam message and thus sent your question to all other addressees of that spam message? Mark |
|
From: Muthu A. <pea...@ho...> - 2012-11-17 01:02:39
|
Hi All, I am migrating my solution to VS 2012 Ultimate with firebird dot net provider 3.0, I have configured ddex provider and able to select the firebird dot net provider and run the edmx file. But when I run the application I am getting the following error… GACUtil show me all four firebird dot net providers including 3.0 My Connection String is: metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl;provider=FirebirdSql.Data.FirebirdClient;provider connection string="user=SYSDBA;password=masterkey;database=C:\Pearlpos\Data\Store.fdb;dialect=3;charset=NONE;connectionlifetime=15;pooling=False;packetsize=8192;datasource=BLACKDELL" Error Message is: Model.ssdl(2,2) : error 0152: No Entity Framework provider found for 'FirebirdSql.Data.FirebirdClient' ADO.NET provider. Make sure the provider is registered in the 'entityFramework' section of the application config file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information. I have my machine.config file, registry entries configured properly, Also In my application config.file I have <entityFramework> <defaultConnectionFactory type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, EntityFramework"> </defaultConnectionFactory> </entityFramework> <system.data> <DbProviderFactories> <clear/> <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".NET Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=3.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/> </DbProviderFactories> </system.data> Any help is highly appreciated, Thanks! Muthu Annamalai |
|
From: FSOYSAL ( G. ) <fs...@gm...> - 2017-08-14 06:48:18
|
With FirebirdSql.Data.FirebirdClient 5.9.1 / 5.8.1
* db.SELECT(Of CARDS)(New With {.CARD_NO = SOME_CARD_NO }) is returning null
But
db.SELECT(Of CARDS)(" CARD_NO = " + CARD_NO )
is returning with recordS
what can be problem ?
( i updated ormlite.firebird referance also )
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X