[Firebird-net-provider] SQL error - Different windows user accounts

2007-05-13 Thread Jiří Neužil
Hi, I have very strange error with firebird .NET data provider. I have small .NET 2.0 application using Firebird 2.0.1 and Firebird .NET Data Provider 2.1.0.0 Beta 3. Database is on localhost. I have 2 windows user account on my machine (Win XP Prof), both are administrators. With first user acc

Re: [Firebird-net-provider] SQL syntax for inserting data into stored procedure

2007-05-13 Thread Jon Ege Ronnenberg
I did what you posted and it works on some sprocs but not all... sometimes I get a Dynamic SQL Error parameter mismatch for procedure BE_LOCATION_INFO_INSERT. I'll look more into this tomorrow with the DBA and post some more info. On 5/13/07, Jiri Cincura <[EMAIL PROTECTED]> wrote: Yes, you're

Re: [Firebird-net-provider] SQL syntax for inserting data into

2007-05-13 Thread Jon Ege Ronnenberg
Some extra info: I use ASP.NET 2.0 on the server and my globalization configuration is set to UTF-8 in requestEncoding, responseEncoding and fileEncoding. The FireBird Data Provider is version 2.1.0.0 - This SF.net email is sp

Re: [Firebird-net-provider] SQL syntax for inserting data into

2007-05-13 Thread Jon Ege Ronnenberg
Probably yes, but I have to talk to the DBA. Also another problem was that the data sent from the web server was in UTF-8 and the db wasn't. We changed that by using IBExpert to copy everything to a new UNICODE_FSS database and the connection string I changed to have Charset=UNICODE_FSS;.But now I

Re: [Firebird-net-provider] Compact Framework help

2007-05-13 Thread Jiri Cincura
You only need to reference provider for CF. You can download it from firebirdsql.org site. The 1.7 isn't needed (it's for .NET FW 1.1). -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This

[Firebird-net-provider] Compact Framework help

2007-05-13 Thread Tomozi Peter
Hi I use VS2003 (Windows CE 4.2, CF 2). I would like to connect to a firebird database, but i can't. I have firebird.provider 1.7, and compact framework FirebirdSql.Data.FirebirdClient.dll. I can't add reference FirebirdSql.Data.FirebirdClient.dll, only FirebirdSql.Data.Firebird.dll... Oke. on th

Re: [Firebird-net-provider] Provider 2.1.0.0 FBBackup Execute Method throws Object Ref Exception

2007-05-13 Thread Jiri Cincura
Michele Lepri wrote: > Hi, it's known and solved problem (look at the bug-tracker), but for > now, the fix is un the svn ^^ > bye > Michele Ah, I was testing this against SuperServer. :) That was the problem. I comletely forgot about embedded problem. You should say this sooner. ;) -- Jiri {x

Re: [Firebird-net-provider] Provider 2.1.0.0 FBBackup Execute Method throws Object Ref Exception

2007-05-13 Thread Michele Lepri
Muthu Annamalai ha scritto: > I was using version 2.0.1.0 and backup method worked properly. Yesterday I > changed the provider to version 2.1.0.0. In the new version fbbackup execute > method I am getting Object Reference exception. Then I switched back to the > old one and there is no exception.

Re: [Firebird-net-provider] SQL syntax for inserting data into

2007-05-13 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: > The First example you have sent has a valid syntax too, and should work > fine too, the query should be changed by the provider adding the execute > procedure before executing the query. Looks like we have some woodoo in SPs. :) -- Jiri {x2} Cincura http://blog.v

Re: [Firebird-net-provider] Provider 2.1.0.0 FBBackup Execute

2007-05-13 Thread Carlos Guzmán Álvarez
Hello: > b.Verbose = true; And if you are setting this option could you enable the event that outputs the work being done by the server, please (ServiceOutput event) - This SF.net email is sponsored by DB2 Express Down

Re: [Firebird-net-provider] SQL syntax for inserting data into

2007-05-13 Thread Carlos Guzmán Álvarez
Hello: > Jiri you are probably one of the people of this list that knows the most > about Firebird but I have to say (just for the record if anyone else see > this post) that your answer is incorrect. The right statement is > "execute procedure BE_BOOKING_INSERT(@BookingID, @UserID, @EventID,

Re: [Firebird-net-provider] SQL syntax for inserting data into stored procedure

2007-05-13 Thread Jiri Cincura
Yes, you're right. But if you want to use this statement as SP, use it like: using (FbConnection conn = new FbConnection(cs)) { conn.Open(); using (FbCommand cmd = conn.CreateCommand()) { cmd.CommandText = "test_insert"; // NO "test_insert(@id, ...)" cmd.CommandTyp

Re: [Firebird-net-provider] Provider 2.1.0.0 FBBackup Execute Method throws Object Ref Exception

2007-05-13 Thread Jiri Cincura
Muthu Annamalai wrote: > Thanks for replying, here is my code, > > Hi, I've rewrite your code into C#, because I'm not familiar with VB.NET, but should be same: if (backupPath == string.Empty) { return false; } try { FbBackup b = new FbBackup(); b.ConnectionString = @"User=S