Re: [Firebird-net-provider] Server Engine`?

2008-10-04 Thread Sven
I don't use typed datasets at the moment - but typed datasets wouldn't solve the problem. I don't have a server engine - I asked for it if it exists. Sven "Meftah Tayeb" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > hi, > ho you are using the DataSet ? > are you using a

Re: [Firebird-net-provider] Server Engine`?

2008-10-04 Thread Sven
Timestamp - when one of my application crashes I have a dead entry in my database... I want to have a "server engine" which knows each application and can react if an application crashes because of a timeout when the application isn't responding. Sven ""Jiri Cincura"" <[EMAIL PROTECTED]>

Re: [Firebird-net-provider] Server Engine`?

2008-10-04 Thread Sven
Hello, if I do it in your way I get an exception that User A has changed the data before and I have to let User B to decide what to to - this is not what I want. User B should not be allowed to enter the data in edit mode since user a is in edit mode at the moment. Sven "Dean Harding" <[EMAI

Re: [Firebird-net-provider] Trailing spaces trimmed

2008-10-04 Thread Julien Ferraro
Of course, I can test it and see if my tests go green. But I won't be able to find other error that this can lead to. Anyway, if you use a tool like isql, the trailing spaces are not trimmed so I don't see what could be the problem with this -Message d'origine- De : Jiri Cincura [mailto:[E

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Jiri Cincura
Guys, please, can you do some proper quoting. The HTML garbage is not neccessary here. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.Net email is sponsored by th

[Firebird-net-provider] [FB-Tracker] Created: (DNET-178) Varchar Length Problems

2008-10-04 Thread Nicolas T (JIRA)
Varchar Length Problems --- Key: DNET-178 URL: http://tracker.firebirdsql.org/browse/DNET-178 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 2.1.0 Environ

Re: [Firebird-net-provider] Server Engine`?

2008-10-04 Thread Meftah Tayeb
hi, ho you are using the DataSet ? are you using a typed DataSet or a Declared dataSet ? ho you are connecting the Server engine with the GUI ? thanks - This SF.Net email is sponsored by the Moblin Your Move Developer's challe

Re: [Firebird-net-provider] Server Engine`?

2008-10-04 Thread Jiri Cincura
On Fri, Oct 3, 2008 at 8:25 AM, Sven <[EMAIL PROTECTED]> wrote: > how do you handle the dataset problem? > I would like to know if there is a tool which enables a 'server engine'. > The server engine is the only tasks that communicates with the database and > every application communicates with the

Re: [Firebird-net-provider] Error in Firebird .NET Data Provider 2.5.0 Alpha 2

2008-10-04 Thread Jiri Cincura
> Can someone affirm this error? Are you able to connect with 2.1 version of FirebirdClient? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.Net email is sponsore

Re: [Firebird-net-provider] Problems with parametrized queries (DDEX VS2008)

2008-10-04 Thread Jiri Cincura
On Thu, Oct 2, 2008 at 11:01 AM, Zento <[EMAIL PROTECTED]> wrote: > SELECT UsuDisp.Dispositivos, Usu.IDUsuario, Usu.Usuario, Usu.Nombre > FROM UsuariosDispositivos UsuDisp LEFT OUTER JOIN > Usuarios Usu ON Usu.IDUsuario = UsuDisp.Usuario > WHERE (UsuDisp.Disposi

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread giorgi giorgi
There are three separate indexes. I reorganized my select command, and created stored procedures for them instead of calling them directly. Here are my timing results: ExecuteReader() takes about 0.02 seconds. Read() takes 0.4 seconds which is really much. However, when I run those queries from m

[Firebird-net-provider] Error in Firebird .NET Data Provider 2.5.0 Alpha 2

2008-10-04 Thread Priebe, Joern (GE EntSol, Security)
Hi, using the latest Firebird .NET Data Provider 2.5.0 Alpha 2 and FB Server 2.1, I am not able to open a database-connection. Once I try to open the DB-Connection I get the following exception: "Your user name and password are not defined. Ask your database administrator to set up a Firebi

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Scott Price
Hi Giorgi, If this is a routine you are calling many times, I would think that keeping a connection open would be far greater improvement to your performance. If you aren't using connection pooling, you should. Furthermore, it might be wiser to pass the connection into the routine being ca

[Firebird-net-provider] Error in Firebird .NET Data Provider 2.5.0 Alpha 2

2008-10-04 Thread Priebe, Joern (GE EntSol, Security)
Hi, using the latest Firebird .NET Data Provider 2.5.0 Alpha 2 and FB Server 2.1, I am not able to open a database-connection. Once I try to open the DB-Connection I get the following exception: "Your user name and password are not defined. Ask your database administrator to set up a Firebi

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Mercea Paul
From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 12:23 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] ExecuteReader is slow Running a recursive cte against a table with about 1600 rows from my program needs

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Mercea Paul
From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 09:41 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] ExecuteReader is slow Hello, I am using 2.1 version of firebird. Fb.NEt provider version is 2.0.1.0 Con

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Mercea Paul
Maybe you should change this to a stored procedure and pass parameters … should run more faster then your code! From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 10:24 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provi

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Mercea Paul
> -Original Message- > From: Steve Faleiro [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 30, 2008 11:29 > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] ExecuteReader is slow > > > 1. Did you try to optimize the query? I know F

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Mercea Paul
giorgi giorgi wrote: > Hello, > > I am developing an application that uses firebird database and I use > firebird provider for ado.net The application makes > many calls to ExecuteCommand method of FbCommandClass. According to .net > performance provider it is the slowest metho

Re: [Firebird-net-provider] Trailing spaces trimmed

2008-10-04 Thread Jiri Cincura
On Sat, Oct 4, 2008 at 7:15 PM, Jiri Cincura <[EMAIL PROTECTED]> wrote: > PS: Carlos, if you're reading, can you see why is this there? Not 'see' but 'say' of course. :) -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com --

Re: [Firebird-net-provider] Trailing spaces trimmed

2008-10-04 Thread Jiri Cincura
On Sat, Sep 27, 2008 at 2:49 PM, Julien Ferraro <[EMAIL PROTECTED]> wrote: > So if I understand, it is a known bug ? I don't think it's a bug. Maybe it has some reason, because Carlos must be mad to do this without reason. This is also reason, why I didn't removed it. > Is there a workaround ? Y

Re: [Firebird-net-provider] Trailing spaces trimmed

2008-10-04 Thread Jiri Cincura
On Fri, Oct 3, 2008 at 8:32 AM, Julien Ferraro <[EMAIL PROTECTED]> wrote: > Do you know how I can work around this ? Hardly. I can send you private build with this removed. You can test it and see, whether it works. PS: Carlos, if you're reading, can you see why is this there? -- Jiri {x2} Cinc

Re: [Firebird-net-provider] Trailing spaces trimmed

2008-10-04 Thread Teträm Corp
I'm not sure, because of UNICODE charset, it should be (it's out of my knowledge) but AFAIK, varchar fields never kept trailing spaces Thierry Julien Ferraro a écrit : > > Hello, > > I’ve got a strange behavior with the provider. The trailing space of a > string are trimmed. > > Let me give you

Re: [Firebird-net-provider] .NET 2.0 Provider on PokcetPC connect error

2008-10-04 Thread Mercea Paul
> > always have this exception, 'No message for error code 335544721 found'. > > this is my code > > It's Unable to complete network request > to host "". [PM] See if 3050 port is not blocked by firewall on host! Regards, Paul -

Re: [Firebird-net-provider] .NET 2.0 Provider on PokcetPC connect error

2008-10-04 Thread Jiri Cincura
On Sat, Oct 4, 2008 at 11:54 AM, abuzer kadayıf <[EMAIL PROTECTED]> wrote: > I use same connection string in windows application and no problem. > but i recive this exception in windows ce and i use latest source but i You probably during build didn't properly embed resource with error messages. I

Re: [Firebird-net-provider] .NET 2.0 Provider on PokcetPC connect error

2008-10-04 Thread abuzer kadayıf
hello, i am not sure but i don't see any error my code. it's very simple code to test connection. I use same connection string in windows application and no problem. but i recive this exception in windows ce and i use latest source but i always have this exception, 'No message for error code 33554