[Firebird-net-provider] Exception using AspNet.Identity

2015-10-13 Thread Mercea Paul
Hi all I have ported an application (MVC5, SQLServer) to Firebird but i notice some exceptions in debug mode (tried fb 4.7 and fb 4.8 provider). This app is using AspNet.Identity to authenticate users. With SQLServer i didn't get this exception: An exception of type

Re: [Firebird-net-provider] Make FbNetProvider classes unseal

2015-01-16 Thread Mercea Paul
On 2015.01.16 12:02 PM, Lukáš Vykydal wrote: We d'like to monitor performance (time to execute) for every statement. We have a lot of code which use only base ADO.NET access to database. With this change we can find performance killers in this code more easly including parameters and plan.

[Firebird-net-provider] Firebird and VS 2015 preview

2015-01-08 Thread Mercea Paul
Hi all Has anyone tried Firebird with Visual Studio 2015 preview? Is enough to modify reg files to register as provider? TIA, Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___

[Firebird-net-provider] [FB-Tracker] Created: (DNET-584) Add suport for Firebird 3

2015-01-08 Thread Mercea Paul (JIRA)
Environment: Windows 8.1 x64, Windows 10 x64, Firebird 3 beta 1 Reporter: Mercea Paul Assignee: Jiri Cincura Priority: Minor I'm trying to test an existing app with next Firebird 3 version but i get error message: Could not retrieve storage version

Re: [Firebird-net-provider] Insert into uncommitted table

2014-12-22 Thread Mercea Paul
On 2014.12.22 2:08 PM, Jiří Činčura wrote: Hi *, Anybody knows a trick how to insert into freshly created table without commiting that DDL first. It's kind of fucking up first migration. :) Basically: Start TX. Create table. Insert into table. Commit TX. Hi Jiri Something like

Re: [Firebird-net-provider] EF Migrations

2014-12-19 Thread Mercea Paul
On 2014.11.06 3:06 PM, Jiří Činčura wrote: Hi *, Anybody here willing to give EF Migrations a try? I'm getting close to first implementation. I'm trying to add support for Firebird db for existing app on SQL Express, and, first run of the application was with no errors and created the

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-571) Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately

2014-12-14 Thread Mercea Paul
On 2014.10.15 2:31 PM, Wolfgang Lemmermeyer wrote: system.data DbProviderFactories there are more than one Entry for the Firebird Client: add name=FirebirdClient Data Provider invariant=FirebirdSql.Data.FirebirdClient description=.NET Framework Data Provider for Firebird

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-571) Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately

2014-12-10 Thread Mercea Paul
On 2014.10.15 2:02 PM, Jens Warkentin (JIRA) wrote: Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately Key: DNET-571 URL:

Re: [Firebird-net-provider] EF Migrations

2014-11-06 Thread Mercea Paul
On 2014.11.06 3:06 PM, Jiří Činčura wrote: Hi *, Anybody here willing to give EF Migrations a try? I'm getting close to first implementation. I'm in. Paul MERCEA ___ --

Re: [Firebird-net-provider] Detect current connection is local or network

2013-12-16 Thread Mercea Paul
On 12/16/2013 08:34 AM, Mr. John wrote: That I also do, but I only apply database update scripts on server machine,also some users using default app installer installed also FB server on 'client' side. I also want to warn about that. thanks Increment application version on server side, as

Re: [Firebird-net-provider] Detect current connection is local or network

2013-12-16 Thread Mercea Paul
On 12/16/2013 10:15 AM, Mr. John wrote: Hi, but how to detect app is running on server side or on local,I used to search for firebird process but I found as I said, fb was installed also on client side,so the trusted point to get that info is from firbird connection thanks. Check table

Re: [Firebird-net-provider] Detect current connection is local or network

2013-12-15 Thread Mercea Paul
On 12/15/2013 12:21 PM, Mr. John wrote: Hi When using my application over a network,only when it is update on the server machine,client applications must download also the update so I need to detect server or client state thanks Hi If you separate the client and the server, even if you work

Re: [Firebird-net-provider] Migrations

2013-04-20 Thread Mercea Paul
On 2013.04.20 9:18 AM, Jiri Cincura wrote: Hi *, is there an interest in Migrations provider (for EF) for Firebird? Hi Jiri It could be a good improvement to provider. I think is necessary to take care about 255 DDL metadata changes allowed per table. Regards -- Paul MERCEA

Re: [Firebird-net-provider] Exception using Firebird .NET provider and SimpleMembershipProvider in MVC4

2013-02-27 Thread Mercea Paul
Hi Markus On 2013.02.27 4:33 PM, Markus Ostenried wrote: Hi all, I've been using Firebird with Delphi for many years, wrote a few .NET applications and have experience in web development. However: I never did web development with .NET and my only experience with the Firebird .NET provider

Re: [Firebird-net-provider] SPAM-LOW: Re: Asp.Net MVC - Log in failure with FbMembership

2011-09-19 Thread Mercea Paul
On 2011.09.15 9:05 PM, Jiri Cincura wrote: Where should I look ? Check whether some exception was thrown. I have found the problem! Authentication is working only with users that have password format in clear. All users with Hashed password format gets the error message : Login was

[Firebird-net-provider] Asp.Net MVC - Log in failure with FbMembership

2011-09-15 Thread Mercea Paul
Hi I'm developing new web app on ASP.Net MVC3, Fb 2.5, NetProvider 2.6.5, web provider 2.6, machine is Windows 7 Professional x64. I have set membership in web.config as : membership defaultProvider=FBMembershipProvider providers clear / add applicationName=/ connectionStringName=cs_FB

Re: [Firebird-net-provider] SPAM-LOW: Re: Asp.Net MVC - Log in failure with FbMembership

2011-09-15 Thread Mercea Paul
On 2011.09.15 9:05 PM, Jiri Cincura wrote: Check whether some exception was thrown. Hi Jiri There's no exception. In debug on Account controler after line if (Membership.ValidateUser(model.UserName, model.Password)) is a salt directly to else ValidateUser method doesn't return any

Re: [Firebird-net-provider] SPAM-LOW: Re: Using FBEmbeded in ASP.NET

2011-01-11 Thread Mercea Paul
library, without any other functions! Regards, -- Mercea Paul -- Gaining the trust of online customers is vital for the success of any company that requires sensitive data to be transmitted over the Web. Learn how

Re: [Firebird-net-provider] SPAM-LOW: Re: Using FBEmbeded in ASP.NET

2011-01-10 Thread Mercea Paul
Hi Jiri Why not to place fbembed.dll to place where your application is? The system will load it for you, even without using ClientLibrary. fbembed.dll is in \bin directory of the published site, but i get error. I'll try again this week! Regards, Mercea Paul

Re: [Firebird-net-provider] SPAM-LOW: Re: FBSecurity UserPassword

2011-01-10 Thread Mercea Paul
on page 45 ! Regards, Mercea Paul -- Gaining the trust of online customers is vital for the success of any company that requires sensitive data to be transmitted over the Web. Learn how to best implement a security

[Firebird-net-provider] Using FBEmbeded in ASP.NET

2011-01-08 Thread Mercea Paul
to specify the clientlibrary but now I have a solution that can be installed in different locations. How can I use the |DataDirectory| or other locations to get the fbembed.dll ??? -- Regards, Mercea Paul -- Gaining

Re: [Firebird-net-provider] problem with a query (maybe a bug)

2010-05-01 Thread Mercea Paul
On 2010.04.29 5:06 PM, André Knappstein, Controlling wrote: k select userinfo0_.id as x0_0_ k from user_infos userinfo0_ k where (@p0 in(select views1_.View_Id from User_Views_Map views1_ k where userinfo0_.id=views1_.User_Id)) try this select userinfo0_.id as x0_0_ from user_infos

Re: [Firebird-net-provider] IntPtr and SafeHandle

2010-04-07 Thread Mercea Paul
Hi Jiri Could this cause the not shooting down application using embedded database ? As I know that was caused by pooling ! Regards, Paul -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Tuesday, April 06, 2010 11:16 PM To: For users and developers of the

Re: [Firebird-net-provider] Connection error using Virtual PC Windows XP Mode

2010-02-16 Thread Mercea Paul
On 2010.02.16 6:03 PM, Radwan Khershif wrote: I am using VS 2008 pro, Windows 7, .NET 3.5 SP1 and FbClient 2.5.1 to develop Windows Forms apps. When testing a project using Virtual PC Windows XP mode I get the exception Array Index was out of bounds each time I try to connect to the server

Re: [Firebird-net-provider] Character set problem between with Firebird .NET provider

2010-01-10 Thread Mercea Paul
Hi Louis -Original Message- From: Louis van Alphen [mailto:lo...@nucleo.co.za] Sent: Friday, January 08, 2010 14:59 To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Character set problem between with Firebird .NET provider I still get this

Re: [Firebird-net-provider] VS2010 dat providers

2009-11-19 Thread Mercea Paul
The problem is, that 1) we have couple of DDEX readme files and 2) people are simply NOT reading the content carefully. If you look at DDEX questions from last year, the questioner is doing everything else but not what's IN readme. [PM] Can't be done an installer with checkboxes for VS

Re: [Firebird-net-provider] Entity Framework, Firebird and Guid

2009-06-16 Thread Mercea Paul
Firebird doesn't have direct support for guids. Not native in Firebird but maybe with your Provider. By using smallint_bool in the ssdl i can use boolean in entities which isn't supported too. When i follow your advise from here

Re: [Firebird-net-provider] how to get started...

2009-05-12 Thread Mercea Paul
Hi Sam I think you need to configure your machine.config . Read the readme.txt file from FirebirdClientDDex Regards, Paul -Original Message- From: Sam Carleton [mailto:scarle...@miltonstreet.com] Sent: Tuesday, May 12, 2009 02:58 To: firebird-net-provider@lists.sourceforge.net

Re: [Firebird-net-provider] how to get started...

2009-05-12 Thread Mercea Paul
Anyone know if it is possible to update the web page that has v2.0.1 to have a link to let folks know there is a newer version out there? It would have been nice to find the correct version yesterday. Sam [PM] I don't know if Jiri can correct this but I'm sure someone will. Regards,

Re: [Firebird-net-provider] New version of provider breaks batch execution

2009-05-06 Thread Mercea Paul
Hi Jiri The 2.5 isn't 100% backward compatible with 2.1. Hence you have to rebuild the application too. In fact there's so much changes, both internally and externaly, that's pure craziness to deploy new FirebirdClient without testing. ;) I'm testing my apps...but the end user could

Re: [Firebird-net-provider] [SPAM] Re: =?ISO-8859-2?Q?can not use

2009-05-04 Thread Mercea Paul
First i put this files FirebirdSql.Data.Firebird.dll fbembed.dll - FB1.5.5 in /bin dir - the same error i try move this files up to / dir and problem is the same - i miss some files? becaouse of problem with FB1.5 i try with FB2.1 i copy FirebirdSql.Data.FirebirdClient.dll

[Firebird-net-provider] Deployment issue/maintenance issue

2009-04-23 Thread Mercea Paul
Hi * Maintaining my application up to date suppose to maintain all components up to date (Fb server (2.1.0-2.1.2), Windows updates,repots, sql files, etc). Including last FB .Net Provider generate new issue for end user.she/he need to install .Net Framework 3.5 because Fb.Net Provider include

[Firebird-net-provider] Instalation error message for Beta 2

2009-04-06 Thread Mercea Paul
Hi Jiri I try to install Fb client beta 2 and after copying files, when the status is : Registering product a Message box popup with the message: A network error occurred while attempting to read from file: D:\Downloads\FirebirdClient-2.5.0-Alpha2.msi After that another one with message: The

Re: [Firebird-net-provider] Instalation error message for Beta 2

2009-04-06 Thread Mercea Paul
Is the D: drive a network drive? [PM] :D Of course...I launched D:\Downloads\FirebirdClient-2.5.0-Beta2.msi if you want some screen capture... -- This SF.net email is sponsored by: High Quality Requirements in

[Firebird-net-provider] [FB-Tracker] Created: (DNET-219) Port number keyword not supported in entity connection

2009-04-04 Thread Mercea Paul (JIRA)
: Entity Framework support Affects Versions: 2.5.0 Beta 1 Environment: Fb.Net 2.5 Reporter: Mercea Paul Assignee: Jiri Cincura If I set in my connection string port number I get error message: Keyword not supported: 'port number'. I get same error message when

Re: [Firebird-net-provider] How to configure provider for Entity

2009-04-04 Thread Mercea Paul
Do you have proper path in registry for the FirebirdSql.VisualStudio.DataTools.dll file? [PM] I see all my tables after clicking OK and Finish. The path are ok!and it was ok, but was not working until I added again FirebirdSql.Data.FirebirdClient.dll to GAC!

Re: [Firebird-net-provider] How to configure provider for Entity

2009-04-02 Thread Mercea Paul
: [Firebird-net-provider] How to configure provider for Entity On Thu, Apr 2, 2009 at 16:34, Mercea Paul paul.mer...@almexa.ro wrote: How should I configure FB.Net provider to have entries in New connection window? -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka

Re: [Firebird-net-provider] [SPAM] RE: Want to run 'gbak.exe' from

2009-03-14 Thread Mercea Paul
Hi Don't you have forget to specify servername in cs? Regards, Paul -Original Message- From: Rolf Marsh [mailto:rmma...@fastmail.us] Sent: Friday, March 13, 2009 15:00 To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] [SPAM] RE: Want to run

Re: [Firebird-net-provider] Charset problems

2009-03-11 Thread Mercea Paul
Hi I think you could use 2 solution: 1. you could add charset to your connection string: FbConnectionStringBuilder fbcs = new FbConnectionStringBuilder(); fbcs.Database = @C:\Data\myDb.fdb; fbcs.Charset = NONE; - put your charset... .

[Firebird-net-provider] [FB-Tracker] Created: (DNET-216) New property in connection string builder - Trusted authentication

2009-02-24 Thread Mercea Paul (JIRA)
: New Feature Components: ADO.NET Provider Environment: Windox XP Firebird 2.5 Reporter: Mercea Paul Assignee: Jiri Cincura Priority: Minor Scenario: I'm authenticated as a simple user in Windows and I get some problems in my app developed

Re: [Firebird-net-provider] GUID handling (CHAR (16) OCTETS)

2009-02-24 Thread Mercea Paul
Hi Zoltan I', agree with you! Not the text representation. The Microsoft GUID internal structure different from FB's. This causes different byte order of the structs members. This situation also happens in C or C++ using IBPP. The problem is the different internal representation of the guid.

[Firebird-net-provider] [SPAM] RE: Want to run 'gbak.exe' from within

2009-02-17 Thread Mercea Paul
Hi Take a look at my code: private void btnBackUp_Click(object sender, EventArgs e) { //backup with service FbBackup fbbsvc = new FbBackup(); fbbsvc.ConnectionString = Properties.Settings.Default.AppConnStr; //take

[Firebird-net-provider] [SPAM] RE: [SPAM] RE: Want to run 'gbak.exe' from within

2009-02-17 Thread Mercea Paul
] [SPAM] RE: Want to run 'gbak.exe' from within Hi Paul... I still get the following error message: Cannot attach to services manager service localhost:service_mgr is not defined How do I fix this? Mercea Paul wrote

[Firebird-net-provider] [SPAM] RE: [SPAM] RE: [SPAM] RE: Want to run 'gbak.exe' from within

2009-02-17 Thread Mercea Paul
Hi Rolf, Here is the example I am using... FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.DataSource = localhost; cs.UserID = SYSDBA; cs.Password = masterkey; cs.Database = dbBooks; [PM] If dbBooks is not

[Firebird-net-provider] [SPAM] RE: [SPAM] RE: Want to run 'gbak.exe' from within

2009-02-17 Thread Mercea Paul
] [SPAM] RE: Want to run 'gbak.exe' from within Hi Paul... I still get the following error message: Cannot attach to services manager service localhost:service_mgr is not defined How do I fix this? Mercea Paul wrote: Hi Take a look at my code: private void btnBackUp_Click(object

[Firebird-net-provider] Same user id have diferent value in membership and uuid_to_char ()

2009-02-11 Thread Mercea Paul
Hi all FB2.1 and FB.Net provider 2.5. I'm porting a web app to win app and I found a difference between readable id of user from membership and readable id of user from users table. I have this code: Variables.UserId = Membership.GetUser(Variables.UserName).ProviderUserKey.ToString(); That

Re: [Firebird-net-provider] Fw: Connetion pooling problem

2009-02-06 Thread Mercea Paul
catalog=database.FDB;user id=SYSDBA;password=pass;data source=localhost I use Firebird .net provider 2.5.0.0, IIS 6 and win server2003 There is only this application on this server. _ From: Mercea Paul paul.mer...@almexa.ro To: For users and developers of the Firebird .NET providers

Re: [Firebird-net-provider] Fw: Connetion pooling problem

2009-02-05 Thread Mercea Paul
Hi Ali How is your connection string looks like? Pooling is set to true ? Regards, Paul From: Ali Erdogan [mailto:allierdo...@yahoo.com] Sent: Thursday, February 05, 2009 16:01 To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Fw: Connetion pooling

[Firebird-net-provider] Programs refuse to run with new dll 2.5.0.0 beta

2009-01-20 Thread Mercea Paul
Hi all Using FB 2.1.0.17798 embedded . I have downloaded FirebirdSql.Data.FirebirdClient-2.5.0-Beta1 and put the dll in gac (2.5.0.0) I have tried to run some programs compiled with previous version of .Net provider but refuse to run with no error message, just crash. I wonder if other users

Re: [Firebird-net-provider] Programs refuse to run with new dll 2.5.0.0 beta

2009-01-20 Thread Mercea Paul
Do you have empty username and password? If so, then FirebirdClient is trying to use trusted auth to server. [PM] As I see in code, is empty, because I use embeded FB . fbcs.ClientLibrary = apppath + @\fb\fbembed.dll; fbcs.Dialect = 3; fbcs.Pooling =

Re: [Firebird-net-provider] log filled with INET error 10054

2009-01-14 Thread Mercea Paul
OK I'm not so lucky. :) The problem is in connection pooling that was turned off on my connection string. I'll look at the problem. [PM] This error is related to http://tracker.firebirdsql.org/browse/DNET-156 to or is something new? Regards, Paul

Re: [Firebird-net-provider] How to stop all other database connections

2008-11-17 Thread Mercea Paul
hello i want to add some functionality to our application which will allow a user to alter the metadata of the database. before this happens i want to run some code which will ensure that all other users have been kicked out and are no longer accessing the Firebird 2.1 db. i was wondering

Re: [Firebird-net-provider] FbScript should have a constructor with string Script

2008-10-14 Thread Mercea Paul
-Original Message- From: Pham Huu Le Quoc Phuc [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2008 13:05 To: 'For users and developers of the Firebird .NET providers' Subject: [Firebird-net-provider] FbScript should have a constructor with string Script Dear all, My

Re: [Firebird-net-provider] .NET 2.0 Provider on PokcetPC connect error

2008-10-04 Thread Mercea Paul
always have this exception, 'No message for error code 335544721 found'. this is my code It's Unable to complete network request to host string. [PM] See if 3050 port is not blocked by firewall on host! Regards, Paul

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Mercea Paul
-Original Message- From: Steve Faleiro [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 11:29 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] ExecuteReader is slow 1. Did you try to optimize the query? I know Firebird

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Mercea Paul
Maybe you should change this to a stored procedure and pass parameters … should run more faster then your code! From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 10:24 To: For users and developers of the Firebird .NET providers Subject: Re:

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Mercea Paul
runtime. When I call ExecuteReader it takes too much time, about 0.028 seconds. On Mon, Sep 29, 2008 at 9:18 PM, Mercea Paul [EMAIL PROTECTED] wrote [PM] First: if database is on Windows change database name from name.gdb to name.fdb or something different from gdb Second: if you run thins from

Re: [Firebird-net-provider] ExecuteReader is slow

2008-10-04 Thread Mercea Paul
From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 12:23 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] ExecuteReader is slow Running a recursive cte against a table with about 1600 rows from my program

Re: [Firebird-net-provider] Server Engine`?

2008-10-03 Thread Mercea Paul
Hi Sven Are you talking about n-tier application? In that scenario each client connect to a 'server service' which communicate with database! Regards, Paul -Original Message- From: Sven [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2008 09:25 To:

Re: [Firebird-net-provider] Problems with parametrized queries (DDEX VS2008)

2008-10-02 Thread Mercea Paul
Could you show the code that execute this sql query? -Original Message- From: Zento [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2008 12:02 To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Problems with parametrized queries (DDEX VS2008)

Re: [Firebird-net-provider] ExecuteReader is slow

2008-09-30 Thread Mercea Paul
From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 12:02 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] ExecuteReader is slow 1. I changed query but ut's the same. 2. Yes, there are ascending indexes. 3.

Re: [Firebird-net-provider] ExecuteReader is slow

2008-09-30 Thread Mercea Paul
Here is source code: FbCommand cmd = BuildCommand(DbCommand); cmd.Parameters.AddWithValue(@from, From); cmd.Parameters.AddWithValue(@to, To); cmd.Parameters.AddWithValue(@code, Code); try { cmd.Connection.Open(); //This needs 0.028 seconds. return

Re: [Firebird-net-provider] Memory leak in ASP.NET pages showing a gridView accessing FirebirdSql.Data.FirebirdClient.dll

2008-09-25 Thread Mercea Paul
I have a memory leak issue. I have two ASP.NET pages that just have a timer that updates a label. One page also has a gridView that shows a little data. The page with just the label stays at a set memory usage. The page with the GridView keeps slowly taking more and more memory. On

Re: [Firebird-net-provider] Firebird embedded(ver 2.1) 64 bit support with DotNetFirebird client

2008-09-23 Thread Mercea Paul
-Original Message- From: Dean Harding [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2008 10:31 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Firebird embedded(ver 2.1) 64 bit support with DotNetFirebird client Sumit

Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data

2008-09-17 Thread Mercea Paul
On http://firebirdsql.org/index.php?op=filesid=netprovider you'll find all you need! By the way... my fbconnection.connection string property has no ... button , but I don't use this visual component, I have declared in my db class and build the connection string ... I think this is the most used

Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data

2008-09-17 Thread Mercea Paul
, 2008 9:56 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data --- Mercea Paul [EMAIL PROTECTED] wrote: On http://firebirdsql.org/index.php?op=filesid=netprovider you'll find all you need! By the way... my

[Firebird-net-provider] Sample project for Fb.Net Provider

2008-09-17 Thread Mercea Paul
Hi * I'm asking if is not a good to have a sample project on FB.Net provide page! If is someone interested .. Best regards, Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the

Re: [Firebird-net-provider] Sample project for Fb.Net Provider

2008-09-17 Thread Mercea Paul
This is a good start. I've missed the 'IDEA' from there..:) From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mercea Paul Sent: Wednesday, September 17, 2008 10:47 AM To: 'For users and developers of the Firebird .NET providers' Subject: [Firebird-net-provider] Sample project

Re: [Firebird-net-provider] FbDataConnectionUIControl

2008-09-17 Thread Mercea Paul
Hi Ulrich, Have you register your database in VS Server Explorer? If you do..on right click on registered database you can Modify Connection ... is the same window as displayed for connection string for fbconnection and for adding new connection for database in Server Explorer! Regards, Paul

Re: [Firebird-net-provider] Creating a Database using ADO.Net Data Provider For Firebird

2008-09-17 Thread Mercea Paul
Hi I'm using this: #region ConnectionString /// ///Connection String /// FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.UserID = USERDB; cs.Password = userdb;

Re: [Firebird-net-provider] install ddex 2.0.3 in vs2008 Team

2008-09-06 Thread Mercea Paul
After install you'll find README.TXT in firebird client ddex folder ! If this not helpful enough ask more help here! Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Freddy Caballero Sent: Saturday, September 06, 2008 4:49 AM To:

Re: [Firebird-net-provider] VS2008 DDEX probem

2008-09-04 Thread Mercea Paul
Try with FirebirdDDEXProviderPackageLess32 if you don't have VS SDK installed! Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christian Nylund Sent: Thursday, September 04, 2008 11:44 AM To: Firebird-net-provider@lists.sourceforge.net Subject:

Re: [Firebird-net-provider] Roadmap

2008-09-04 Thread Mercea Paul
Hi I'm using 2.5 all ready in several projects. As I know, 2.5 will provide .net entity provider ... Do you need something else? Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tetram Corp Sent: Thursday, September 04, 2008 3:16 PM

Re: [Firebird-net-provider] How / Can i detect the pagesize with fbprovider 2.x?

2008-09-03 Thread Mercea Paul
I think you can try with FbDatabaseInfo.PageSize !!! Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Möhle Sent: Wednesday, September 03, 2008 5:51 PM To: firebird-net-provider@lists.sourceforge.net Subject:

Re: [Firebird-net-provider] Help with SQL

2008-08-26 Thread Mercea Paul
ON (d.InvoiceID = i.InvoiceID) join InvoicePayment p ON (p.InvoiceID = i.InvoiceID) where (i.InvoiceID = :InvoiceID) group by i.SiteID, i.InvoiceID order by i.SiteID, i.InvoiceID Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mercea Paul Sent: Wednesday, August

Re: [Firebird-net-provider] Firebird .net + ZeBeDee + Events

2008-08-07 Thread Mercea Paul
As I remember you can set the event port in firebird.conf...at least in FB 2.1 # # The TCP Port Number to be used for server Event Notification # messages. The value of 0 (Zero) means that the server will choose # a port number randomly. # # Type: integer # #RemoteAuxPort = 0 Best regards, Paul

Re: [Firebird-net-provider] New in Firebird

2008-08-01 Thread Mercea Paul
There is no logic to do this in one SP.. Select * from DoSomething will return a dataset corresponding for your output parameters! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Lozano Sent: Friday, August 01, 2008 8:10 AM To:

[Firebird-net-provider] Error on building manually FB Provider

2008-07-20 Thread Mercea Paul
Hi I try to build manually FB provider from NETProvider\build\win32\ado.net\build.bat but I get error in build.log: [csc] d:\ProjectsCVS\FireBird\NETProvider\trunk\NETProvider\source\FirebirdSql\Dat a\Common\Charset.cs(25,14): error CS0234: The type or namespace name 'Linq' does not exist

[Firebird-net-provider] Firebird web provider

2008-06-19 Thread Mercea Paul
Hi all I have few propositions about SP for web provider 1. In ROLES_ISUSERINROLE and ROLES_ISEXISTS is : SELECT first(1) 1 FROM table INTO :RES; I propose to change this to : IF (EXISTS(SELECT 1 FROM table)) then RES=1; 2 SQL Statement like : select

Re: [Firebird-net-provider] web application sample

2008-06-18 Thread Mercea Paul
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mercea Paul Sent: 17 June 2008 21:27 To: [EMAIL PROTECTED]; 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] web application sample Hi Arnaud Something is wrong

[Firebird-net-provider] Firebird web provider - session table

2008-06-18 Thread Mercea Paul
Hi In session table LOCKED field is BOOL type (domain bool)? Can be made domains for all fields?Can I provide a script for this? Best regards, Paul - Check out the new SourceForge.net Marketplace. It's the best place to buy

Re: [Firebird-net-provider] Firebird web provider - session table

2008-06-18 Thread Mercea Paul
Of Jiri Cincura Sent: 18 June 2008 17:09 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Firebird web provider - session table On Wed, Jun 18, 2008 at 4:00 PM, Mercea Paul [EMAIL PROTECTED] wrote: Can be made domains for all fields?Can I

Re: [Firebird-net-provider] Firebird web provider - session table

2008-06-18 Thread Mercea Paul
You can create script for FB2.1 where you can use domains in SPs. [PM] Isn't more simple if I extract metadata for an empty database? This way every one can create a database with all domain, tables, SP! Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ |

[Firebird-net-provider] web application sample

2008-06-17 Thread Mercea Paul
Hi Jiri Do you have some sample project about how can I use CreateUserWizard and all other components from Login Tab from Tools in VS 2005/2008! I have configured Membership provider and role provider but I get always errors on execution! TIA Paul

Re: [Firebird-net-provider] web application sample

2008-06-17 Thread Mercea Paul
] On Behalf Of le roy arnaud Sent: 17 June 2008 17:29 To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] web application sample Jiri Cincura wrote: On Tue, Jun 17, 2008 at 3:58 PM, Mercea Paul [EMAIL PROTECTED] wrote: Do you have some sample project about

[Firebird-net-provider] Web provider - sql file

2008-06-14 Thread Mercea Paul
Hi Jiri I found few errors : 1.In FbMembershipProvider2.0.sql: There is one extra space in PK_USERS name ALTER TABLE USERS ADD CONSTRAINT PK_ USERS PRIMARY KEY (PKID); In procedure CREATE PROCEDURE MEMBERSHIP_DELETEUSER ( Comment line DELETE FROM USERSINROLES WHERE USERS There's no

Re: [Firebird-net-provider] execute store_procedure from application

2008-06-04 Thread Mercea Paul
Have you declared strlen? DECLARE EXTERNAL FUNCTION STRLEN CSTRING(32767) RETURNS INTEGER BY VALUE ENTRY_POINT 'IB_UDF_strlen' MODULE_NAME 'ib_udf'; Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 04 June 2008 08:29 To:

Re: [Firebird-net-provider] all news are duplicated

2008-06-03 Thread Mercea Paul
yes, after 20 May I get all messages twice! Bernhard Fischer wrote: Same here - I'm pretty sure that I suscribed only once, but I also get = the messages twice. This seems to happen since end of May or so. Bernhard Hi How can I get only 1 copy of news message and not 2 of them? The

Re: [Firebird-net-provider] crystal report problem

2008-06-03 Thread Mercea Paul
Hi Your report try to connect and get data ..you don't need that, you have already populated your table! All you need to do is to pass the tables to your report! Try to run your code after comment this lines conninfo.ServerName = pc205; conninfo.DatabaseName =

Re: [Firebird-net-provider] crystal report problem

2008-06-02 Thread Mercea Paul
Try to do something like this: 1. Populate your datatable dt and then ReportDocument rpt = new Rpt.rptD (); rpt.SetDataSource((DataTable)dt); Form frm_rpt = new frmReport(rpt); frm_rpt.ShowDialog(); Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

[Firebird-net-provider] all news are duplicated

2008-06-02 Thread Mercea Paul
Hi How can I get only 1 copy of news message and not 2 of them? The list admin can delete one subscription , if I have 2 with same e-mail??? I have unsubscribed and subscribed to ensure I'm just once registered.but always I get a duplicate for each message on this news group! Regards, Paul

Re: [Firebird-net-provider] crystal report problem

2008-06-02 Thread Mercea Paul
Hi Rakesh Show us your connection string ! Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kixzo Database Team Sent: 02 June 2008 14:14 To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] crystal report problem Hello All,

[Firebird-net-provider] Service API and nbackup

2008-04-20 Thread Mercea Paul
Hi Is there a way to specify for Backup service to use nbackup and make incremental backup? Regards, Paul - This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's

Re: [Firebird-net-provider] Service API and nbackup

2008-04-20 Thread Mercea Paul
On 4/20/08, Mercea Paul [EMAIL PROTECTED] wrote: Is there a way to specify for Backup service to use nbackup and make incremental backup? No. AFAIK nbackup isn't available thru Service API. Nether I can find any link to api for nbackup..hope you know more! This is a bad news...back

Re: [Firebird-net-provider] Service API and nbackup

2008-04-20 Thread Mercea Paul
21/04/2008, Mercea Paul wrote: On 4/20/08, Mercea Paul [EMAIL PROTECTED] wrote: Is there a way to specify for Backup service to use nbackup and make incremental backup? No. AFAIK nbackup isn't available thru Service API. Nether I can find any link to api for nbackup..hope you know

Re: [Firebird-net-provider] Error message attempted update of read-only column

2008-04-03 Thread Mercea Paul
Of course not. A deleted record is, well, DELETED. If you want to modify the record, then use UPDATE, not DELETE! ;-) The migration FB 2.X will be very difficult! This thread has become totally off topic for the net-provider forum but I must say I'm curious to know what you thought you

Re: [Firebird-net-provider] suspect - [SPAM] Re: Error message attempted update of read-only column

2008-04-02 Thread Mercea Paul
Hi Jiri First try 2.1 FirebirdClient. The 2.5 has still unfinished work on 2.1 protocol changes. This can cause problems. Same FB Client (2.5) run ok on FB 1.5.5 server! I thought is a problem from ODS structure ... but isn't! Regards, Paul

Re: [Firebird-net-provider] suspect - [SPAM] Re: Error message attempted update of read-only column

2008-04-02 Thread Mercea Paul
Hi Hellen, In Firebird 2 and higher you will get this exception if you have an AFTER trigger that attempts to update a column in the table that owns the trigger. That table have 5 triggers, 3 for Before Insert, 1 for Before Delete and 1 for Before Update. If I deactivate trigger from

Re: [Firebird-net-provider] suspect - [SPAM] Re: suspect - [SPAM] Re: Error message attempted update of read-only column

2008-04-02 Thread Mercea Paul
Then your Before Delete trigger probably has a reference to NEW.something. It is invalid in a delete trigger. Trigger ddl is: CREATE OR ALTER TRIGGER RPL_doc_invoice_BDEL FOR doc_invoice ACTIVE BEFORE DELETE POSITION 1000 as declare variable v_repl char(1); begin v_repl='N'; select

[Firebird-net-provider] Error message attempted update of read-only column

2008-04-01 Thread Mercea Paul
Hi Using FB 1.5.5 SS , FB.Net provider 2.5, VS C#2005. Database created with FB 1.5.3, ODS 10.1, Dialect 1. I have a SP which is running fine like execute procedure balance(@p1,@p2,@p3); The same database, but under FB 2.1 RC2 (17755), running same SP I get this error: base

  1   2   >