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 =

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.CommandType =

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

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

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

[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

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

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

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

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