[Firebird-net-provider] How can I create script from schema?

2006-04-11 Thread Paul Mercea
Hi I have an modular application, each module use a prefix, SYS for system, INV for inventory, etc. I have created upsize application to create database from script file and pump data from ‘old’ database. Now I want to create a extract application, which create scripts from development d

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

2006-04-11 Thread Jesse Sightler
What's interesting, though, is that I still got the error with FbDbType set to Text as well.  Shouldn't that have worked, even with the size specified?Thanks,JessOn 4/11/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello:> fbParam.DbType = System.Data.DbType.String;With this wh

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 http://www.cincura.net

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

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: fbParam.DbType = System.Data.DbType.String; With this when infering the data type it will be set as a VarChar field. //fbParam.Size = 250; Now if you give the size, when executing the command the parameter will be automagically described as VarChar(250) inste

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 p

[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 remov

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[] ar

[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. Objec

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 G

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] 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 PrimaryKe

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] 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 http://carlosga.blogspo

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, y

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] Firebird and .NET (C# and ADO.NET) books

2006-04-11 Thread Paul Mercea
For Firebird u have .Net provider, and it can be used like other ado.net driver. If u have documentation about c# and ado.net u will find that firebird is not too difficult for u.   Good luck. PaulM   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fabio Gomes S

[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

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-pr

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

2006-04-11 Thread Fabio Gomes
Nice, but are you using firebird? Does the book help you with firebird?Cause i m finding it too difficult to make simple things with firebird and C# :(On 4/11/06, Kevin Stanton <[EMAIL PROTECTED]> wrote: I too am just learning C# and am going through the "MS Visual C# 2005 Step by S

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 it’s 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: Tue

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 mig

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 fir

[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] Re: Helping inserting data on a firebird database using C#.

2006-04-11 Thread Fabio Gomes
Sorry.. what do mean changes before the update?The weird thing is that i dont have any errors, but it doesnt delete either :(On 4/11/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote: Hello:>> int codigo=int.Parse(this.txtCli_cod.Text);> if (dr ==DialogResult.Yes){>  

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 CLIEN

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

2006-04-11 Thread Carlos Guzmán Álvarez
Hello: Thanks, Carlos. Will there be updated 1.7.1 binaries available with this fix? If the same error happens with the final version of the server yes. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "When you don't code, you tend to become one of those architects who thin

[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();                                

[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

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

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 http://carlosga.blogsp

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 applicati

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 ADO.

[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

[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 problems