Re: [Firebird-net-provider] Some questions about NetProvider and
Hello: No, It's Windows Application. Huu and the the database file exists in that path in the firebird server machine ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ObjectDataSource and Firebird.Provider
Hello: I'm trying to use an ObjectDataSource and a TableAdapter where I have builded some queries and I'm not able to see the querie on the ObjectDataSource. How do I use the ObjectDataSource with the FirebirdClientProvider? I'm using VS2005 Pro + RC1 Have you done a test using Sql Server and the queries get shown ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ObjectDataSource and Firebird.Provider
Carlos, I found the problem. The reason was some bug in VS 2005 with the table adapter name. I changed my tableadptername to a shorter one and the problem was gone. Thanks for your reply Charles From: Carlos Guzmán Álvarez <[EMAIL PROTECTED]>Reply-To: firebird-net-provider@lists.sourceforge.netTo: firebird-net-provider@lists.sourceforge.netSubject: Re: [Firebird-net-provider] ObjectDataSource and Firebird.ProviderDate: Sun, 02 Apr 2006 15:47:54 +0200>Hello:I'm trying to use an ObjectDataSource and a TableAdapter where I >>have builded some queries and I'm not able to see the querie on the >>ObjectDataSource.How do I use the ObjectDataSource with the FirebirdClientProvider?I'm using VS2005 Pro + RC1>>>Have you done a test using Sql Server and the queries get shown ??>>-->Carlos Guzmán Álvarez>Vigo-Spain>>http://carlosga.blogspot.com/--->This SF.Net email is sponsored by xPML, a groundbreaking scripting >language>that extends applications into web and mobile media. Attend the live >webcast>and join the prime developer group breaking into this new coding >territory!>http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642>___>Firebird-net-provider mailing list>Firebird-net-provider@lists.sourceforge.net>https://lists.sourceforge.net/lists/listinfo/firebird-net-provider --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Some questions about NetProvider and
My database's file is "C:\mydb.fdb". That file exists. I created new Windows Application. I placed "FbConnection1" on a Form1 and configurated its "ConnectionString" property - Data Source = localhost, Database = "C:\mydb.fdb", Servet Type = "Embedded Server". I hit "Test" button and the message was - Connection successful. Then I placed "FbDataAdapter1", configured it ( i chose FbConnection1 as connection, "Use SQL", "Select * from PEOPLE") and then, using FbDataAdapter, I generated new DataSet "DS1". Next, I placed "DataGridView1" on my form. I set up its properties - DataSource = "DS1", DataMember = "Table". Finally i wrote a code for Form1_Load event: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load FbDataAdapter1.Fill(DS, "Table") End Sub I started debugging my program and it worked fine :) All the data from my table appeared in the grid. I closed my program, returned to VisualStudio and in the "Server Explorer" tab I chose Data Connection "localhost(MYDB)" by clicking on a "+" and expanding that nod. Next, i debugged my program and i received that error - "I/O error for file C:\MYDB.FDB. Error while trying to open file" I've found 2 more (possibly) bugs... 1) When I placed FbDataAdapter and it generated DataSet - in "Generate DataSet" window i couldn't choose existing Dataset ( that option is always gray and inactive, even i've got another DataSet on my form) and, in bottom section of thet window, there are 3 CheckBoxes - the first one says - "Add this DataSet to the" To the what? The sentence is cut in a half... 2) If in my table a column has a name like "PEOPLE_I_LIKE", in DataSet the name will be changed to PEOPLEILIKE. So that column won't be displayed in DataGrid... I must change that name in DataSet manually... Martin Uzytkownik ""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECTED] > Hello: >> No, It's Windows Application. > > Huu and the the database file exists in that path in the firebird=20 > server machine ?? > > > --=20 > Carlos Guzm=E1n =C1lvarez > Vigo-Spain > > http://carlosga.blogspot.com/ > > > > --- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Some questions about NetProvider and
> Huu and the the database file exists in that path in the firebird=20 > server machine ?? > My database's file is "C:\mydb.fdb". That file exists. I created new Windows Application. I placed "FbConnection1" on a Form1 and configurated its "ConnectionString" property - Data Source = localhost, Database = "C:\mydb.fdb", Servet Type = "Embedded Server". I hit "Test" button and the message was - Connection successful. Then I placed "FbDataAdapter1", configured it ( i chose FbConnection1 as connection, "Use SQL", "Select * from PEOPLE") and then, using FbDataAdapter, I generated new DataSet "DS1". Next, I placed "DataGridView1" on my form. I set up its properties - DataSource = "DS1", DataMember = "Table". Finally i wrote a code for Form1_Load event: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load FbDataAdapter1.Fill(DS, "Table") End Sub I started debugging my program and it worked fine :) All the data from my table appeared in the grid. I closed my program, returned to VisualStudio and in the "Server Explorer" tab I chose Data Connection "localhost(MYDB)" by clicking on a "+" and expanding that nod. Next, i debugged my program and i received that error - "I/O error for file C:\MYDB.FDB. Error while trying to open file" I've found 2 more (possibly) bugs... 1) When I placed FbDataAdapter and it generated DataSet - in "Generate DataSet" window i couldn't choose existing Dataset ( that option is always gray and inactive, even i've got another DataSet on my form) and, in bottom section of thet window, there are 3 CheckBoxes - the first one says - "Add this DataSet to the" To the... what? The sentence is cut in a half... 2) If in my table a column has a name like "PEOPLE_I_LIKE", in DataSet the name will be changed to PEOPLEILIKE. So that column won't be displayed in DataGrid... I must change that name in DataSet manually... Martin --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] How to fill a DataSet using FbDataAdapter ?
Hi :) I'm using VB2005Prof and NetProvider RC1. I've made DataSet file "MyDataSet.xsd" by clicking "Add New Data Source" in the "Data Source" tab. Now, i'm trying to send data to that DataSet using FbDataAdapter. I must do it in that way, becouse i want that DataSet to be the source for Crystal Report. Martin --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Some questions about NetProvider and
Hello: I closed my program, returned to VisualStudio and in the "Server Explorer" tab I chose Data Connection "localhost(MYDB)" by clicking on a "+" and expanding that nod. Next, i debugged my program and i received that error - "I/O error for file C:\MYDB.FDB. Error while trying to open file" Are you using embedded server right ?? With connection pooling enabled rigth ?? ( it's enabled by default ) Do the same test, but before going to the Server Explorer close the IDE, restart it and retry and let me know if it works. I've found 2 more (possibly) bugs... 1) When I placed FbDataAdapter and it generated DataSet - in "Generate DataSet" window i couldn't choose existing Dataset ( that option is always gray and inactive, even i've got another DataSet on my form) and, in bottom section of thet window, there are 3 CheckBoxes - the first one says - "Add this DataSet to the" To the... what? The sentence is cut in a half... 2) If in my table a column has a name like "PEOPLE_I_LIKE", in DataSet the name will be changed to PEOPLEILIKE. So that column won't be displayed in DataGrid... I must change that name in DataSet manually... I will try to check this , but anyway if i were you i will be looking to the new .NET 2.0 data components ( BindingSource, TableApdater, ... ) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] How to fill a DataSet using FbDataAdapter ?
Ok, and where's problem? DataSet1.Clear(); fbDataAdapter1.Fill(DataSet1); Very easy example. -- Jiri Cincura http://www.cincura.net/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Membership Provider class (ASP.NET 2.0)
Hi all! I need help about how to use the Membership Provider class (if there is anyone ready to use). How do I configure it? Sorry for the beginner question. Thanks in advance. Leandro
Re: [Firebird-net-provider] Membership Provider class (ASP.NET 2.0)
On 2.4.2006 22:29 Leandro Tuchtenhagen wrote: Hi all! I need help about how to use the Membership Provider class (if there is anyone ready to use). How do I configure it? Sorry for the beginner question. Hi, the sample implementation of MemberShipProvider for FB is in FirebirdSql.Web.Providers namespace. So you can use this. -- Jiri Cincura http://www.cincura.net/ --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Visual Studio 2005, .NET Framework 2.0 RC1, Token unknown - line 1, char 411,"CHARACTER_LENGTH"
Carlos, thanks for reply. But support for Firebird dialect 1 is very neccesary! Without support for dialect 1 the provider is useless for many developers. For example we have a big ERP software which development started on Interbase about 10 years ago, now is on Firebird dialect 1 and has very many Delphi client applications and running on many customer sites.We are planning new client applications development on ASP.NET 2.0 when stable .NET 2 provider for Firebird comes out. and after that step-by step starting to migrate Delphi-Windows applications to ASP.NET browser based app's. But moving the full database from dialect 1 to dialect 3 right now, overnight, is imossible! I believe many developers are in similar situation. Please put into plans and schedules to add a feature for the provider to support dialect 1. thank you. Carlos Guzmán Álvarez wrote: Hello: Dynamic DQL Error SQL Error Code =-104 Token unknown - line 1, char 411 "CHARACTER_LENGTH" also I get the same error when I drag GridView, DataList or any other component of ASP.NET WebForm and try to configure data source. any ideas? The problem is with this line on the sql statement of the columns schema: cast(fld.rdb$character_length AS integer) AS "CHARACTER_LENGTH", looks like dialect 1 database didn't support quoted identifiers ... We can't left it without quotes, and i don't like the idea of chaning the column name at this stage --- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
