From:
<car...@te...> - 2004-12-29 13:20:43
|
Hello: >Both .dll's are in the web app "bin" folder and the folder where the db >file lies in can be full accessed by the ASP.Net Account. > Huummmm ..... i think it's searching for the fbembed.dll in a different location .... maybe in the .NET Runtime directory -- Best regards Carlos Guzmán Álvarez Vigo-Spain "In the end there can be only one" (Highlander) |
From: <jc...@gm...> - 2004-12-29 14:16:04
|
The ASP.Net aways search for its dependencies on bin folder, but, if FBProvider is installed in its default location, accessible through GAC, maybe the fbembed.dll should be in FBProvider folder also (otherwise, the only safe place to be is System folder, which ASP.Net has no writing access, but have read access) On Wed, 29 Dec 2004 14:20:37 +0100, Carlos Guzm=E1n =C1lvarez <car...@te...> wrote: > Hello: >=20 > >Both .dll's are in the web app "bin" folder and the folder where the db > >file lies in can be full accessed by the ASP.Net Account. > > > Huummmm ..... i think it's searching for the fbembed.dll in a different > location > .... maybe in the .NET Runtime directory >=20 >=20 > -- > Best regards >=20 > Carlos Guzm=E1n =C1lvarez > Vigo-Spain >=20 > "In the end there can be only one" (Highlander) >=20 > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://productguide.itmanagersjournal.com/ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider >=20 --=20 [] J=FAlio C=E9sar K=F6del http://www.tenebree.com |
From: <ma...@ga...> - 2004-12-31 15:55:35
|
Hi, as I said, some silly mistake... I've set up a Firebird-Net-Provider-ONLY test case and got an error message for misssing write access to the db file... For me, it didn't work to give read/write access to Asp.Net Account, I had to give read/write access to "Everybody" ?!! Anyway, Happy New Year and thanks to Carlos for his steady effort!!! > Hello: > >>Both .dll's are in the web app "bin" folder and the folder where the db >>file lies in can be full accessed by the ASP.Net Account. >> > Huummmm ..... i think it's searching for the fbembed.dll in a different > location > .... maybe in the .NET Runtime directory > > > > -- > Best regards > > Carlos Guzmán Álvarez > Vigo-Spain > > "In the end there can be only one" (Highlander) > > |
From: Abdullah S. Al-S. <Al...@sa...> - 2005-01-30 06:11:46
|
=0D=0A=0D=0A=0D=0A=0D=0A-----------------------------------------=0D=0AThi= s message may contain information that is legally privileged or=0D=0Aconfid= ential=2E If you have received this communication in error, please=0D=0Anot= ify the sender immediately by e-mail reply and delete it from your=0D=0Asys= tem=2E Any copying or further distribution beyond the original recipient=0D= =0Ais not intended, and may be unlawful and is strictly prohibited=2E Since= the=0D=0Aintegrity and security of this message cannot be fully guaranteed= on the=0D=0AInternet, we strongly advise that you understand and observe t= his lack of=0D=0Asecurity when e-mailing us=2E Please note that any views o= r opinions=0D=0Aexpressed in this e-mail are those solely of the author and= do not=0D=0Anecessarily represent those of The Saudi Arabian National Guar= d=2E Although=0D=0Awe believe that this e-mail and any attachments are viru= s-free, the=0D=0Arecipient should nevertheless check this e-mail and any at= tachment for the=0D=0Apresence of any viruses=2E The SANG cannot accept any= liability whatsoever=0D=0Afor any loss or damage caused directly or indire= ctly by virus / error=0D=0Atransmitted by this e-mail or its attachments=2E= =0D=0A |
From: <luk...@tl...> - 2005-04-01 09:20:07
|
Hello All Has Somebody knows is there a possibilty to take Array from Firebird usin= g FIREBIRD NET PROVIDER 1.6.3 ?? or other ... br=20 Lukasz |
From:
<car...@te...> - 2005-04-01 12:35:23
|
Hello: >Has Somebody knows is there a possibilty to take Array from Firebird using FIREBIRD NET PROVIDER 1.6.3 ?? or other ... > Yes, looks at the FbArray nunit test fixture for some simple samples. -- Best regards Carlos Guzmán Álvarez Vigo-Spain "Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las mismas cosas." Albert Einstein |
From: Alexandre S. <soa...@ho...> - 2005-04-24 20:50:50
|
Hi, I developped a web application on a windows platform using the microsoft .net framework 1.1 and the firebird data provider for .net. My app connects to a firebird databse which is installed on my linux box. Everything works fine. I ported my application to mono 1.1.6 and everything is ok, except the pages that connect to the databse. I get the following error: FirebirdSql.Data.Firebird.FbException: I/O error during "open" operation for file "MyDatabse.fdb" Error while trying to open file in <0x000a8> FirebirdSql.Data.Firebird.FbDbConnection:Connect () in (wrapper remoting-invoke-with-check) FirebirdSql.Data.Firebird.FbDbConnection:Connect () in <0x0004a> FirebirdSql.Data.Firebird.FbConnectionPool:create () If I try with my web app on windows, it connects fine to the databse. My connection string looks like: Database=MyDatabse.fdb;User=SYSDBA;Password=masterkey;Dialect=3;Server=192.168.0.3 I also replaced the Firebird Data Provider dll to use the one for mono in my mono web app bin directory. Does anyone have an idea what's wrong? Thank you very much, Alexandre Soares |
From: sunika <su...@gm...> - 2005-06-27 18:36:35
|
Hello! some little moments. 1. File FbUniqueKeys.cs. Constructor Exist: public FbUniqueKeys() : base("PrimaryKeys") { } MustBe: public FbUniqueKeys() : base("UniqueKeys") { } ------------------------------------------------------------------ 2. File FbIndexes.cs need the code (such code, ProcessResult, needed to = many DbSchema classes): --- protected override DataTable ProcessResult(DataTable schema) { schema.BeginLoadData(); foreach (DataRow row in schema.Rows) { if (row["IS_UNIQUE"] =3D=3D DBNull.Value || Convert.ToInt32(row["IS_UNIQUE"], CultureInfo.InvariantCulture) =3D=3D = 0) { row["IS_UNIQUE"] =3D true; } else { row["IS_UNIQUE"] =3D false; } if (row["IS_INACTIVE"] =3D=3D DBNull.Value || Convert.ToInt32(row["IS_INACTIVE"], CultureInfo.InvariantCulture) =3D=3D = 0) { row["IS_INACTIVE"] =3D true; } else { row["IS_INACTIVE"] =3D false; } if (row["IS_SYSTEM_INDEX"] =3D=3D DBNull.Value || Convert.ToInt32(row["IS_SYSTEM_INDEX"], CultureInfo.InvariantCulture) = =3D=3D 0) { row["IS_SYSTEM_INDEX"] =3D true; } else { row["IS_SYSTEM_INDEX"] =3D false; } } schema.EndLoadData(); schema.AcceptChanges(); return schema; } --- with best regards! |
From: Carlos G.A. <car...@te...> - 2005-06-27 21:20:15
|
> Hello: > with best regards! Thanks very much !!!! Both changes are in CVS now. -- Un saludo Carlos Guzmán Álvarez Vigo-España "La manera más profunda de sentir una cosa es sufrir por ella." |
From: <fel...@gv...> - 2005-09-14 17:17:59
|
Hi, =20 I=B4ve a procedure like this=20 "create procedure CobraReciboPDA (CodRecibo varchar(9), Fecha timestamp......" =20 and this code: FbCommand cmCobra =3D new FbCommand("CobraReciboPDA", Con); cmCobra.CommandType =3D CommandType.StoredProcedure; cmCobra.Transaction =3D myTrans; FbParameter PCodRecibo =3D new FbParameter(); cmCobra.Parameters.Add(PCodRecibo); PCodRecibo.ParameterName=3D"@CodRecibo"; FbParameter PFecha =3D new FbParameter(); cmCobra.Parameters.Add(PFecha); PFecha.ParameterName=3D"@Fecha"; PCodRecibo.Value=3D"1"; PFecha.Value =3D System.DateTime.Today; cmCobra.ExecuteNonQuery(); I=B4l get an error. Without param Facha works fine. How mus I use this = param in VS? thanks |
From:
<car...@te...> - 2005-09-14 17:22:39
|
Hello: >FbParameter PFecha = new FbParameter(); >cmCobra.Parameters.Add(PFecha); >PFecha.ParameterName="@Fecha"; > What happens if you add here: PFecha.FbDbType = FbDbType.TimeStamp -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: <fel...@gv...> - 2005-09-14 17:44:50
|
The same error. thanks -----Mensaje original----- De: fir...@li... [mailto:fir...@li...] En nombre de Carlos Guzm=E1n =C1lvarez Enviado el: mi=E9rcoles, 14 de septiembre de 2005 19:23 Para: fir...@li... Asunto: Re: [Firebird-net-provider] (no subject) Hello: >FbParameter PFecha =3D new FbParameter(); = cmCobra.Parameters.Add(PFecha);=20 >PFecha.ParameterName=3D"@Fecha"; > What happens if you add here: PFecha.FbDbType =3D FbDbType.TimeStamp -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server.=20 Download it for free - -and be entered to win a 42" plasma tv or your = very own Sony(tm)PSP. Click here to play: = http://sourceforge.net/geronimo.php _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From:
<car...@te...> - 2005-09-14 19:30:17
|
Hello: >The same error. > Ok, could you send the error message ?? Can you send to me a test case with test database included ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: <fel...@gv...> - 2005-09-15 07:57:32
|
I=B4ts a quite dificult. I=B4m developoing a web service that connect = with a firebird database (about 100MB) the web service it=B4s invoced from a = PDA program that send data to DB. The error it somthing like "System format exception:No se puede reconocer la cadena como valor DateTime v=E1lido" = If you want,you can connect with this web service Thanks=20 -----Mensaje original----- De: fir...@li... [mailto:fir...@li...] En nombre de Carlos Guzm=E1n =C1lvarez Enviado el: mi=E9rcoles, 14 de septiembre de 2005 21:30 Para: fir...@li... Asunto: Re: [Firebird-net-provider] (no subject) Hello: >The same error. > Ok, could you send the error message ?? Can you send to me a test case = with test database included ?? -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server.=20 Download it for free - -and be entered to win a 42" plasma tv or your = very own Sony(tm)PSP. Click here to play: = http://sourceforge.net/geronimo.php _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: <fel...@gv...> - 2005-09-15 08:58:02
|
I can solve it with that PFecha.Value =3D rc["Fecha"].ToString().Replace("/", ".");=20 -----Mensaje original----- De: fir...@li... [mailto:fir...@li...] En nombre de F=E9lix Gonz=E1lez Enviado el: jueves, 15 de septiembre de 2005 9:56 Para: fir...@li... Asunto: RE: [Firebird-net-provider] (no subject) I=B4ts a quite dificult. I=B4m developoing a web service that connect = with a firebird database (about 100MB) the web service it=B4s invoced from a = PDA program that send data to DB. The error it somthing like "System format exception:No se puede reconocer la cadena como valor DateTime v=E1lido" = If you want,you can connect with this web service Thanks=20 -----Mensaje original----- De: fir...@li... [mailto:fir...@li...] En nombre de Carlos Guzm=E1n =C1lvarez Enviado el: mi=E9rcoles, 14 de septiembre de = 2005 21:30 Para: fir...@li... Asunto: Re: [Firebird-net-provider] (no subject) Hello: >The same error. > Ok, could you send the error message ?? Can you send to me a test case = with test database included ?? -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server.=20 Download it for free - -and be entered to win a 42" plasma tv or your = very own Sony(tm)PSP. Click here to play: = http://sourceforge.net/geronimo.php _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server.=20 Download it for free - -and be entered to win a 42" plasma tv or your = very own Sony(tm)PSP. Click here to play: = http://sourceforge.net/geronimo.php _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: <fel...@gv...> - 2005-09-15 09:28:39
|
My problem was the order of pram definition. The order must be the same = that in procedure. I=B4d think that the relation between the procedure param = and FdbParam use ParameterName not the order. -----Mensaje original----- De: fir...@li... [mailto:fir...@li...] En nombre de F=E9lix Gonz=E1lez Enviado el: jueves, 15 de septiembre de 2005 10:57 Para: fir...@li... Asunto: RE: [Firebird-net-provider] (no subject) I can solve it with that PFecha.Value =3D rc["Fecha"].ToString().Replace("/", ".");=20 -----Mensaje original----- De: fir...@li... [mailto:fir...@li...] En nombre de F=E9lix Gonz=E1lez Enviado el: jueves, 15 de septiembre de 2005 9:56 Para: fir...@li... Asunto: RE: [Firebird-net-provider] (no subject) I=B4ts a quite dificult. I=B4m developoing a web service that connect = with a firebird database (about 100MB) the web service it=B4s invoced from a = PDA program that send data to DB. The error it somthing like "System format exception:No se puede reconocer la cadena como valor DateTime v=E1lido" = If you want,you can connect with this web service Thanks=20 -----Mensaje original----- De: fir...@li... [mailto:fir...@li...] En nombre de Carlos Guzm=E1n =C1lvarez Enviado el: mi=E9rcoles, 14 de septiembre de = 2005 21:30 Para: fir...@li... Asunto: Re: [Firebird-net-provider] (no subject) Hello: >The same error. > Ok, could you send the error message ?? Can you send to me a test case = with test database included ?? -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server.=20 Download it for free - -and be entered to win a 42" plasma tv or your = very own Sony(tm)PSP. Click here to play: = http://sourceforge.net/geronimo.php _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server.=20 Download it for free - -and be entered to win a 42" plasma tv or your = very own Sony(tm)PSP. Click here to play: = http://sourceforge.net/geronimo.php _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------- SF.Net email is sponsored by: Tame your development challenges with Apache's Geronimo App Server.=20 Download it for free - -and be entered to win a 42" plasma tv or your = very own Sony(tm)PSP. Click here to play: = http://sourceforge.net/geronimo.php _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Patrick A. <pat...@gm...> - 2005-10-04 19:43:29
|
From: Thomas C. <tc...@su...> - 2006-04-11 02:58:46
|
From: Juanma f. <pa...@ho...> - 2006-07-12 08:40:10
|
<html><div style='background-color:'><DIV class=RTE>Hi, I'm Juanma from Spain, and I don't speak English very well. This is my problem: I'm using Firebird 1.5, and I don't know if when I use a varchar, its total length is sent via network from server to client, although lenght of strored data is smaller than length of the varchar column.</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>Thanks.</DIV></div></html> |
From: Jiri C. <di...@ci...> - 2006-07-12 09:21:13
|
On 12.7.2006 10:40 Juanma fernandez wrote: > Hi, I'm Juanma from Spain, and I don't speak English very well. This is > my problem: I'm using Firebird 1.5, and I don't know if when I use a > varchar, its total length is sent via network from server to client, Total length of collumn (like for info) or total length of data (ie. padded with spaces)? > although lenght of strored data is smaller than length of the varchar > column. -- Jiri Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com |
From: Juanma f. <pa...@ho...> - 2006-07-12 10:29:24
|
<html><div style='background-color:'><DIV class=RTE> <P>Hi, I refer to the total length of data. For example, If the column is a varchar(10) and I am storing</P> <P>the the the string HELLO, from client to server via network is sent HELLO plus 5 blank spaces or only HELLO? Thanks.<BR><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>Jiri Cincura <di...@ci...></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>Wed, 12 Jul 2006 11:19:30 +0200</I><BR>MIME-Version: <I>1.0</I><BR>Received: <I>from lists-outbound.sourceforge.net ([66.35.250.225]) by bay0-mc10-f4.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2444); Wed, 12 Jul 2006 02:21:15 -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 B0366FE86; Wed, 12 Jul 2006 02:21:14 -0700 (PDT)</I><BR>Received: <I>from sc8-sf-mx1-b.sourceforge.net ([10.3.1.91]helo=mail.sourceforge.net)by sc8-sf-list2-new.sourceforge.net with esmtp (Exim 4.43)id 1G0au9-0001M6-4Q for fir...@li...;Wed, 12 Jul 2006 02:21:13 -0700</I><BR>Received: <I>from cincura.vserver.cz ([193.86.238.102] helo=mail.cincura.net)by mail.sourceforge.net with esmtp (Exim 4.44) id 1G0au7-0004g3-55for fir...@li...;Wed, 12 Jul 2006 02:21:13 -0700</I><BR>Received: <I>from [192.168.0.149] (89-24-3-195.customers.t-mobile.cz[89.24.3.195])by mail.cincura.net (Postfix) with ESMTP id 614CB8683EFfor <fir...@li...>;Wed, 12 Jul 2006 11:20:54 +0200 (CEST)</I><BR>>On 12.7.2006 10:40 Juanma fernandez wrote:<BR>> > Hi, I'm Juanma from Spain, and I don't speak English very well. This is<BR>> > my problem: I'm using Firebird 1.5, and I don't know if when I use a<BR>> > varchar, its total length is sent via network from server to client,<BR>><BR>>Total length of collumn (like for info) or total length of data (ie. padded<BR>>with spaces)?<BR>><BR>> > although lenght of strored data is smaller than length of the varchar<BR>> > column.<BR>><BR>><BR>><BR>>--<BR>>Jiri Cincura<BR>>http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com<BR>><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: Oleg D. <thi...@td...> - 2006-07-12 10:44:43
|
Hello, Juanma fernandez said the following on 12.07.2006 13:29: > Hi, I refer to the total length of data. For example, If the column > is a varchar(10) and I am storing the the the string HELLO, from > client to server via network is sent HELLO plus 5 blank spaces or > only HELLO? No, server doesn't send trailing blank spaces. -- Oleg |
From:
<car...@mu...> - 2006-07-12 14:12:42
|
Hello: > Hi, I'm Juanma from Spain, and I don't speak English very well. This > is my problem: I'm using Firebird 1.5, and I don't know if when I use > a varchar, its total length is sent via network from server to client, > although lenght of strored data is smaller than length of the varchar > column. The server will send the field value ( without trailing spaces ) plus two bytes for the value length. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ No hay un solo rey que no descienda de un esclavo, ni un esclavo que no haya tenido reyes en su familia. |
From: Juanma f. <pa...@ho...> - 2006-09-08 08:22:00
|
<html><div style='background-color:'><DIV class=RTE>I am executing the follow query:</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>SELECT * FROM HISTPRECONTA <BR>WHERE (FECHALTA IS NULL OR FECHALTA='') <BR>OR FECHALTA IN('20060907') <BR>AND NUMEMP=2<BR>AND CODEMPRESA=1</DIV> <DIV class=RTE> </DIV> <DIV class=RTE>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</DIV><FONT size=2> <P class=RTE>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 class=RTE>I'm sure that the C# code is ok, I have execute the query with other data and it go ok.</P> <P class=RTE>I'm using Firebird Server 1.5 and Firebird Net Provider 1.6</FONT><FONT size=2></P></FONT></div></html> |
From:
<car...@mu...> - 2006-09-08 20:27:48
|
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án Álvarez Vigo-Spain |