[Firebird-net-provider] Feedback request ( II )

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: I have some questions for people using/testing v2.0 to answer, if possible, when having a little amount of free time :) 1. Do you know of any ADO.NET 2.0 feature that is missing in the provider?? 2. Are you having any error that is not fixed yet ?? 3. Are you having performance

[Firebird-net-provider] Support for Firebird 2 Release Candidate 1?

2006-04-11 Thread Alex Jankowski
Hi, I'm having problem using the Firebird ADO.NET Data Provider 2.0 Release Candidate 1 with the Firebird 2 Release Candidate 1 embedded version. I'm getting a System.IndexOutOfRangeExection when doing a connection.Open(). Is the Firebird 2 Release Candidate 1 supported by the Firebird ADO.NET

Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate 1?

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: I'm having problem using the Firebird ADO.NET Data Provider 2.0 Release Candidate 1 with the Firebird 2 Release Candidate 1 embedded version. I'm getting a System.IndexOutOfRangeExection when doing a connection.Open(). Is the Firebird 2 Release Candidate 1 supported by the Firebird

Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate1?

2006-04-11 Thread Alex Jankowski
Hi Carlos, Using embedded server right ?? Yes, I'm using the embedded server. Is it possible, that it will work in the near future? /Alex --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends

Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate1?

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: Yes, I'm using the embedded server. Is it possible, that it will work in the near future? Well, another user was having the same problem with RC 1 but looks like it was working with Beta 2 What is your connection string ?? -- Carlos Guzmán Álvarez Vigo-Spain

Re: [Firebird-net-provider] Support for Firebird 2 Release Candidate1?

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: Well, another user was having the same problem with RC 1 but looks like it was working with Beta 2 Fixed in CVS the problem was on the buffer size used when requesting the server version. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you

[Firebird-net-provider] Re: Support for Firebird 2 Release Candidate1?

2006-04-11 Thread Oleg Deribas
Hello, Carlos Guzmán Álvarez said the following on 11.04.2006 11:49: Well, another user was having the same problem with RC 1 but looks like it was working with Beta 2 Fixed in CVS the problem was on the buffer size used when requesting the server version. Thanks, Carlos. Will there be

[Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
Hi, thats me again :)Now i m trying to delete a record using this: int codigo=int.Parse(this.txtCli_cod.Text); if (dr ==DialogResult.Yes){ try { da_cli.DeleteCommand = con.CreateCommand(); da_cli.DeleteCommand.CommandText = DELETE FROM

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: int codigo=int.Parse(this.txtCli_cod.Text); if (dr ==DialogResult.Yes){ try { da_cli.DeleteCommand = con.CreateCommand(); da_cli.DeleteCommand.CommandText = DELETE FROM

[Firebird-net-provider] Firebird and .NET (C# and ADO.NET) books

2006-04-11 Thread Fabio Gomes
Is there any books about using firebird with C#?Cause i cant find good tutorials and info on the internet, and i m having a lot of troubles with firebird here as you may have already noticed.So if there is any books out there about it, please send me the link, i ll make my boss buy it :) thanx for

Re: [Firebird-net-provider] Firebird and .NET (C# and ADO.NET) books

2006-04-11 Thread Ruben Guinez
I hope help you with : http://www.dotnetfirebird.org/ It's a good site about firebird and .net Bye On 4/11/06, Fabio Gomes [EMAIL PROTECTED] wrote: Is there any books about using firebird with C#?Cause i cant find good tutorials and info on the internet, and i m having a lot of troubles with

Re: [Firebird-net-provider] Firebird and .NET (C# and ADO.NET) books

2006-04-11 Thread Fabio Gomes
Thanx,I already know this site and it has good stuff, but i m new to C# and ADO.NET. and all the tutorials i find out there are using SQL server, Acess Database or Oracle, i cant find anything about firebird for begginners like me. Does this mean i should first learn sql server with C# and then

RE: [Firebird-net-provider] Firebird and .NET (C# and ADO.NET) books

2006-04-11 Thread Kevin Stanton
I too am just learning C# and am going through the MS Visual C# 2005 Step by Step book. I think its a great book and with a Delphi background (many years) makes it easier. Cheers, Kevin From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fabio Gomes Sent:

RE: [Firebird-net-provider] Firebird and .NET (C# and ADO.NET) books

2006-04-11 Thread Kevin Stanton
Not quite to that chapter yet with C# and ADO database access.  Definitely will be though hopefully soon (hard to find the time at the moment). From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fabio Gomes Sent: Tuesday, April 11, 2006 7:21 AM To:

[Firebird-net-provider] Prodigy - a News Reader app that uses DotNetFirebird

2006-04-11 Thread Jiten Bhagat
Hi everyone, I've been working on an 'intelligent' news reader as part of my University degree project. This application makes good use of the Firebird embedded engine as well Carlos Firebird ADO.NET Data Provider. I now need volunteers to evaluate my application for a period of

Re: [Firebird-net-provider] Error code -303, Operation Not Supported...

2006-04-11 Thread Jesse Sightler
I tried that as a hard-coded hack (and confirmed that the hack was setting the FbDbType by watching in the debugger), but it did not make a difference.Thanks,JessOn 4/10/06, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote: Hello: COMMENTBODY = BLOB -- LONGVARCHAR -- subtype: textHave you set the

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: Sorry.. what do mean changes before the update? Check if ds_cli.HasChanges is true if not the dataadapter will have nothing to update, did you have deleted the Row from the datatable right ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code,

Re: [Firebird-net-provider] Error code -303, Operation Not Supported...

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: I tried that as a hard-coded hack (and confirmed that the hack was setting the FbDbType by watching in the debugger), but it did not make a difference. Please, send a test case to my private email including a test database. -- Carlos Guzmán Álvarez Vigo-Spain

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
No, o didnt do that.I think that this is the problem then.I try to read about it, i m completely lost on this stuff.Thanx :)On 4/11/06, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote: Hello: Sorry.. what do mean changes before the update?Check if ds_cli.HasChanges is true if not the dataadapter

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
i tried this: DataTable dtTable = ds_cli.Tables[0]; dtTable.PrimaryKey = dtTable.Columns[0]; DataRow delete = dtTable.Rows.Find(txtCli_cod); delete.Delete();But it gives me an error, how am i supposed to pass the PrimaryKey value to the dataTable?Thanx again, and sorry for the

Re: [Firebird-net-provider] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: delete.Delete(); For this line try instead: dtTable.Rows.Remove(delete); -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is possible ( Anders Hejlsberg )

Re: [Firebird-net-provider] Error code -303, Operation Not Supported...

2006-04-11 Thread Jesse Sightler
I'm working on that. The really bizarre thing is that this definitely happens, but if I try to boil it down to a test-case it works.I'm having a hard time figuring out the difference between my test case and the actual run. I'll let you know if I can figure this out.Thanks,JessOn 4/11/06, Carlos

[Firebird-net-provider] SqlDataSource problem

2006-04-11 Thread Jiri Cincura
Hi, when I'm configuring SqlDataSource to work with FB, I got this error: --- Microsoft Visual Studio --- Schema could not be retrieved for this table. Please make sure the connection settings are correct and that the database is online.

Re: [Firebird-net-provider] Error code -303, Operation Not Supported...

2006-04-11 Thread Jesse Sightler
Yahoo! :) Found the problem... specifying the size on string parameters seems to be enough to cause this to happen every time. It seems to happen even if the length is specified correctly.This is with .Net 2.0, btw.Here's a testcase that should be good enough: static void Main(string[] args) {

[Firebird-net-provider] SqlDataSource - refresh schema bug and command builder

2006-04-11 Thread Jiri Cincura
Hi, if you have parametrized query, the SqlDataSource will not retrieve the table schema. It also points to QueryBuilder, which also don't works well. On SELECT FIRST 100 title, perex, link FROM items WHERE feed_id = @feed_id ORDER BY pub_date DESC; it crashes first on FIRST, if you remove

Re: [Firebird-net-provider] SqlDataSource problem

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: but everything is working next. I can use the SqlDataSource, etc. Can you send to my private email a test database, please ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those architects who thinks everything is

Re: [Firebird-net-provider] SqlDataSource problem

2006-04-11 Thread Jiri Cincura
On 11.4.2006 22:37 Carlos Guzmán Álvarez wrote: Hello: but everything is working next. I can use the SqlDataSource, etc. Can you send to my private email a test database, please ?? I think it doesn't bear on database. I happens on my every remote DB. -- Jiri Cincura