[Firebird-net-provider] Exception using AspNet.Identity
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 'FirebirdSql.Data.FirebirdClient.FbException' occurred in FirebirdSql.Data.FirebirdClient.dll but was not handled in user code Additional information: Dynamic SQL Error SQL error code = -204 Table unknown EdmMetadata At line 5, column 19 Any hint about this? TIA Paul Mercea -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Make FbNetProvider classes unseal
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. That is the main reason for this request. Lukáš Vykydal I don't remember if $Monitoring tables can help you on this . Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Firebird and VS 2015 preview
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 ___ -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-584) Add suport for Firebird 3
Add suport for Firebird 3 - Key: DNET-584 URL: http://tracker.firebirdsql.org/browse/DNET-584 Project: .NET Data provider Issue Type: New Feature Components: ADO.NET Provider Affects Versions: 4.6.0.0 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. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Insert into uncommitted table
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 Seed ? Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] EF Migrations
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 database. I'll going to try migrations steps and give feedback. Thanks Jiri Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-571) Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately
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 type=FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=4.5.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c//DbProviderFactories The problem on Windows 8.1 is that gacutil doesn't register Firebird client, but...using an older version it does. In Windows 8.1 is needed an installer to register the client, but the installer doesn't do this. I have user gacutil.exe version 4.0.30319.1 and works ok. Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-571) Firebird DDEX Provider Visual Studio 2013 SP3 - Connection dialog disappears immediately
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: http://tracker.firebirdsql.org/browse/DNET-571 Project: .NET Data provider Issue Type: Bug Components: DDEX Provider Affects Versions: 4.5.1.0 Environment: Windows 8.1 Pro x64, Visual Studio 2013 Professional SP3 Reporter: Jens Warkentin Assignee: Jiri Cincura Priority: Blocker see Cross-Post: StackOverflow: http://stackoverflow.com/questions/26377689/firebird-ddex-provider-visual-studio-2013-sp3-connection-dialog-disappears-imm I'm geting the same behavior, dialog generate error message for Visual Studio and close. Environment: Visual Studio 2014, update 4, Firebird 2.5 x86, DDEX 3.0.1, Windows 8.1 x64. Same error I get from project setting when i try to add a connection string, when i try to add a data source or when i try to modify a dataset. In Event Viewer i get this: Application: devenv.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.NullReferenceException Stack: at FirebirdSql.VisualStudio.DataTools.FbDataConnectionUIControl.SetProperty(System.Object, System.EventArgs) at System.Windows.Forms.Control.OnTextChanged(System.EventArgs) at System.Windows.Forms.ComboBox.OnTextChanged(System.EventArgs) at System.Windows.Forms.ComboBox.WmReflectCommand(System.Windows.Forms.Message ByRef) at System.Windows.Forms.ComboBox.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr) at System.Windows.Forms.UnsafeNativeMethods.SendMessage(System.Runtime.InteropServices.HandleRef, Int32, IntPtr, IntPtr) at System.Windows.Forms.Control.SendMessage(Int32, IntPtr, IntPtr) at System.Windows.Forms.Control.ReflectMessageInternal(IntPtr, System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.WmCommand(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.ContainerControl.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.UserControl.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr) at System.Windows.Forms.UnsafeNativeMethods.CallWindowProc(IntPtr, IntPtr, Int32, IntPtr, IntPtr) at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.DefWndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.WmCommand(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.ComboBox.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr, Int32, IntPtr, IntPtr) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG ByRef) at System.Windows.Forms.Application+ThreadContext.LocalModalMessageLoop(System.Windows.Forms.Form) at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Int32, System.Windows.Forms.ApplicationContext) at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Int32, System.Windows.Forms.ApplicationContext) at System.Windows.Forms.Application.RunDialog(System.Windows.Forms.Form) at System.Windows.Forms.Form.ShowDialog(System.Windows.Forms.IWin32Window) at Microsoft.Data.ConnectionUI.DataConnectionDialog.Show(Microsoft.Data.ConnectionUI.DataConnectionDialog, System.Windows.Forms.IWin32Window) at Microsoft.VisualStudio.Data.HostServices.Environment.ShowDialog(System.Windows.Forms.Form) at Microsoft.VisualStudio.Data.Package.DataConnectionDialog.ShowDialog() at Microsoft.VisualStudio.Editors.SettingsDesigner.ConnectionStringUITypeEditor.EditValue(System.ComponentModel.ITypeDescriptorContext,
Re: [Firebird-net-provider] EF Migrations
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 ___ -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Detect current connection is local or network
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 final step in installation process and check in your client startup if meet the correct version. Update if necessary . You dont need to know if client run locally or remote, you need to have compatibility between client app and server/database structure. -- Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Detect current connection is local or network
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 MON$ATTACHMENTS,like: select a.mon$remote_process, a.mon$remote_address from MON$ATTACHMENTS a Regards, -- Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Detect current connection is local or network
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 on same machine the client must be updated if is an update on 'server' side. I think you can achieve this by using a table for versioning (id, workstation,version,updated), or something similar. Best regards, Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Migrations
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 ___ E-mail: paul.mer...@almexa.ro ___ -- Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Exception using Firebird .NET provider and SimpleMembershipProvider in MVC4
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 was a hello world program in Mono on Debian a few years ago. My task is to write a simple web application using ASP.NET which connects to an existing Firebird database. User authentication has to use data in an existing table and I need to display data returned from a stored procedure. Updating data should call another stored procedure. I did some research and read quite a few articles about ASP.NET which led me to trying out MVC4, also the SimpleMembershipProvider sounded like what I need (I'm open for suggestions here). I have installed NETProvider-3.0.2.0 and DDEXProvider-3.0.0.0, created a new MVC4 Internet application, and in web.config adjusted/added the following: connectionStrings add name=DefaultConnection connectionString DbProviderFactoriesremove invariant=FirebirdSql.Data.FirebirdClient/ add name=Firebird Data Provider.. When I run the application and click on the Register link I get the following exception: {The ASP.NET Simple Membership database could not be initialized. ...} inner exception: {Dynamic SQL Error\r\nSQL error code = -104\r\nToken unknown - line 1, column 33\r\n.} with stack trace: at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at WebMatrix.Data.Database.QueryInternald__0.MoveNext() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source) at WebMatrix.Data.Database.QuerySingle(String commandText, Object[] args) at WebMatrix.WebData.DatabaseWrapper.QuerySingle(String commandText, Object[] parameters) at WebMatrix.WebData.SimpleMembershipProvider.CheckTableExists(IDatabase db, String tableName) at WebMatrix.WebData.SimpleMembershipProvider.CreateTablesIfNeeded() at WebMatrix.WebData.WebSecurity.InitializeMembershipProvider(SimpleMembershipProvider simpleMembership, DatabaseConnectionInfo connect, String userTableName, String userIdColumn, String userNameColumn, Boolean createTables) at WebMatrix.WebData.WebSecurity.InitializeProviders(DatabaseConnectionInfo connect, String userTableName, String userIdColumn, String userNameColumn, Boolean autoCreateTables) at WebMatrix.WebData.WebSecurity.InitializeDatabaseConnection(String connectionStringName, String userTableName, String userIdColumn, String userNameColumn, Boolean autoCreateTables) at MvcApplication1.Filters.InitializeSimpleMembershipAttribute.SimpleMembershipInitializer..ctor() in d:\Dinge\Documents\Visual Studio 2012\Projects\MvcApplication1\MvcApplication1\Filters\InitializeSimpleMembershipAttribute.cs:line 41 InitializeSimpleMembershipAttribute.cs:line 41 looks like this: WebSecurity.InitializeDatabaseConnection(DefaultConnection, UserProfile, UserId, UserName, autoCreateTables: true); which is called by: public override void OnActionExecuting(ActionExecutingContext filterContext) { // Ensure ASP.NET Simple Membership is initialized only once per app start LazyInitializer.EnsureInitialized(ref _initializer, ref _isInitialized, ref _initializerLock); } Can you tell me what went wrong here? Also, in general, how would I debug an error like this? I'd like to know what SQL statement was being executed but I couldn't find it in the exception dialog. Are there any log files? How can I step into the provider code? I'd be thankful for any hints on how to implement my application. Maybe I need to start from a different application template or use a different membership provider? TIA, Markus You have 2 options: 1. Use existing Firebird Membership a. First create a ASP.Net MVC3 application an close the solution. b. Create a ASP.Net MVC4 application. c. Copy from MVC3 Account controller and model. d. Configure web.config as usual FBMembershipProvider. 2. Write you own membership. You can view the sources from http://aspnetwebstack.codeplex.com/ as sample. HTH, Paul MERCEA ___ E-mail: paul.mer...@almexa.ro ___ -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] SPAM-LOW: Re: Asp.Net MVC - Log in failure with FbMembership
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 unsuccessful. Please correct the errors and try again. * The user name or password provided is incorrect. For those users i must edit the field PasswordFormat from 1 to 0 and the password. ___ -- BlackBerryreg; DevCon Americas, Oct. 18-20, San Francisco, CA Learn about the latest advances in developing for the BlackBerryreg; mobile platform with sessions, labs more. See new tools and technologies. Register for BlackBerryreg; DevCon today! http://p.sf.net/sfu/rim-devcon-copy1 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Asp.Net MVC - Log in failure with FbMembership
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 enablePasswordRetrieval=false enablePasswordReset=true requiresQuestionAndAnswer=false requiresUniqueEmail=false passwordFormat=Hashed maxInvalidPasswordAttempts=5 minRequiredPasswordLength=6 minRequiredNonalphanumericCharacters=0 passwordAttemptWindow=10 name=FBMembershipProvider type=FirebirdSql.Web.Providers.FbMembershipProvider, FirebirdSql.Web.Providers, Version=2.6.0.0, Culture=neutral, PublicKeyToken=3d06a02581b682f8 / I can register user, and new user is automatically log in application, if I try after log off, i get following error: Login was unsuccessful. Please correct the errors and try again. * The user name or password provided is incorrect. I have tried older version of NetProvider and WebProvider but unsuccessfully . Where should I look ? Tia, Paul -- Doing More with Less: The Next Generation Virtual Desktop What are the key obstacles that have prevented many mid-market businesses from deploying virtual desktops? How do next-generation virtual desktops provide companies an easier-to-deploy, easier-to-manage and more affordable virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] SPAM-LOW: Re: Asp.Net MVC - Log in failure with FbMembership
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 exception. I will investigate tomorrow...today i have tried with sqlprovider and work ok, with same code. ps. if i has tried with web provider and net provider version 2.0 i get an error,but i think is about data format /ODS from FB 2.5. Thanks, Paul ___ -- Doing More with Less: The Next Generation Virtual Desktop What are the key obstacles that have prevented many mid-market businesses from deploying virtual desktops? How do next-generation virtual desktops provide companies an easier-to-deploy, easier-to-manage and more affordable virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] SPAM-LOW: Re: Using FBEmbeded in ASP.NET
On 2011.01.11 10:18 AM, Jiri Cincura wrote: On Mon, Jan 10, 2011 at 21:35, Mercea Paulpaul.mer...@almexa.ro wrote: fbembed.dll is in \bin directory of the published site, but i get error. I'll try again this week! In ASP.NET it's worker process' location what matters. If the server isn't under your control, you will need to use ClientLibrary. The server is hosted and i have no control of anything! I can just copy files to server! The server have IIS 7 and ASP.Net with support for .Net Framework 4.0, 3.5, 3.0 and 2.0. Thats the reason i need to specify in connectionstring the client 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 to best implement a security strategy that keeps consumers' information secure and instills the confidence they need to proceed with transactions. http://p.sf.net/sfu/oracle-sfdevnl ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] SPAM-LOW: Re: Using FBEmbeded in ASP.NET
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 -- 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 strategy that keeps consumers' information secure and instills the confidence they need to proceed with transactions. http://p.sf.net/sfu/oracle-sfdevnl ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] SPAM-LOW: Re: FBSecurity UserPassword
Hi Rick I am trying to write a utility program to add/update/delete users from the database, but I don't always know their password so it seems like Update would be impossible. You can use : CREATE USER username {PASSWORD 'password'} [FIRSTNAME 'firstname'] [MIDDLENAME 'middlename'] [LASTNAME 'lastname'] [GRANT ADMIN ROLE]; ALTER USER username [PASSWORD 'password'] [FIRSTNAME 'firstname'] [MIDDLENAME 'middlename'] [LASTNAME 'lastname'] [{GRANT | REVOKE} ADMIN ROLE]; DROP USER username; Try to use this functionality for yout utility program! Check Firebird_v2.5.0.ReleaseNotes.pdf 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 strategy that keeps consumers' information secure and instills the confidence they need to proceed with transactions. http://p.sf.net/sfu/oracle-sfdevnl ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Using FBEmbeded in ASP.NET
Hi I know I can use |DataDirectory|mydatabase.fdb to specify location for database but, when i use the embeded firebird, in connection string i specify the servertype and clientlibrary! If i use for clientlibrary |DataDirectory|\fbembed.dll i get error. Until now I was know the full path 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 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 strategy that keeps consumers' information secure and instills the confidence they need to proceed with transactions. http://p.sf.net/sfu/oracle-sfdevnl ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] problem with a query (maybe a bug)
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 userinfo0_ where exists (select 1 from User_Views_Map views1_ where userinfo0_.id=views1_.User_Id and views1_.view_...@p0) Regards Paul -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] IntPtr and SafeHandle
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 Firebird .NET providers Subject: [Firebird-net-provider] IntPtr and SafeHandle Hi *, for embedded server implementation we're using IntPtr on a lot of places. But there's a small chance that this handle will leak - when the thread executing the code is killed after the execution and before assignment. As I said, this is ***very*** unlikely (we're here talking in IL instructions level), but using SafeHandle is a recommended approach. As this could affect only really long running applications using embedded server and it's very unlikely, I would like to hear you opinions whether to escalate this potential issue or leave it with minor priority. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection error using Virtual PC Windows XP Mode
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 (FB 2.5 RC2). Other applications (non .NET) are able to access the same database on the same VM with no issue. FbClient is deployed to the machine GAC of the XP virtual machine. Am I missing something here?? pls help. Thanks. Show us your connection string! Regards, Paul -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Character set problem between with Firebird .NET provider
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 error: ERROR [HY000] [ODBC Firebird Driver][Firebird]arithmetic exception, numeric overflow, or string truncation Cannot transliterate character between character sets [PM] For me , this error dissapeared after reinstalling Firebird! Regards, Paul -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS2010 dat providers
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 2005, 2008 2010 ? -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Framework, Firebird and Guid
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 http://blog.vyvojar.cz/jirka/archive/2007/07/08/guid-in-firebird.aspx and then generate entity classes from the database the wizard creates Entities with Strings. If i try to save something into the Database i get an exception which complains about malformed Guids. Can you suggest a Datatype that's close to the 128 bit of a Guid that i can use in the storage and conceptual model of the edmx? P.S. the combination of firebird with its small footprint and easy installation and the entity framework is really great. beside my small guid problem everything works flawless and rock solid. [PM] I'll vote to support at provider level the guid. I have the same problems with my web apps and i must work with triggers to achieve the results i needed. Guid differ from uuid and is annoying to create workaround to achieve something that should be easy. Regards, Paul -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ 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 get started...
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 Subject: [Firebird-net-provider] how to get started... My interested in developing on the Firebird .Net Provider is to figure out why the dialog simply goes away after entering a value in it. I have downloaded the trunk and it is compiling just fine. The million dollar question is: how do I installed the compiled version such that I can debug the code? I looked at the Visual Studio 2009 SDK help and nothing jumped out at me. Might someone be a kind sole and point me in the right direction? Sam --- --- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ 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 get started...
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, Paul -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] New version of provider breaks batch execution
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 install different apps build with Fb provider! I'm worry if 'others' will install Fb provider in gac ... Regards, Paul -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [SPAM] Re: =?ISO-8859-2?Q?can not use
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 fbembed.dll - 2.1.2 and dir intl to /bin dir of my ASP .Net page but problem is the same error occure after this simple line Var con: Firebird.Data.Firebird.FBConnection; begin con:= Firebird.Data.Firebird.FBConnection.Create; i miss somethink? please help [PM] I use something like this FbConnectionStringBuilder fbcs = new FbConnectionStringBuilder(); fbcs.Database = apppath + @\path to my database ; fbcs.Charset = NONE; fbcs.ClientLibrary = apppath + @\fb\fbembed.dll; fbcs.Dialect = 3; fbcs.UserID = SYSDBA; fbcs.Password = masterkey; fbcs.Pooling = false; fbcs.ServerType = FbServerType.Embedded; DataTable dt = new DataTable(); using (FbConnection fb = new FbConnection(fbcs.ToString())) { try { fb.Open();. Regards, Paul -- Register Now Save for Velocity, the Web Performance Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Deployment issue/maintenance issue
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 Entity wich is based on System.Data.Entity. There are cases where I can't enforce end user or administrator to install .Net Framework 3.5!But I need all improvements from Fb provider. What should I do in these cases? Keep in me deployments the old Fb.Net Provider? Can be separated entity from provider? Should I compile my own Fb provider? Best Regards, Paul -- Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Instalation error message for Beta 2
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 installer has encountered an unexpected error installing this package.This may indicate a problem with this package.The error code is 2869. Regards, Paul -- This SF.net email is sponsored by: High Quality Requirements in a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Instalation error message for Beta 2
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 a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-219) Port number keyword not supported in entity connection
Port number keyword not supported in entity connection -- Key: DNET-219 URL: http://tracker.firebirdsql.org/browse/DNET-219 Project: .NET Data provider Issue Type: Bug Components: 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 I try to use EntityConnection. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- ___ 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 configure provider for Entity
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! -- ___ 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 configure provider for Entity
Hi Jiri You need to have DDEX installed. It is installed! Everything is working fine, for all other projects! In this project is working too except the step to create new connection for entity model. Look at this page (tutorial).. http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtFirebirdEDM I like to make step 11...but I have not Firebird .Net provider in the list!. Best regards, Paul -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Thursday, April 02, 2009 19:09 To: For users and developers of the Firebird .NET providers Subject: Re: [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/ | http://www.ID3renamer.com --- --- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] [SPAM] RE: Want to run 'gbak.exe' from
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 'gbak.exe' from I apologize for the delay in responding... the path is a local drive, the same one with Firebird on it... I have tried the code below, with the indicated error: FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.UserID = SYSDBA; cs.Password = masterkey; cs.Database = dbBooks; FbBackup backupSvc = new FbBackup(); backupSvc.ConnectionString = cs.ToString(); backupSvc.BackupFiles.Add(new FbBackupFile(@j:\prager\backup\\testdb.gbk, 2048)); backupSvc.Verbose = true; backupSvc.Options = FbBackupFlags.IgnoreLimbo; backupSvc.ServiceOutput += new ServiceOutputEventHandler(ServiceOutput); backupSvc.Execute(); // -- error: Cannot attach to services manager service :service_mgr is not defined Zvjezdan Tomicevic wrote: Just one more thing Your path j:\\Prager\\Backup\\backup.fbk. Is J network drive that you are referencing, or J is disk drive on computer with firebird server on it. I mean like hard disk J. When you are doing backup (as far as I remember) you need to specify path local to firebird server. You need to reference hard disk as if you were on server like C:\bkp\bkp.fbk where c is drive on server machine, not your J network reference to C drive. On Tue, Feb 17, 2009 at 9:57 PM, Rolf Marsh rmma...@fastmail.us mailto:rmma...@fastmail.us wrote: Thank you... I'll let you know... R Zvjezdan Tomicevic wrote: I've sent it to rmma...@fastmail.us mailto:rmma...@fastmail.us as a RAR file. Hope this helps On Tue, Feb 17, 2009 at 9:49 PM, Zvjezdan Tomicevic zek...@gmail.com mailto:zek...@gmail.com wrote: Well, you need .NET 3.5 to use it, or get source and build it for .NET 2.0 or I,ll just send you one right now, latest build for 2.0. It comes in few minutes. On Tue, Feb 17, 2009 at 9:43 PM, Rolf Marsh rmma...@fastmail.us mailto:rmma...@fastmail.us wrote: Error message: Could not load file or assembly 'System.Data.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. Program, which used to work under 2.0.1, now no longer works... R Zvjezdan Tomicevic wrote: Thats the one. http://downloads.sourceforge.net/firebird/FirebirdClient-2.5.0- Beta1.msi If you use events and FB2.1 you can get the latest version from SVN. I use it in production with no prob. (Basic dbaccess). Just try it out and see if it is provider issue. On Tue, Feb 17, 2009 at 9:17 PM, Rolf Marsh rmma...@fastmail.us mailto:rmma...@fastmail.us wrote: Where do I find it? (I looked, but can only find Firebird Client 2.5 BETA) Zvjezdan Tomicevic wrote: Try gettting the latest 2.5 Beta.Net provider. No matter it is still beta. On Tue, Feb 17, 2009 at 9:00 PM, Rolf Marsh rmma...@fastmail.us mailto:rmma...@fastmail.us wrote: Firebird version is 2.0.5, .NET Provider version is 1.7 R Zvjezdan Tomicevic wrote: And your Firebird version and .Net provider version? On Tue, Feb 17, 2009 at 8:54 PM, Rolf Marsh rmma...@fastmail.us mailto:rmma...@fastmail.us wrote: Yes, it's on the same machine... Zvjezdan Tomicevic wrote: Is path j:\\Prager\\Backup\\backup.fbk local to you firebird server? I mean is drive J physical drive on your firebird server? - - Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut
Re: [Firebird-net-provider] Charset problems
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... . fbcs.Dialect = 3; 2. you can use collate for that field: SELECT * FROM T1 WHERE UPPER(COL1 COLLATE PXW_CYRL) = 'ÔÛÂÀ' select blob_column from table where blob_column collate unicode = 'foo'; HTH, Paul -Original Message- From: Barbiturico76 [mailto:lucadomenos...@nospuminwind.it] Sent: Wednesday, March 11, 2009 05:13 To: For users and developers of the Firebird .NET providers Subject: [Firebird-net-provider] Charset problems Dear Firebird gurus, I need your help! I'm a C# developer and I'm experencing some troubles when retrieving data from a Firebird 2.0 server. When I get data (text) from VarChar fields or Blob type 0 fields, I always receive the char '?' instead of 'à', 'é', 'ì', 'ò' or 'ù' and I really cannot understand why. The data are correctly stored in the DB because when I use FlameRobin 0.8.6 to read data, those strings are read correctly. I use the Firebird .NET Data Provider Version 2.1.0 for .NET 2.0 inside Visual Studio 2008 good installed and working. Maybe it is a problem of character encoding... I tried to understand this aspect but made no step ahead. What I know is that the original DB has ASCII charset (FlameRobin rules!), and in the connection string inside VB2008 the charset called is ASCII too. Could you please give me a tip to solve my problem? Or redirect me to someone knowing how... Thx in advance. Luca D Italy --- --- Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [FB-Tracker] Created: (DNET-216) New property in connection string builder - Trusted authentication
New property in connection string builder - Trusted authentication -- Key: DNET-216 URL: http://tracker.firebirdsql.org/browse/DNET-216 Project: .NET Data provider Issue Type: 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 on FB2.5 and i need support from admin. The admin is authenticating and try to connect with his rights...but I don't want to modify the connection string, I want just to set Trusted Authentication to True and this way to avoid userid and password from connection string. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] GUID handling (CHAR (16) OCTETS)
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. I can solve this by using stored procedures and UDFs, I just want to indicate this problem. I'm dealing with the same situation but I solved in this way: MembershipUser u = Membership.GetUser(Variables.UserName); Variables.UserGuid = (Guid)u.ProviderUserKey; And for insert (for this user) I pass Variables.UserGuid as GUID for insert parameter. It's working for me! Best regards, Paul -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [SPAM] RE: Want to run 'gbak.exe' from within
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 backup location from parameters; string dbbackup = Functions.GetSystemParameter(SYS, SYS_DB_BACKUP); if (File.Exists(dbbackup) ) { File.Delete(dbbackup); } if (!Directory.Exists(dbbackup)) { Directory.CreateDirectory(Path.GetDirectoryName(dbbackup)); } //string backfile = Path.ChangeExtension(Properties.Settings.Default.AppDataBase, fbk); fbbsvc.BackupFiles.Add(new FbBackupFile(dbbackup, 2048)); //fbbsvc.BackupFiles.Add(new FbBackupFile(Path.ChangeExtension(Properties.Settings.Default.AppDataBase, fbk), 2048)); fbbsvc.Verbose = chkVerbose.Checked; if (chkIgnoreCheckSum.Checked) { fbbsvc.Options = FbBackupFlags.IgnoreChecksums; } if (chkIgnoreLimbo.Checked) { fbbsvc.Options = FbBackupFlags.IgnoreLimbo; } if (chkMetadata.Checked) { fbbsvc.Options = FbBackupFlags.MetaDataOnly; } if (chkGarbage.Checked) { fbbsvc.Options = FbBackupFlags.NoGarbageCollect; } if (chkOldMetadata.Checked) { fbbsvc.Options = FbBackupFlags.OldDescriptions; } if (chkConvertTables.Checked) { fbbsvc.Options = FbBackupFlags.Convert; } //if (chkTransportable.Checked) {fbbsvc.Options = FbBackupFlags.NonTransportable ; } fbbsvc.ServiceOutput += new ServiceOutputEventHandler(BackupOutput); lbBackup.Items.Clear(); lbBackup.Items.Add(Start BackUp: + DateTime.Now.ToString()); fbbsvc.Execute(); lbBackup.Items.Add(End BackUp: + DateTime.Now.ToString() + ); lbBackup.Items.Add( ); lbBackup.SelectedIndex = lbBackup.Items.Count - 1; } private void BackupOutput(object sender, ServiceOutputEventArgs e) { //show the message switch (cmbOutput.SelectedIndex) { case 0: lbBackup.BeginUpdate(); lbBackup.Items.Add(e.Message); lbBackup.EndUpdate(); lbBackup.SelectedIndex = lbBackup.Items.Count-1; lbBackup.Refresh(); break; case 1: if (!File.Exists(tbBackupLogFile.Text)) { using (StreamWriter sw = File.CreateText(tbBackupLogFile.Text)) { sw.WriteLine(DateTime.Now.ToString() + + e.Message); } } else { using (StreamWriter wr = File.AppendText(tbBackupLogFile.Text)) { wr.WriteLine(DateTime.Now.ToString() + + e.Message); } } break; } HTH Paul From: Rolf Marsh [mailto:rmma...@fastmail.us] Sent: Tuesday, February 17, 2009 20:15 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Want to run 'gbak.exe' from within HI Juergen... OK... I'll just leave it at 2048... my major problem is that I'm getting a message Cannot attach to services manager service :service_mgr is not defined when I try any of the examples at http://fisheye1.atlassian.com/browse/firebird/NETProvider/NETProvider_17/sou rce/FirebirdSql.Data.Firebird.UnitTest/FbServicesTests.cs?r=1.10 ... any idea of where to find out how to fix this? (I have looked everywhere on the web, found mentions of it, but nothing to indicate how to fix it). I really appreciate your help... Rolf VS-Polis wrote: Hi Rolf, I read in the Firebird ADO.NET Provider SDK Documentation and don't understand this property. The only information I found was an example in the FbBackup class: backupSvc.BackupFiles.Add(new FbBackupFile(@c:\testdb.gbk, 2048)); In the IBExpert documentation I found this information: A file size only needs to be specified when working with secondary files. I suppose this value is unimportant normally. Juergen Rolf Marsh schrieb: I took a look at FirebirdSql.Data.FIrebird.Services namespace, and decided to try the FbBackup method as a test. In the BackupFiles method, it asks for the output filename and size... how does one determine what the size of the output file is going to be prior to doing the backup? Rolf -- Open Source Business Conference (OSBC), March 24-25,
[Firebird-net-provider] [SPAM] RE: [SPAM] RE: Want to run 'gbak.exe' from within
How looks your connection string? I think you miss something...data source = localhost ... Regards, Paul From: Rolf Marsh [mailto:rmma...@fastmail.us] Sent: Tuesday, February 17, 2009 21:08 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] [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: -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [SPAM] RE: [SPAM] RE: [SPAM] RE: Want to run 'gbak.exe' from within
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 defined as alias in aliases.config then you should write full path to database ! -- Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] [SPAM] RE: [SPAM] RE: Want to run 'gbak.exe' from within
How looks your connection string? I think you miss something...data source = localhost ... Regards, Paul From: Rolf Marsh [mailto:rmma...@fastmail.us] Sent: Tuesday, February 17, 2009 21:08 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] [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 sender, EventArgs e) { //backup with service FbBackup fbbsvc = new FbBackup(); fbbsvc.ConnectionString = Properties.Settings.Default.AppConnStr; //take backup location from parameters; string dbbackup = Functions.GetSystemParameter(SYS, SYS_DB_BACKUP); if (File.Exists(dbbackup) ) { File.Delete(dbbackup); } if (!Directory.Exists(dbbackup)) { Directory.CreateDirectory(Path.GetDirectoryName(dbbackup)); } //string backfile = Path.ChangeExtension(Properties.Settings.Default.AppDataBase, fbk); fbbsvc.BackupFiles.Add(new FbBackupFile(dbbackup, 2048)); //fbbsvc.BackupFiles.Add(new FbBackupFile(Path.ChangeExtension(Properties.Settings.Default.AppDataBase, fbk), 2048)); fbbsvc.Verbose = chkVerbose.Checked; if (chkIgnoreCheckSum.Checked) { fbbsvc.Options = FbBackupFlags.IgnoreChecksums; } if (chkIgnoreLimbo.Checked) { fbbsvc.Options = FbBackupFlags.IgnoreLimbo; } if (chkMetadata.Checked) { fbbsvc.Options = FbBackupFlags.MetaDataOnly; } if (chkGarbage.Checked) { fbbsvc.Options = FbBackupFlags.NoGarbageCollect; } if (chkOldMetadata.Checked) { fbbsvc.Options = FbBackupFlags.OldDescriptions; } if (chkConvertTables.Checked) { fbbsvc.Options = FbBackupFlags.Convert; } //if (chkTransportable.Checked) {fbbsvc.Options = FbBackupFlags.NonTransportable ; } fbbsvc.ServiceOutput += new ServiceOutputEventHandler(BackupOutput); lbBackup.Items.Clear(); lbBackup.Items.Add(Start BackUp: + DateTime.Now.ToString()); fbbsvc.Execute(); lbBackup.Items.Add(End BackUp: + DateTime.Now.ToString() + ); lbBackup.Items.Add( ); lbBackup.SelectedIndex = lbBackup.Items.Count - 1; } private void BackupOutput(object sender, ServiceOutputEventArgs e) { //show the message switch (cmbOutput.SelectedIndex) { case 0: lbBackup.BeginUpdate(); lbBackup.Items.Add(e.Message); lbBackup.EndUpdate(); lbBackup.SelectedIndex = lbBackup.Items.Count-1; lbBackup.Refresh(); break; case 1: if (!File.Exists(tbBackupLogFile.Text)) { using (StreamWriter sw = File.CreateText(tbBackupLogFile.Text)) { sw.WriteLine(DateTime.Now.ToString() + + e.Message); } } else { using (StreamWriter wr = File.AppendText(tbBackupLogFile.Text)) { wr.WriteLine(DateTime.Now.ToString() + + e.Message); } } break; } HTH Paul From: Rolf Marsh [mailto:rmma...@fastmail.us] Sent: Tuesday, February 17, 2009 20:15 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Want to run 'gbak.exe' from within HI Juergen... OK... I'll just leave it at 2048... my major problem is that I'm getting a message Cannot attach to services manager service :service_mgr is not defined when I try any of the examples at http://fisheye1.atlassian.com/browse/firebird/NETProvider/NETProvider_17/sou rce/FirebirdSql.Data.Firebird.UnitTest/FbServicesTests.cs?r=1.10 ... any idea of where to find out how to fix this? (I have looked everywhere on the web, found mentions of it, but nothing to indicate how to fix it). I really appreciate your help... Rolf VS-Polis wrote: Hi Rolf, I read in the Firebird ADO.NET Provider SDK Documentation and don't understand this property. The only information I found was an example in the FbBackup class: backupSvc.BackupFiles.Add(new FbBackupFile(@c:\testdb.gbk, 2048)); In the IBExpert documentation I found this information: A file size only needs to be specified when working
[Firebird-net-provider] Same user id have diferent value in membership and uuid_to_char ()
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 return this code: d1f5d194-5fa8-4ba1-bcf5-a4a788b58c1a. This id is used for further query's. If i try any query like : SELECT BROKER, COMMODITY FROM ORDERS WHERE (IDTRADER) = @IDTRADER) Is not working The following query is working with correct values: SELECT BROKER, COMMODITY FROM ORDERS WHERE (uuid_to_char(IDTRADER) = @IDTRADER) But from database if I run: select uuid_to_char(pkid),username from users this id return D194D1F5-5FA8-4BA1-F5BC-A7A4B5881A8C this is different string .and is for same user : String from Membership: d1f5d194-5fa8-4ba1-bcf5-a4a788b58c1a String from database: D194D1F5-5FA8-4BA1-F5BC-A7A4B5881A8C This is a bug Regards, Paul -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Fw: Connetion pooling problem
You could try to specify pooling and connection timeout like: connectionString=character set=NONE;initial catalog=database.FDB;user id=SYSDBA;password=pass;data source=localhost;Connection timeout=15;Pooling=True; This is not 100% solution for your problem, but you could give a try! HTH, Paul From: Ali Erdogan [mailto:allierdo...@yahoo.com] Sent: Thursday, February 05, 2009 23:23 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Fw: Connetion pooling problem Hi Mercea, connectionString=character set=NONE;initial 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 firebird-net-provider@lists.sourceforge.net Sent: Thursday, February 5, 2009 21:52:29 Subject: Re: [Firebird-net-provider] Fw: Connetion pooling problem 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 problem Hi, I have an application written on asp.net with Firebird .net provider and Firebird Classic 1.5.2 I have a connection string in my web.config file and i always use this con string to establish a connection. However when i check the number of the connections in the pool i see more then one connection in the pool. And by the incrising the number of the connections in the pool the connection is getting blocked. I am carefull to close the connections. Do i make something wrong? Ali Erdoğan / İstanbul / Türkiye http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http:/mail.promotions.yahoo.com/newdomains/aa/ _ New Email names for you! http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http:/mail.promotions.yahoo.com/newdomains/aa/ Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! _ New http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http:/mail.promotions.yahoo.com/newdomains/aa/ Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Fw: Connetion pooling problem
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 problem Hi, I have an application written on asp.net with Firebird .net provider and Firebird Classic 1.5.2 I have a connection string in my web.config file and i always use this con string to establish a connection. However when i check the number of the connections in the pool i see more then one connection in the pool. And by the incrising the number of the connections in the pool the connection is getting blocked. I am carefull to close the connections. Do i make something wrong? Ali Erdoğan / İstanbul / Türkiye http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http:/mail.promotions.yahoo.com/newdomains/aa/ _ New http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http:/mail.promotions.yahoo.com/newdomains/aa/ Email names for you! Get the Email name you've always wanted on the new @ymail and @rocketmail. Hurry before someone else does! -- Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Programs refuse to run with new dll 2.5.0.0 beta
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 get this error message! Trusted Auth wasn't implemented for Embedded Firebird I have replaced the new dll with the old one and my programs works ok. TIA, Paul -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Programs refuse to run with new dll 2.5.0.0 beta
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 = false; fbcs.ServerType = FbServerType.Embedded; DataTable dt = new DataTable(); using (FbConnection fb = new FbConnection(fbcs.ToString())) { try { fb.Open(); - Here I get that error. I'll try to specify username and password...but just tomorrow . Best Regards, Paul -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] log filled with INET error 10054
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 -- This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword ___ 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 stop all other database connections
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 what the best way is to achieve this perhaps via connection pooling or GBAKing to another location? or is there an easier way? [PM] Take a look at README.monitoring_tables.txt ! Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbScript should have a constructor with string Script
-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 situation: I write a software with 2 part: client program and server program. - At client program, I don't add reference FirebirdClient.dll. When user want to execute a script db, because FirebirdClient.dll not reference, I can't parse at here by use FbScript. Client program send script(string) to server program. - At server program, it accesses db and execute scripts. But here I can't use FbScript because it does't has constructor with a script(string) I know FbScript it has 2 constructors 1. TextReader 2. FileName I think should add a contructor with string script. [PM] This design could easily generate conflicts in your app if each client could run scripts. IMHO all scripts should be on server side and not on client side. The server could run a script based on script identifier, that script is unique to your system and can be run as many time you want from any client you want. Regards, Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] .NET 2.0 Provider on PokcetPC connect error
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 - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ExecuteReader is slow
-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 has an optimizer that optimizes every query but sometimes a Instead of: SELECT SUM(nsum), card FROM op WHERE smth = @from AND smth= @to AND bal = @code group by card Try: SELECT card, SUM(nsum) FROM op WHERE smth = @from AND smth= @to AND bal = @code group by card [PM] I would change this to SELECT card, SUM(nsum) FROM op WHERE (bal = @code) AND (smth between @from AND @to) group by card Regards, Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ExecuteReader is slow
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: [Firebird-net-provider] ExecuteReader is slow Well, it is fast if you call it once but for 2000 class it's about one minute. It's taking about 85% of the whole action. On Tue, Sep 30, 2008 at 11:16 AM, Steve Faleiro [EMAIL PROTECTED] wrote: IMHO, 0.028 seconds seems to be pretty quick. That is 3/10ths of a second. What were you expecting? --- giorgi giorgi [EMAIL PROTECTED] wrote: Hello, I am using 2.1 version of firebird. Fb.NEt provider version is 2.0.1.0Connection string looks like this: User=SYSDBA;Password=masterkey;Datasource=xxx;Database=name.gdb; (xxx is just symbolic here) Command looks like this: SELECT SUM(nsum), card FROM op WHERE smth = @from AND smth= @to AND bal = @code group by card from, to and code parameters are added during runtime. When I call ExecuteReader it takes too much time, about 0.028 seconds. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100 http://moblin-contest.org/redirect.php?banner_id=100url=/ url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ExecuteReader is slow
From: giorgi giorgi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 30, 2008 09:41 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] ExecuteReader is slow Hello, I am using 2.1 version of firebird. Fb.NEt provider version is 2.0.1.0 Connection string looks like this: User=SYSDBA;Password=masterkey;Datasource=xxx;Database=name.gdb; (xxx is just symbolic here) Command looks like this: SELECT SUM(nsum), card FROM op WHERE smth = @from AND smth= @to AND bal = @code group by card from, to and code parameters are added during 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 isql, fbexpert or what you use for design, can you show the plan for this sql?Maybe you don’t have index on smth and/ or bal field. Regards, Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ExecuteReader is slow
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 needs the same time so I think it's providers issue. 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 cmd.ExecuteReader(CommandBehavior.CloseConnection); } [PM] Can you close the connection after executing all 2000 commands, and not for each iteration??? [PM] something like FbCommand cmd = BuildCommand(DbCommand); cmd.Parameters.AddWithValue(@from, From); cmd.Parameters.AddWithValue(@to, To); cmd.Parameters.AddWithValue(@code, Code); try { cmd.Connection.Open(); Foreach (your iteration) { return cmd.ExecuteReader() } } Catch() { } Finally { cmd.Connection.close() } Regards, Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Server Engine`?
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: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Server Engine`? Hello, I will start to develop a multi user windows forms application with firebird as database and visual studio 2005 as development system. I use datasets in my application and have problems when multiple users change data in database. My question is: how do you handle the dataset problem? I would like to know if there is a tool which enables a 'server engine'. The server engine is the only tasks that communicates with the database and every application communicates with the server process. The server engine should lock the data when it is in use - every other application may hav a copy but no possibility to edit data ( in the table row) . If the client application task has ended the server engine should release the lock. Would another database except firebird handle this situation in a better way than can be realized with firebird? I know of Turbopower Flashfiler which is capable to do it like I want to... Thanks for your replies Sven - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Problems with parametrized queries (DDEX VS2008)
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) Hello everybody. I'm trying to use Firebird as RDBMS for a new ASP.NET web project to test, as I'm totally new to this technology. I've installed Firebird 2.1.1, Firebird Client 2.1.0.0 and DDEX 2.0.4.0 and using SqlDataSource with Firebird bindings. Everything works perfectly for queries like SELECT * FROM Table, but when I try to use a parametrized query with a join, SqlDataSource can't retrieve schema: When using this query: SELECT UsuDisp.Dispositivos, Usu.IDUsuario, Usu.Usuario, Usu.Nombre FROM UsuariosDispositivos UsuDisp LEFT OUTER JOIN Usuarios Usu ON (Usu.IDUsuario = UsuDisp.Usuario) WHERE UsuDisp.Dispositivos = ? The Test Query button show this error: SQLDA missing or incorrect version, or incorrect number/type of variables. Then tryed through Query Builder, and parameter changed: SELECT UsuDisp.Dispositivos, Usu.IDUsuario, Usu.Usuario, Usu.Nombre FROM UsuariosDispositivos UsuDisp LEFT OUTER JOIN Usuarios Usu ON Usu.IDUsuario = UsuDisp.Usuario WHERE (UsuDisp.Dispositivos = @Param1) Execute Query button worked correctly, but Test Query button show this error: Must declare command parameters. Tryed also to fill SelectQuery property directly, adding a named and typed parameter manually, but same error showed again. Same query using Microsoft ODBC provider + Firebird ODBC driver worked correctly, but I think this is not the better way... Any thought? Thank you in advance. -- View this message in context: http://www.nabble.com/Problems-with- parametrized-queries-%28DDEX-VS2008%29-tp19775726p19775726.html Sent from the firebird-net-provider mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ExecuteReader is slow
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. Not very. The file is about 3Gb and op table has about 4,000,000 records. 4. Executing stored procedure takes the same time. According to profiler it is Prepare method that takes most of the time. [PM] Have you heard about ‘Prepare once, run many!’ ? You prepare your statement ONCE and run many times with different parameters! I doubt the SP can run faster Regards, Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ExecuteReader is slow
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 cmd.ExecuteReader(CommandBehavior.CloseConnection); } [PM] Try something like : FbCommand cmd = BuildCommand(DbCommand); try { cmd.Connection.Open(); - //This needs 0.028 seconds. Foreach (DataRow parameter in YourParamlist) { Get your param …. From = parameter[“From].ToString(); …… cmd.Parameters.AddWithValue(@from, From); cmd.Parameters.AddWithValue(@to, To); cmd.Parameters.AddWithValue(@code, Code); FBDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Do what you need; } } } [PM] I sustain that this will run faster with SP ! Regards, Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Memory leak in ASP.NET pages showing a gridView accessing FirebirdSql.Data.FirebirdClient.dll
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 Server 2003 it will eventually take up so much memory that IIS stops serving the page. I get the same issue on XP but have not let it run until it ran out of memory. [PM] What process consume the memory? IIS? FbServer? Regards, Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird embedded(ver 2.1) 64 bit support with DotNetFirebird client
-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 Vij wrote: I am using the latest version of FB client i.e. 2.1.0.0 http://2.1.0.0. By looking the the code, all the handles type are of type 'int' which will not work on x64. And statusvector is also of type int which is of type int[]. Am i missing something? Can you point me to the Fblclient that works on 64 bit platform? I think somebody already mentioned that you'll need 2.5.0 (which is currently in alpha): http://firebirdsql.org/index.php?op=filesid=netprovider However, I've been successfully using 2.5 in production for a while now without issues (I don't use any of the more esoteric features where bugs are probably more likely, however..) Dean. [PM] As I know Fb Provider 2.5 is like 2.1 release candidate plus .Net Entity Framework ... I use 2.5 in production with no problems! Regards, Paul ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data
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 scenario! Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Meftah Tayeb Sent: Tuesday, September 16, 2008 11:58 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data hi Paul, please, send to me the URL to download the latest version of Firebird ADO.Net Data Provider And DDEX Provider For Visual Studio 2005 i have firebird DDEX provider V2.0. i folo the read me file, using the machine.config file but i get the SAM Error any help my friends ? thanks for your suggestions! --- -- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ado.Net 2.0 Data
Hi Steve, Good sample! I'm asking my self if is not a good to have a sample project on FB.Net provide page! Maybe this is a new topic... Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Faleiro Sent: Wednesday, September 17, 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 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 scenario! Regards, Paul I agree that this is the best method. I am posting code from one of my applications to demonstrate how this can be implemented in C#: using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.Common; using FirebirdSql.Data.FirebirdClient; namespace MED { class DataLayer { private string connStr; private FbConnection fbc; public DataLayer() { connStr = Dialect=3; ServerType=1; User=SYSDBA; Password=masterkey; Database=c:\\temp\\MED\\database\\MEDDB.FDB; fbc = new FbConnection(connStr); fbc.Open(); } public DataSet getPatientList(string patLastName) { FbCommand cmd = new FbCommand(MDPTNT01_SEL_L, fbc); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@PLASTNAME, patLastName); DataSet ds = new DataSet(); FbDataAdapter da = new FbDataAdapter(cmd); da.Fill(ds); return ds; } public DataSet getPatientDetails(string patNo) { FbCommand cmd = new FbCommand(MDPTNT01_SEL, fbc); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@PATNO, patNo); DataSet ds = new DataSet(); FbDataAdapter da = new FbDataAdapter(cmd); da.Fill(ds); return ds; } } } To use it, the following code: dataLayer = new DataLayer(); DataSet ds = dataLayer.getPatientDetails(patNo); Regards, Steve Faleiro --- -- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Sample project for Fb.Net Provider
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 coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Sample project for Fb.Net Provider
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 for Fb.Net Provider Hi * I'm asking if is not a good[PM] IDEA 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 coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] FbDataConnectionUIControl
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ulrich Groffy Sent: Wednesday, September 17, 2008 1:55 PM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] FbDataConnectionUIControl Hello, I opened a new thread, because the thread Firebird ado.Net 2.0 Data Provider seems to be a bit mixed up. My question is, if the page http://www.firebirdsql.org/firebirdtutorial/fbconnection-component.html is obsolete, what the control FbDataConnectionUIControl is for, if it is no property editor? I can load it as an independ control, and place it on a form, but what for? I have a similar question for the fbCommand control/component. Is there no command text editor for the SQL statement anymore? As seen on http://www.firebirdsql.org/firebirdtutorial/fbcommand-component.html With best regards - Ulrich Groffy --- -- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Creating a Database using ADO.Net Data Provider For Firebird
Hi I'm using this: #region ConnectionString /// ///Connection String /// FbConnectionStringBuilder cs = new FbConnectionStringBuilder(); cs.UserID = USERDB; cs.Password = userdb; cs.Database = txtDbNew.Text; cs.DataSource = txtHost.Text; cs.Port = Convert.ToInt16(txtPort.Text); cs.Dialect = 3; cs.Charset = NONE; cs.Role = ; cs.ConnectionLifeTime = 0; cs.ConnectionTimeout = 15; cs.Pooling = Convert.ToBoolean(true); cs.PacketSize = 8192; cs.ServerType = 0; cs.ServerType = FbServerType.Default; #endregion #region CreateDatabase /// ///Create database /// fbConnNewDB.ConnectionString = cs.ToString(); if (File.Exists(txtDbNew.Text)) { FbConnection.DropDatabase(cs.ToString()); } try { FbConnection.CreateDatabase(cs.ToString(), Convert.ToInt16(cmbPagesize.SelectedItem.ToString()), true, true); } catch (FbException fbexcr) { MessageBox.Show(fbexcr.ToString()); } #endregion Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Meftah Tayeb Sent: Wednesday, September 17, 2008 3:48 PM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Creating a Database using ADO.Net Data Provider For Firebird hi, i have the 2.1.0.0 version of the Firebird ADO.Net 2.0 Data Provider i want to create a New Database (a run time) in the DotNet-Firebird semples code, the Function CreateDatabase () is called. but i dont have it! i have only CreateCommand any help ? thanks - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] install ddex 2.0.3 in vs2008 Team
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: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] install ddex 2.0.3 in vs2008 Team Hi, i new in .net, please how i can install this version of ddex, step by step please, or exist a installer for use? Thanks sorry, my english is bad --- -- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS2008 DDEX probem
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: [Firebird-net-provider] VS2008 DDEX probem Sorry if this is a repost - everything crashed when I sent it so I'm resending just in case. Hi, I use VS2008 on a WinXPPro machine. I have installed the FirebirdClient-2.5.0-Alpha2. I have followed the instructions in FirebirdDDEXProvider-2.0.3, including installing the FirebirdSql.VisualStudio.DataTools.dll with gacutil.exe. I have changed the machine.config (and double checked it like a million times). I have changed the path in FirebirdDDEXProvider32.reg (from the FirebirdDDEXProvider-2.0.3) and committed it to the registry. Ok, that's the background. Here comes the problem: When I add a new DataSource I can find the Firebird provider in the list of providers. I can add a new Connection and even testing the connection works fine. However, when I click OK I get an error message saying Unable to add data connection. Cannot load type with name 'FirebirdSql.VisualStudio.DataTools.FbDataObjectEnumerator'. Obviously VS cannot find FirebirdSql.VisualStudio.DataTools.dll, but how do I remedy that? Adding it as a project reference doesn't work, not that that really was a surprise. Or can it be something else? Both FirebirdClient and the DDEX files are installed to C:\Program Files\FirebirdClient 2.0. Please help //Christian - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Roadmap
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 To: Firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Roadmap Hi, is there a place I can find the roadmap of the .net provider. I'm starting a new dev and I need to know when 2.5 final will be released to choose if I can work with Alpha version or if it's better to wait. Thierry --- -- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 / Can i detect the pagesize with fbprovider 2.x?
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: [Firebird-net-provider] How / Can i detect the pagesize with fbprovider 2.x? Hello, is there a chance to retrieve the pagesize of a database with fbpovider? I need it to calculate the maximum size of a blob (subtype text). Michael --- -- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Help with SQL
You have to write the correct join ... I don't see it at first time! select i.SiteID, i.InvoiceID, Sum(COALESCE(d.Charge, 0)) AS Itm, Sum(COALESCE(p.Amount, 0)) AS Pmt, (Sum(COALESCE(d.Charge, 0)) + SUM(COALESCE(p.Amount, 0))) AS Total from Invoice i join InvoiceDetail d 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 27, 2008 7:53 AM To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] Help with SQL Try this select i.SiteID, i.InvoiceID, Sum(COALESCE(d.Charge, 0)) AS Itm, Sum(COALESCE(p.Amount, 0)) AS Pmt, (Sum(COALESCE(d.Charge, 0)) + SUM(COALESCE(p.Amount, 0))) AS Total from Invoice i join InvoiceDetail d ON (d.InvoiceID = :InvoiceID) join InvoicePayment p ON (p.InvoiceID = :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 Steve Harp Sent: Wednesday, August 27, 2008 12:06 AM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Help with SQL HI All, I'm trying to get invoice totals to show item totals and payments. I have 3 tables; Invoice, InvoiceDetail, and InvoicePayment. I first tried a join like this. select i.SiteID, i.InvoiceID, NULLIF(Sum(d.Charge), 0) AS Itm, NULLIF(Sum(p.Amount), 0) AS Pmt, (NULLIF(Sum(d.Charge), 0) + NULLIF(Sum(p.Amount), 0)) AS Total from Invoice i join InvoiceDetail d ON (d.InvoiceID = :InvoiceID) join InvoicePayment p ON (p.InvoiceID = :InvoiceID) where (i.InvoiceID = :InvoiceID) group by i.SiteID, i.InvoiceID order by i.SiteID, i.InvoiceID This multiplies each sum of charges by the number of payments and each sum of payments by the number of charges. Secondly, I tried sub-queries like this. select (Select NULLIF(Sum(Charge), 0) from invoicedetail where InvoiceID = :InvoiceID) AS Itm, (Select NULLIF(Sum(Amount), 0) from invoicepayment where InvoiceID = :InvoiceID) AS Pmt, ((Select NULLIF(Sum(Charge), 0) from invoicedetail where InvoiceID = :InvoiceID) + (Select NULLIF(Sum(Amount), 0) from invoicepayment where InvoiceID = :InvoiceID)) AS Tot from Invoice i where (i.InvoiceID = :InvoiceID) This gives me the correct results and works fine in IBExpert but craps out with the .NET provider with the error message: 08d26y2008 16:15:06 - FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error SQL error code = -206 Column unknown INVOICEID No message for error code 336397208 found. --- FirebirdSql.Data.Common.IscException: Exception of type 'FirebirdSql.Data.Common.IscException' was thrown. at FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector() at FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse() at FirebirdSql.Data.Client.Gds.GdsDatabase.ReadResponse() at FirebirdSql.Data.Client.Gds.GdsStatement.Prepare(String commandText) at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) --- End of inner exception stack trace --- at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavio r behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBeh avior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) Any ideas? Steve Harp - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird .net + ZeBeDee + Events
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jiri Cincura Sent: Thursday, August 07, 2008 8:02 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Firebird .net + ZeBeDee + Events 2008/8/7 Ivan Arabadjiev [EMAIL PROTECTED]: Is there any way currently in the provider to get the server event port Right now no. (or could it be implemented in the future)? I suppose I could add it by myself, but doing that on every new version is a not really a You can do the patch, send it to me and I'll review it. If it will not bring up any problems, I'll commit it to sources, so it'll be in every future version(s). -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com --- -- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] New in Firebird
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@lists.sourceforge.net Subject: [Firebird-net-provider] New in Firebird Hi People I have the next store procedure in MS Sqlserver 2005 Create Procedure DoSomething as select * from table1 select * from table2 select * from table3 In Visual Studio 2005 I can create a DataAdapter to call the store procedure, so after calling the Fill method of DataAdapter I get a Dataset with 3 tables, that they correspon to select commands of store procedure. I can do the same in FireBird?? Thanks in advance --- -- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ 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 the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Error on building manually FB Provider
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 in the namespace 'System' (are you missing an assembly reference?) Should be an #if (NET_35 ENTITY_FRAMEWORK) for this? #if (NET_35 ENTITY_FRAMEWORK) using System.Linq; #endif Best regards, Paul - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Firebird web provider
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 first(1) PropertyNames, PropertyValuesString, PropertyValuesBinary from profiles where pkid = :userid into :propertynames,:propertyvaluesstring,:propertyvaluesbinary; shouldn't have an order by?or should not be into a FOR statement?like for select PropertyNames, PropertyValuesString, PropertyValuesBinary... 3. In PROFILES_DELETEPROFILE is this: if (userid is null) then userid = :username; delete from profiles where pkid = :userid; Why is set the userid to user name??? 4.If I configure my membership to allow multiple account with same e-mail, I could find all users by e-mail with MEMBERSHIP_FINDUSERSBYEMAIL but what user name I'll get from MEMBERSHIP_GETUSERBYEMAIL ?The first one from table? 5. Shouldn't be used FK for PKID from USERS table? Best regards, Paul - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] web application sample
Hi all I have solved this problem! In web.config my settings was wrong!Correct values are: roleManager enabled=true defaultProvider=AlmWebrp providers add name=AlmWebrp type=FirebirdSql.Web.Providers.FbRoleProvider, FirebirdSql.Web.Providers, Version=2.1.0.0, Culture=neutral, PublicKeyToken=3d06a02581b682f8 connectionStringName=AlmexaWebcs/ /providers /roleManager authentication mode=Forms /authentication membership defaultProvider=AlmWebms userIsOnlineTimeWindow=20 providers add name=AlmWebms type=FirebirdSql.Web.Providers.FbMembershipProvider, FirebirdSql.Web.Providers, Version=2.1.0.0, Culture=neutral, PublicKeyToken=3d06a02581b682f8 connectionStringName=AlmexaWebcs enablePasswordRetrieval=false enablePasswordReset=true requiresQuestionAndAnswer=false applicationName=/ requiresUniqueEmail=false passwordFormat=Hashed maxInvalidPasswordAttempts=5 minRequiredPasswordLength=5 minRequiredNonalphanumericCharacters=0 passwordAttemptWindow=10 passwordStrengthRegularExpression= / /providers /membership Best regards, 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 with my web.config...pointing to sqlserver somehow... I'll generate new one, tomorrow ! If I can't make this work I'll be back with questions... Thank you all! Best Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 how can I use CreateUserWizard and all other components from Login Tab from Tools in VS 2005/2008! Sorry I don't. I have only one ASP.NET project using membership etc. stuff ant this is using the old one version of WebProviders (before rewritten by Le Roy Arnaud). :( I have configured Membership provider and role provider but I get always errors on execution! Look at Event Log, errors from WebProviders are written there. i use it in a lot of projects , what are yours errors ? -- Le Roy Arnaud Menlog informatique (www.menlog.com) - -- -- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider --- -- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Firebird web provider - session table
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 or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird web provider - session table
Hi Jiri All fields will get a domain, but with PK will be a little problem (is used in several SP)...for that I'll try to get a solution later! I'll send e-mail with the script file! Best regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf 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 provide a script for this? Yes, of course. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com --- -- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird web provider - session table
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/ | http://www.ID3renamer.com --- -- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] web application sample
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 - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] web application sample
Hi Arnaud Something is wrong with my web.config...pointing to sqlserver somehow... I'll generate new one, tomorrow ! If I can't make this work I'll be back with questions... Thank you all! Best Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 how can I use CreateUserWizard and all other components from Login Tab from Tools in VS 2005/2008! Sorry I don't. I have only one ASP.NET project using membership etc. stuff ant this is using the old one version of WebProviders (before rewritten by Le Roy Arnaud). :( I have configured Membership provider and role provider but I get always errors on execution! Look at Event Log, errors from WebProviders are written there. i use it in a lot of projects , what are yours errors ? -- Le Roy Arnaud Menlog informatique (www.menlog.com) --- -- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Web provider - sql file
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 usersinrole .OR Correct FbWebProviders2.0.sql file and put in first position the IN FbRoleProvider2.0.sql line, THIS IS BETTER CHOISE! Can be changed CREATE PROCEDURE with CREATE or ALTER PROCEDURE ??? Best Regards, Paul - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] execute store_procedure from application
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: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] execute store_procedure from application hi all, i have problem with execute store_procedure from my application: error message: invalid request BLR 199 at offset function STRLEN is not defined but if i call that procedure in EMS Interbase/Firebird Manager than there is no error. please help me. tahan tobing the code programm: = dacomm.CommandType = CommandType.StoredProcedure dacomm.CommandText = select * from PROC_NEIGH(' + cell + ') dacomm.Connection = myConnection dacomm.ExecuteNonQuery() = CREATE PROCEDURE PROC_NEIGH ( FI_CELL_ID VARCHAR (10) CHARACTER SET NONE) RETURNS ( I_SUM INTEGER) AS declare variable v_ncell varchar(255); declare variable v_ncell_length integer; declare variable v_jumlahdata integer; declare variable i integer; declare variable v_cell_id varchar(10); declare variable temp varchar(80); BEGIN update m_site_i set ncell_col=0; select ncell from m_neighbor where CELL=:FI_CELL_ID into :v_ncell; v_ncell_length = strlen(trim(v_ncell)); --trim utk hilangkan spasi v_jumlahdata=(v_ncell_length+1) / 8; i=1; while (i=v_jumlahdata) do begin v_cell_id=substrlen(v_ncell,((i-1)*8)+1,8); v_cell_id=trim(v_cell_id); I_SUM=i; update m_site_i set ncell_col=1 where cell = :v_cell_id; suspend; i=i+1; end END === - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] all news are duplicated
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 list = admin can delete one subscription , if I have 2 with same e-mail??? I have unsubscribed and subscribed to ensure I=92m just once = registered=85but always I get a duplicate for each message on this news = group! Regards, Paul - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ 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: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ 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: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] crystal report problem
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 = @C:\SampleDatabase\SAMPLE.FDB; conninfo.UserID = sysdba; conninfo.Password = masterkey; tabloginfo.ConnectionInfo = conninfo; foreach (Table tab in reportDoc.Database.Tables) { tab.ApplyLogOnInfo(tabloginfo); } Best regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kixzo Database Team Sent: 03 June 2008 13:48 To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] crystal report problem Hello All, Yesterday I posted one problem for using Crystal Report with Firebird database, today I tried a little bit and was able to solve that problem. I was able to display the data on the Report. I had to create one more report based on grouping, so it did the same for grouping the data on the report, I was able to do that in design, but when I started running the application I got the following message that I was getting previously. I have taken the picture of that let me show you. Let me show you the Field Explorer Value, for that also I have taken the picture. And following is my Report Design. If I am able to connect at design time and able to get all the fields from the table. Then what is the problem with code that I am getting the Table not found Error. I am using the following Code. FbConnection connect = new FbConnection(@Database=C:\SampleDatabase\SAMPLE.FDB;USER=sysdba;password=ma sterkey;); connect.Open() ; FbDataAdapter adapter = new FbDataAdapter(SELECT EMPLOYEE.EMPNAME,ADDRESS.CITY,ADDRESS.STATE,ADDRESS.ZIPCODE FROM ADDRESS,EMPLOYEE WHERE EMPLOYEE.EMPLOYEE_ID= ADDRESS.EMPLOYEE_ID, connect); DataSet ds = new DataSet(); adapter.Fill(ds); string reportname = CrystalReport1; string ReportPath = reportname +.rpt; if(!File.Exists(ReportPath)) { MessageBox.Show(Can not locate the report file); } ReportDocument reportDoc = new ReportDocument(); reportDoc.Load(ReportPath); reportDoc.SetDataSource(ds.Tables[0]); conninfo.ServerName = pc205; conninfo.DatabaseName = @C:\SampleDatabase\SAMPLE.FDB; conninfo.UserID = sysdba; conninfo.Password = masterkey; tabloginfo.ConnectionInfo = conninfo; foreach (Table tab in reportDoc.Database.Tables) { tab.ApplyLogOnInfo(tabloginfo); } RptViewer1.ReportSource = reportDoc; connect.Close(); the same Code I used for getting data from single Table, only the query was different. Please, help me in this, I am really frustared on this. Regards, Rakesh Singh, http://www.4colordesign.com - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] crystal report problem
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 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, I am using VS .NET 2005 and crystal Report for generating reports. I am facing some problem in displaying data on the report. Using Firebird provider I am able to establish connection to the firebird server and also to get the table list. Using the Field Explorer have placed the fields on the report at design time. But when I am running the application and it is asking for connection to the database when I provide a proper user name and Password for the firebird database after that I am getting following error message that Table Cost could not be found.(Cost is my table from which I am fetching the data). Can any one help me is sorting out this. Regards, Rakesh Singh. http://www.4colordesign.com - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] all news are duplicated
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 - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] crystal report problem
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, I am using VS .NET 2005 and crystal Report for generating reports. I am facing some problem in displaying data on the report. Using Firebird provider I am able to establish connection to the firebird server and also to get the table list. Using the Field Explorer have placed the fields on the report at design time. But when I am running the application and it is asking for connection to the database when I provide a proper user name and Password for the firebird database after that I am getting following error message that Table Cost could not be found.(Cost is my table from which I am fetching the data). Can any one help me is sorting out this. Regards, Rakesh Singh. http://www.4colordesign.com - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Service API and nbackup
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 still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Service API and nbackup
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 to batch file...or process ! Regards, Paul - This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Service API and nbackup
Thanks Helen and Roman! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Helen Borrie Sent: 21 April 2008 02:32 To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] Service API and nbackup At 03:07 AM 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 more! There isn't an API. nBak and nBackup are plug-in applications and as such they are clients that *use* the API, much as any other application does. The Services API isn't a nice, clean, extensible interface like the engine API, unfortunately. It is a cocktail of functions passing parameters to a mishmash of embedded code, macros and who-knows-what. I mean, literally, the code for gbak, gfix, gsec and so on is duplicated in the engine! Bloating the engine with more optional code is not part of the Firebird design strategy - so forget about an API for nbackup or other plug-ins ever being available through the Services API as currently implemented! The good news is that a new API encompassing both pluggable and internal code is on the drawing board, if not for Fb 3.0 then for a v.3.x. This is going to open the doors for a correct and future-safe way to do things: not just incremental backup but pluggable security, replication, search engines, external procedures and whatever anyone wants to dream about right now... Helen --- -- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/ javaone ___ 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 the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Error message attempted update of read-only column
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 were achieving when you believed you were able to modify a record during deletion... Well, the logic was this: just before deleting a record I look o.repl and I set doc_repl value to replicate or not the deletion to master database !It looks like is a wrong logic, need to be modified! Thanks for that! Also, would you fix your email client/spam filtering so it doesn't mess around with the message Subject, please? If you don't know how, at least edit the Subject before you send. I have fixed, the smpt mail have a 'stuid' spam filter! Thanks again! Paul - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] suspect - [SPAM] Re: Error message attempted update of read-only column
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 - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] suspect - [SPAM] Re: Error message attempted update of read-only column
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 Before Delete it works! It's strange because I have 1 trigger for each operation with the same definition (inserting into a log table some values and operation type as U for update, I for insert,etc),the difference is the type of operation! As to the rest, you have a confusion of cursors there, as well as a confusion of table/set qualifiers. Study the Firebird 2/2.1 release notes to understand why some of your statements might now be illegal. However, the exception you are seeing is not one of those that you would see as a result of the errors in your stored procedure. I think you will discover its cause in a trigger. This trigger definition is over my all tables, more than 200 (to log operations maded on each table, if is activated),and works ok for 2 years now!I will debug the SP to see what's happening ! If I run SP from IBExpert works as expected with both FB SS versions. Are you actually executing it, or just running it in the IBExpert debugger? If the latter, it is likely that you need to upgrade your IBExpert to a version that supports Firebird 2 and higher. Firebird 1.5 and below were more tolerant to poorly-qualified SQL statements which means that older debugging tools are no longer valid. I'm using IBExpert personal edition, this version does'n have any debugger! I have modified my SP to return values and works ok from IBExpert and isql ! Best regards, Paul - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] suspect - [SPAM] Re: suspect - [SPAM] Re: Error message attempted update of read-only column
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 o.repl from sys_repl o where o.name='doc_invoiceţ into :v_repl; if (v_repl is null) then v_repl='N'; /* if (v_repl='I') then old.doc_repl='I'; */ execute procedure insert_log('doc_invoice',old.doc_repl,'D'); end If I uncomment the if (repl='I') then old.doc_repl=0; I get the error! Best Regards, Paul - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Error message attempted update of read-only column
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 {System.Data.Common.DbException} = {attempted update of read-only column} ErrorCode = 335544359 If I run SP from IBExpert works as expected with both FB SS versions. SP content looks like : For select a,b,c from table1 t1 Into :v_a,:v_b, :v_c do begin If (exists(select 1 from table2 t2 where t2.id= :v_a and t2.v=:v_b)) then Begin Delete from table2 t2 where t2.id=:v_a and t2.v=:v_b; End Insert into table2 (t2a,t2b,t2c) Values (:v_a, ,:v_b, :v_c); If I delete IF condition and DELETE statement it works without errors. Regards, Paul - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider