[Firebird-net-provider] Connection to datasource using VS 2005

2006-04-18 Thread Yvan Pochon
Hi, Comming from Dephi using Firebird database, I just start try the Visual Studio 2005 professional edition IDE with C#. I have downloaded the Firebird .Net Data Provider and install it as described. Everything is fine until I try to enter the connection string into a VS test programm in C#. The

Re: [Firebird-net-provider] Connection to datasource using VS 2005

2006-04-18 Thread Jiri Cincura
On 18.4.2006 11:32 Yvan Pochon wrote: string: User=SYSDBA;Password=masterkey;Database=d:\ibserver\test.gdb;Datasource=loc alhost I get the following error message Failure has occurred while loading a type. I have seen that someboby has already ask a similar question but I

RE: [Firebird-net-provider] Connection to datasource using VS 2005

2006-04-18 Thread Yvan Pochon
Do you mean the provider registration into machine.config ? Yes I have done it as following configuration configSections ... section name=firebirdsql.data.firebirdclient type=System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.0.0, Culture=neutral,

RE: [Firebird-net-provider] Connection to datasource using VS 2005

2006-04-18 Thread Yvan Pochon
FirebirdSql.Data.FirebirdClient (version 2.0.0.0) is present into c:\windows\assembly. I also check with the gacutil.exe. Unfortunatly the VS datasource wizard does not generate the application config file, due to the error message reported I suppose ?? I get an application config file when I

Re: [Firebird-net-provider] Connection to datasource using VS 2005

2006-04-18 Thread Carlos Guzmán Álvarez
Hello: No beta release has been installed. I just install the release provided by msdn, disc 3070 december 2005. Ok :) And did you have Visual Studio SDK installed ?? -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ When you don't code, you tend to become one of those

RE: [Firebird-net-provider] Connection to datasource using VS 2005

2006-04-18 Thread Yvan Pochon
no I did not intstall any thing else except Firebird server. Do I have to install the SDK ? Regards Yvan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Carlos Guzmán Álvarez Sent: 18 April 2006 14:56 To: firebird-net-provider@lists.sourceforge.net

Re: [Firebird-net-provider] FbMembershipProvider problem

2006-04-18 Thread Jiri Cincura
On 18.4.2006 15:00 Carlos Guzmán Álvarez wrote: Hello: Any progres on this Carlos? No sorry but i haven't time to review it, i'm a little bosy with the home moving. Never mind. I'll try to find something myself and 'll to solve this. -- Jiri Cincura http://www.cincura.net/

RE: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Yvan Pochon
Hello Charles, I could not give you any advise on your current problem because I just start to use VS C# !!! However looking at the archived mails, I have notice thatyou had the same problem I amfacing now. After installation of the Firebird .NET provider I get the following message when

Re: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Oleg Deribas
Hello, Charles Urbina said the following on 18.04.2006 17:57: [FbException (0x80004005): Dynamic SQL Error parameter mismatch for procedure INSERT_RESERVATION] It is the cause of error. Replace this: FbCommand myCommand = new FbCommand(EXECUTE PROCEDURE INSERT_RESERVATION, myConnection,

RE: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Paul Mercea
Hi I think here is your problem: FbCommand myCommand = new FbCommand(EXECUTE PROCEDURE INSERT_RESERVATION, myConnection, myTransaction); You need to specify parameters to for that procedure INSERT_RESERVATION(@parameter,@parameter2) C y PaulM From: [EMAIL PROTECTED]

Re: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Carlos Guzmán Álvarez
Hello: FbCommand myCommand = new FbCommand(EXECUTE PROCEDURE INSERT_RESERVATION, myConnection, myTransaction); myCommand.Parameters.Add(@COMPANY_NAME, FbDbType.VarChar, 100, COMPANY_NAME).Direction = ParameterDirection.Input; myCommand.Parameters.Add(@PASSENGER_NAME, FbDbType.VarChar, 100,

Re: [Firebird-net-provider] FbMembershipProvider problem

2006-04-18 Thread Carlos Guzmán Álvarez
Hello: type=FirebirdSql.Web.Providers.FbMembershipProvider Huu should't this have the assembly name as well ?? Here is an article with things on Membership Providers configuration, it may help: http://www.odetocode.com/Articles/427.aspx http://odetocode.com/Articles/428.aspx

Re: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Eduardo Beninca
You can do in this way too... FbCommand myCommand = new FbCommand(EXECUTE PROCEDURE INSERT_RESERVATION(?,?), myConnection, myTransaction); On 4/18/06, Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote: Hello: FbCommand myCommand = new FbCommand(EXECUTE PROCEDURE INSERT_RESERVATION,

Re: [Firebird-net-provider] FbMembershipProvider problem

2006-04-18 Thread Jiri Cincura
On 18.4.2006 19:13 Carlos Guzmán Álvarez wrote: Hello: type=FirebirdSql.Web.Providers.FbMembershipProvider Huu should't this have the assembly name as well ?? Here is an article with things on Membership Providers configuration, it may help:

Re: [Firebird-net-provider] FbMembershipProvider problem

2006-04-18 Thread Carlos Guzmán Álvarez
Hello: Eureka! Carlos, I've found the problem. You have typo there: // // Initialize FbConnection. // ConnectionStringSettings ConnectionStringSettings = ConfigurationManager.ConnectionStrings[config[connectionectionStringName]];

[Firebird-net-provider] [ANN] FirebirdClient v2.0 Release Candidate 3 released

2006-04-18 Thread Carlos Guzmán Álvarez
Hello: FirebirdClient v2.0 Release Candidate 3is available for download. Download information can be found here: http://www.firebirdsql.org/index.php?op=filesid=netprovider · Release Candidate 3 ( 2006-04-19 ) · ( Please review the changelog for details ) Bug Fixes: - Fixes in

Re: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Oleg Deribas
Hello, Charles Urbina said the following on 18.04.2006 17:57: [FbException (0x80004005): Dynamic SQL Error parameter mismatch for procedure INSERT_RESERVATION] It is the cause of error. Replace this: FbCommand myCommand = new FbCommand(EXECUTE PROCEDURE INSERT_RESERVATION, myConnection,