Re: [Firebird-net-provider] Connecting to encrypted databases
Hi, At July 12, 2017, 5:44 AM, Jiří Činčura wrote: >> I think it makes more sense on the connection string. It already contains >> sensitive info (username,password) and needing to provide connection >> related info by another method would be counter intuitive. > Good point. > In my thinking I saw two problems, slightly different from what password > does. The key can be binary data and that's difficult to pass in string. > And the key might be stored on some HSM. > Not that it would rule out connection string completely, it just makes > fit less, IMO. Binary data should be able to be represented with hexadecimal. And, don't forget that whatever is chosen has to be easily implemented when using Entity Framework. We are looking at implementing our own encryption plugin, but still undecided how the key will be passed, since our application uses a mix of Delphi(IBDAC) and C#(EF6). Our initial thought is that it will have to be on the server with the database, since we can't find proper documentation on how to pass it from the client, even with the database management tools, although it is part of Firebird's architecture. It seems to be one area that third-party tools and components haven't taken much time implementing, maybe because that there is no disk encryption plugin provided out-of-the-box with Firebird, and not enough user interest. Having said that, keep up the excellent work Jiri. And, I'm hoping that I will have the time in the next few weeks to create a VSIX installer for DDEX, because the registry entries are not staying and I have to add them everytime that I need to add EF6 classes to represent tables. Once created, it will surely be contributed to the project. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ 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 creating the code with EF6 Code First from Database
Hi, At April 24, 2017, 12:39 PM, Jiří Činčura wrote: >> But, what could cause it not to recognize those fields properly? >> Because when I look in the database's system tables, the >> RDB$FIELD_TYPE and RDB$FIELD_LENGTH both have values in them, one >> would be VARCHAR(132) and the others would be CHAR(1). > Don't know. If you can confirm it's really those fields, put it to > tracker and I'll look at it. Sorry for the late reply, I'm under a time crunch to complete a project. Once I have the time(hopefully within a month), I'll try to reproduce it with a database that contains one table with those kind of computed fields. There was another table that had one computed field, and that one was simpler in construct, and the Code First from Database wizard didn't have any problems with that table. So, it must be something with that one table in particular and the complexities of its computed fields. As soon, as I have a reproducible test case, I'll enter an issue in the tracker. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ 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 handling - as string parameter
Hi, At May 2, 2017, 7:55 AM, Jiří Činčura wrote: >> Can you please add 1 line to describe the difference between using {0} >> vs. @p0 ? > Well, AFAIK only the @p0 is supported. Maybe the {0} works as well, but > I know only about the @p0 from documentation. Of course we can check EF6 > sources, but I'm too lazy to do that. :D Actually, it's not. I'm using the Firebird's default parameter syntax, the question mark. And, I use "new object[] {paramValue1, paramValue2, etc..}" to pass the parameters, and paramValueX are just simple variables or object properties, don't have to be FbParameter. I don't remember trying @p0, although I did try with actual names(i.e.: @PDate), since it was also documented in the MSDN documentation, but I was getting an invalid field error coming from Firebird. But, as you mentioned, one might have to look at the EF6 sources to find out the real behavior. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ 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 creating the code with EF6 Code First from Database
Hi, At April 22, 2017, 10:09 AM, Jiří Činčura wrote: >> I was starting to suspect that, since the other tables that I was able >> to generate the code for didn't have computed fields. Are there any >> hints that I can use? >> >> I can try to look at the code to see if I can fix the problem. And, >> since I never did look inside the ADO.Net driver code. Can you guide >> me to what would be the area of code that I would need to look at? >> >> I'm willing to try to fix the problem, since this is not the only >> table in that database that has computed fields. > You can create a table without computed field, generate the CF for it. > And then do the same for a table with computed field. But, what could cause it not to recognize those fields properly? Because when I look in the database's system tables, the RDB$FIELD_TYPE and RDB$FIELD_LENGTH both have values in them, one would be VARCHAR(132) and the others would be CHAR(1). -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ 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 creating the code with EF6 Code First from Database
Hi, At April 22, 2017, 4:47 AM, Jiří Činčura wrote: > My *guess* is that it's the computed columns and the length is not > discovered properly. I was starting to suspect that, since the other tables that I was able to generate the code for didn't have computed fields. Are there any hints that I can use? I can try to look at the code to see if I can fix the problem. And, since I never did look inside the ADO.Net driver code. Can you guide me to what would be the area of code that I would need to look at? I'm willing to try to fix the problem, since this is not the only table in that database that has computed fields. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Problem creating the code with EF6 Code First from Database
FILOPTOHCFACLAIMNO); CREATE INDEX IDX_CLAIMSDETAIL1 ON CLAIMSDETAIL(INVOICEDETAILITEMNO); CREATE INDEX I_CLAIMSDETAIL_DATESTART ON CLAIMSDETAIL(DATESTART); Any help would be appreciated. Also, this table is used as is within our Delphi code for at least 5 years, and we do not want to change that code. -- Best regards, Daniel Rail Senior System Engineer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ 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 setup in VS 2015
Hi, At March 8, 2017, 3:09 PM, Jiří Činčura wrote: >> Also, what is the timeline to support VS 2017? I tried by simply >> changing the registry keys from 14_Config to 15_Config, but that >> simply created a 15_Config registry key that only contained the >> registry keys for Firebird, and nothing else. It looks like that they >> have changed how the integration works. > Great. Something I don't want to hear. :) Hopefully it's just the > registry keys, not the whole DDEX story. Although I wouldn't mind fresh > API for that, preferably fully managed. > >> I can add the VS2017 support request to the tracker, just let me know >> under which component(s) that would be appropriate. > It' already there under DNET-739. I added a comment to DNET-739 with a link to the breaking changes in VS 2017 with regards to the integration and the registry keys. It looks like that the best approach would be to use the VSIX package installer, possibly using the External Settings Manager. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Announcing the Oxford Dictionaries API! The API offers world-renowned dictionary content that is easy and intuitive to access. Sign up for an account today to start using our lexical data to power your apps and projects. Get started today and enter our developer competition. http://sdm.link/oxford ___ 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 setup in VS 2015
Hi, At March 8, 2017, 2:16 AM, Jiří Činčura wrote: > Check whether the registry entries are there (for VS2015). That was the problem. I did double-click on the .reg file and Windows told me that the entries were added, but they were not. I just used the Import function inside RegEdit, and that worked. Also, what is the timeline to support VS 2017? I tried by simply changing the registry keys from 14_Config to 15_Config, but that simply created a 15_Config registry key that only contained the registry keys for Firebird, and nothing else. It looks like that they have changed how the integration works. I can add the VS2017 support request to the tracker, just let me know under which component(s) that would be appropriate. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Announcing the Oxford Dictionaries API! The API offers world-renowned dictionary content that is easy and intuitive to access. Sign up for an account today to start using our lexical data to power your apps and projects. Get started today and enter our developer competition. http://sdm.link/oxford ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Problem with setup in VS 2015
Hi all, I was able to connect in VS2015 and create some classes to represent a few tables(from an existing database) by using the "ADO.Net Entity Model" template, by using the "Code First from Database". But, something happened(and I don't know what) that now I can't get the Firebird ADO.Net driver to show up in the connection dialog for the "ADO.Net Entity Model" template or even to add connections in the VS2015 Server Explorer. I reinstalled the Firebird DDEX(3.0.2), and even ran the .reg files manually, and the Firebird ADO.Net(5.8.0.0) driver but no success. I even checked machine.config and all the entries are there. In the project, the Firebird drivers are added via NuGet. Also, this is on the latest version of Windows 10 and VS2015 is up to date. Is there anything else that I need to look at? If more information is needed, let me know. -- Best regards, Daniel Rail Senior System Engineer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Announcing the Oxford Dictionaries API! The API offers world-renowned dictionary content that is easy and intuitive to access. Sign up for an account today to start using our lexical data to power your apps and projects. Get started today and enter our developer competition. http://sdm.link/oxford ___ 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 6
Hi, At February 10, 2017, 8:12 AM, Jiří Činčura wrote: >> it(when compiled). And, since the application that is calling this >> .dll is not a .Net application(it's a native Win32 Delphi >> application), I am trying to find out how to setup the entity > Again. You're not saying how are you loading it. You can load DLL and > execute some code from it even with config file. Depends how you're > loading the CLR (and if, also). Just to add to the context. I'm using RemObjects Hydra as the plugin architecture, for our application, and it's Hydra that loads the .Net assembly DLL. The DLL is ComVisible. But other than looking in Hydra's code, I can't say how the DLL is loaded. Again thanks for the information. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot ___ 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 6
Hi, At February 10, 2017, 8:13 AM, Jiří Činčura wrote: > Also, if you'd read my blog, you'd have been done already: > https://blog.cincura.net/233368-configuring-3rd-party-entity-framework-provider-firebird-from-code/ > ;) Thanks, that's what I was looking for. I do remember coming across it, but when I did, that wasn't the information that I was looking for at the time. At first, I was just trying to figure out why I didn't have the ADO.Net Entity Data Model template in Visual Studio, just to find out, after searching for almost a day, that I needed to install either the Web Developer Tools or SQL Server Data Tools, when installing VS2015. Anyway, thanks for the information and your hard work on the ADO.Net provider. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot ___ 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 6
Title: Re: [Firebird-net-provider] Entity Framework 6 Hi, At February 9, 2017, 6:52 PM, Paul Dryden wrote: I have have had problems using Windows Entity Data Framework. In some cases, I can't open an edmx file in Visual Studio (that I had compiled from scanning a database perhaps a year earlier, always receiving "Provider Not Found." Very frustrating. Actually, with Code First in EF6, I'm not dealing with an edmx file at all. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ 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 6
Hi, At February 10, 2017, 3:28 AM, Jiří Činčura wrote: > Well, you're not saying anything specific about the exception (at least > which provider - EF or ADO.NET?) nor how's the assembly loaded (because > you can as well use the config file, depending on how it's loaded). > Let's guess that it's a ADO.NET provider, then you're probably missing > the DbProviderFactory piece > (https://github.com/cincuranet/EF6_Firebird/blob/master/CodeFirst/App.config#L12). > With that, I would go the easiest way and pass directly FbConnection to > DbContext's ctor. Sorry, for not being clearer. Here's the exact error message, that I receive when running from Visual Studio: [Error Message Quote] An exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll but was not handled in user code Additional information: No Entity Framework provider found for the ADO.NET provider with invariant name 'FirebirdSql.Data.FirebirdClient'. Make sure the provider is registered in the 'entityFramework' section of the application config file. See http://go.microsoft.com/fwlink/?LinkId=260882 for more information. [/Error Message Quote] Here's the code that I use: using (var db = new FiloptoDataLibrary.FiloptoQuickBooksModel(new FbConnection(vFBConnectionString.ToString()), true)) { ... } The FiloptoQuickBooksModel is inherited from DbContext, and was created by the Entity Framework Tools Code First from Database wizard. The vFBConnectionString is a FbConnectionStringBuilder. And, in the project's App.Config, all the entries are there. But, the project compiles to a .dll and doesn't have a .config file with it(when compiled). And, since the application that is calling this .dll is not a .Net application(it's a native Win32 Delphi application), I am trying to find out how to setup the entity framework provider for usage in the .dll. And, since it is possible to register the entity framework provider in code, in EF6, I'm wondering what would be the required code, when trying to follow the example from Microsoft, provided in the link of my previous message. I am using Visual Studio 2015, EF 6.1.3 and targetting .Net 4.6.2. I did thought of using the EntityConnectionStringBuilder, but it is looking for the metadata files(.csdl, .ssdl, .msl), which don't exist in my case. Unless, there is a way to tell it to ignore the metadata files, when using the EntityConnectionString, because at least here I would be able to specify the provider. If more information is needed, just let me know. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Entity Framework 6
Hi, I'm trying to use the Firebird ADO.Net with Entity Framework 6. I'm able to create a code first model from an existing database. But, when trying to establish a connection, it is telling me that a provider is not registered. My scenario is that the connection is done in a DLL, not an EXE, and the main application's EXE that is calling this .Net assembly DLL is a Win32/Delphi application. I know that normally the provider information would be in the application's config file, but in this case the config file is not copied with the assembly DLL. I was reading on how to register the provider in code ( https://msdn.microsoft.com/en-us/library/jj680699(v=vs.113).aspx ), but I'm unsure what to put for the SetExecutionStrategy line in the example. Any help would be appreciated. -- Best regards, Daniel Rail Senior System Engineer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot ___ 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-devel] Stored procedures etc. in .NET
Hi, At June 27, 2016, 3:51 PM, Jiří Činčura wrote: > Hi *, > there's something I've been working on for a few evenings and weekends. > As you might know, from Firebird 3 there's and interface to write a > plugin that allows to execute any code as stored procedure, function or > trigger. > So why not to have these in .NET, right? I have a working plugin right > now. Currently only stored procedures are supported. No blobs at the > moment as well. > You can check small example at the end of this email. > Now the important part. Is there enough interest in this to keep working > it? The hardest part is mostly over. Now it's just adding support for > more objects and polishing it, hardening it and probably adding features > based on requests (like security). I can see myself and our company developing stored procedures, functions and triggers in .Net. There were times were it will likely be easier. And, stored procedures is a good starting point, since it can be called from a trigger. Also, this will make it easier to reuse business logic that is developed in .Net(without having to rewrite it in PSQL), if it is to implement such logic in a stored procedure or trigger. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Attend Shape: An AT Tech Expo July 15-16. Meet us at AT Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Solution With ADO.NET provider 4.10.0.0 Fails Compile
Title: Re: [Firebird-net-provider] Solution With ADO.NET provider 4.10.0.0 Fails Compile Hi, At January 18, 2016, 9:15 AM, LtColRDSChauhan wrote: Hi, 1. On using ADO.NET provider 4.10.0.0 solution fails to compile. The following error is reported: The type or namespace name 'ServiceOutputEventHandler' could not be found (are you missing a using directive or an assembly reference?) (CS0246) The type or namespace name 'FbRemoteEventEventHandler' could not be found (are you missing a using directive or an assembly reference?) (CS0246) 2. Reverting to version 4.8.1.1, compile for the same solution succeeds. Regards, Rajiv Reading the release notes for 4.9, there have been a change for the event handlers, to simply use the generic EventHandler. http://tracker.firebirdsql.org/browse/DNET-640 -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___ 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
Hi, At October 1, 2015, 2:21 PM, Jiří Činčura wrote: > On Thu, Oct 1, 2015, at 19:00, Геннадий Забула wrote: >> In ModelBuilder you can specify any object as data annotation. In this >> case user can provide implementation of the interface. > But then we're back where we started. Question is whether the global > definition for whole migration generator or per column is more > understandable and discoverable for developers. My preference would be at the column level. Since that would be more discoverable for me, because it is close to where it is used. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.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] WPF/FB Client interaction issue
Hi, At September 2, 2015, 5:34 PM, Kevin Donn wrote: > I've stumbled on either the depth of my own ignorance or a fairly > serious problem when using the Firebird .NET Client in a WPF app. It > seems there's something wrong with the columns that get built during > FbDataAdapter.Fill(DataTable). The columns do not seem to support data > binding properly. Specifically, UI elements don't get updated when > values in the column change. The example code I've provided > demonstrates that columns created prior to Fill and columns created > after Fill both work as expected, but columns created during Fill do > not. The example also shows that if you fill the DataTable from a SQL > Server source with everything else kept the same, columns created > during Fill work as expected. > To run the project you'll need to provide some connection string info > and modify the query to return a few rows of string data with a field > named LastName. You may also need to drop in a reference to the > Firebird Client assembly which I removed so as not to send any > binaries. > When the interface comes up, alter any value in the third column and > tab away. The expectation is that the value in the fourth column will > reflect the change, but for me it doesn't. I'm running against a 2.1.4 > server. If you alter the value in either the first or second column > and tab away, the other column is updated. Someone asked a similar question on StackOverflow, and the answer might be of some help to you: http://stackoverflow.com/questions/15484296/wpf-bind-control-to-dataview We use ADO.Net Entity Framework for the binding in WPF. It works very well, and very well suited for WPF data binding. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Monitor Your Dynamic Infrastructure at Any Scale With Datadog! Get real-time metrics from all of your servers, apps and tools in one place. SourceForge users - Click here to start your Free Trial of Datadog now! http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Single transaction per connection?
Hi, At June-08-12, 8:58 AM, Kjell Rilbe wrote: Den 2012-06-08 13:52 skrev Michael Ludwig såhär: Kjell Rilbe schrieb am 08.06.2012 um 12:59 (+0200): it seems my existing transaction is ended by a framework that's using the same connection). What framework? ECO, www.capableobjects.com. Why? Kjell In those cases I use one connection for ECO and another connection for anything outside of ECO. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Getting an assembly to accept more than one provider version?
Hi, Maybe this is more a .Net question than a FB provider question, but I think it may be of interest to most people using the provider. My problem is that I have an assembly that in the sources specifies SpecificVersion = false for the Fb provider assembly, i.e. it should accept any version of the provider. But the built assembly (the dll) becomes bound to the provider version present when it is compiled, in my case 2.5.0.0. Now, I'd like to upgrade to the latest provider version (2.5.2.0). Is there any way I can get the other assembly to accept the newer provider assembly without having to rebuild it from sources? If you reply with RTFM I'd appreciate pointers to relevant docs. Add this to your application's config file, under the configuration section: runtime assemblyBinding xmlns=urn:schemas-microsoft-com:asm.v1 dependentAssembly assemblyIdentity name=FirebirdSql.Data.FirebirdClient publicKeyToken=3750abcc3150b00c / bindingRedirect oldVersion=1.0.0.0-2.5.1.0 newVersion=2.5.2.0 / /dependentAssembly /runtime I also added the same thing to Visual Studio's devenv.exe.config file, because of ECO. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Urgent: Create Connection in VS2010
Hi, At February-21-11, 5:58 PM, Sebastian wrote: Hi Daniel, Could you try: FbConnection conn = new FbConnection(data source=127.0.0.1;User id=SYSDBA;Password=masterkey;Initial Catalog=C:\Users\smartBugs\Documents\PCTRADE.gdb); I usually write this way: FbConnection conn = new FbConnection(); conn.ConnectionString = data source=127.0.0.1;User id=SYSDBA;Password=masterkey;Initial Catalog=C:\Users\smartBugs\Documents\PCTRADE.gdb; I tried both, but no change. The exception still comes up. With which version of Firebird(or maybe Interbase) did this database was created with? Also, is it possible that you have a copy of Interbase running? And, which version of Firebird that is installed? -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Index, Search Analyze Logs and other IT data in Real-Time with Splunk Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. Free Software Download: http://p.sf.net/sfu/splunk-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] Urgent: Create Connection in VS2010
Hi, At February-21-11, 5:13 PM, Sebastian wrote: Hi, I installed the Firebird .NET provider 2.6 and the VS 2010 integration. Now I want to create a new connection in the IDE, and so I select the firebird provider als the correct provider and set the options for the connection (database name, etc). When I click on 'Test connection' I always get a 'IndexOutOfRangeException' from the provider. The stack trace points to the GetServerVersion() call. In fact, it looks very like this issue here: http://tracker.firebirdsql.org/browse/DNET-330 But that issue says it's fixed in 2.6 (which I use). I also installed the DDEX integration. I have the latest Firebird server and the 2.6 ADO.NET provider installed. Firebird itself runs fine (I can connect to the database using IBExpert). This small sample code here totally fails though: try { FbConnection conn = new FbConnection(@Server=127.0.0.1;User=SYSDBA;Password=masterkey;Database=C:\Users\smartBugs\Documents\PCTRADE.gdb); conn.Open(); } catch (Exception ex) { this.Text = ex.Message; } Please help me, this is somewhat urgent. Thanks, Sebastian Could you try: FbConnection conn = new FbConnection(data source=127.0.0.1;User id=SYSDBA;Password=masterkey;Initial Catalog=C:\Users\smartBugs\Documents\PCTRADE.gdb); I usually write this way: FbConnection conn = new FbConnection(); conn.ConnectionString = data source=127.0.0.1;User id=SYSDBA;Password=masterkey;Initial Catalog=C:\Users\smartBugs\Documents\PCTRADE.gdb; -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Index, Search Analyze Logs and other IT data in Real-Time with Splunk Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. Free Software Download: http://p.sf.net/sfu/splunk-dev2dev ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Problem with trying to connect to a database
Hi, I'm having a problem when trying to connect to a database, but I doubt that the problem is with the Firebird Server. The environment is Windows 2008 R2 standard server with .Net 4, Firebird 2.5RC3 and Firebird ADO.Net 2.5.2. The error that is returned is: Exception Source: FirebirdSql.Data.FirebirdClient Exception Type:System.IndexOutOfRangeException Exception Message: Index was outside the bounds of the array. Exception Target Site: Object reference not set to an instance of an object. The call stack: at FirebirdSql.Data.Common.IscHelper.VaxInteger(Byte[] buffer, Int32 index, Int32 length) at FirebirdSql.Data.Common.IscHelper.ParseDatabaseInfo(Byte[] buffer) at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.GetServerVersion() at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.Attach(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database) at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create() at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut() at FirebirdSql.Data.FirebirdClient.FbConnection.Open() at DoctorDeals.DoctorDealsPMP.HasTrigger(String vTriggerName) at DoctorDeals.DoctorDealsPMP..ctor() The line of code that in the function HasTrigger, I do the following check: if (fbConnCommands.State != ConnectionState.Open) { fbConnCommands.Open(); } And, I was able to confirm that the error is triggered by the fbConnCommands.Open(). And, it is the first time that a connection is attempted. This is the error that is generated on a customer's computer. I don't get this error on my computer. Any ideas to help me debug this would be appreciated. -- Best regards, Daniel Rail Senior System Engineer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-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] Problem with trying to connect to a database
Hi, At August-12-10, 9:47 AM, Jiri Cincura wrote: On Thu, Aug 12, 2010 at 14:25, Daniel Rail dan...@accra.ca wrote: Any ideas to help me debug this would be appreciated. http://tracker.firebirdsql.org/browse/DNET-330 Thanks. I've downloaded the latest weekly build and the fbConnection.Connect now works. But, I'm now getting an error when starting a transaction. The exception message is: Object reference not set to an instance of an object. Here's the call stack: at FirebirdSql.Data.FirebirdClient.FbTransaction.BuildTpb(FbTransactionOptions options) at FirebirdSql.Data.FirebirdClient.FbTransaction.BuildTpb() at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction() at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.BeginTransaction(IsolationLevel level, String transactionName) at FirebirdSql.Data.FirebirdClient.FbConnection.BeginTransaction(IsolationLevel level, String transactionName) at FirebirdSql.Data.FirebirdClient.FbConnection.BeginTransaction() at DoctorDeals.DoctorDealsPMP.HasTrigger(String vTriggerName) in C:\Users\Daniel Rail\Documents\Visual Studio 10\Projects\DoctorDeals\DoctorDeals.PServerWindowsService\DoctorDealsPMP.cs:line 532 at DoctorDeals.DoctorDealsPMP..ctor() in C:\Users\Daniel Rail\Documents\Visual Studio 10\Projects\DoctorDeals\DoctorDeals.PServerWindowsService\DoctorDealsPMP.cs:line 38 And, the line in HasTriggers is: FbTransaction vTrans1 = fbConnCommands.BeginTransaction(); -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-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] Problem with trying to connect to a database
Hi, At August-12-10, 11:07 AM, Daniel Rail wrote: Thanks. I've downloaded the latest weekly build and the fbConnection.Connect now works. But, I'm now getting an error when starting a transaction. The exception message is: Object reference not set to an instance of an object. Here's the call stack: at FirebirdSql.Data.FirebirdClient.FbTransaction.BuildTpb(FbTransactionOptions options) at FirebirdSql.Data.FirebirdClient.FbTransaction.BuildTpb() at FirebirdSql.Data.FirebirdClient.FbTransaction.BeginTransaction() at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.BeginTransaction(IsolationLevel level, String transactionName) at FirebirdSql.Data.FirebirdClient.FbConnection.BeginTransaction(IsolationLevel level, String transactionName) at FirebirdSql.Data.FirebirdClient.FbConnection.BeginTransaction() at DoctorDeals.DoctorDealsPMP.HasTrigger(String vTriggerName) in C:\Users\Daniel Rail\Documents\Visual Studio 10\Projects\DoctorDeals\DoctorDeals.PServerWindowsService\DoctorDealsPMP.cs:line 532 at DoctorDeals.DoctorDealsPMP..ctor() in C:\Users\Daniel Rail\Documents\Visual Studio 10\Projects\DoctorDeals\DoctorDeals.PServerWindowsService\DoctorDealsPMP.cs:line 38 And, the line in HasTriggers is: FbTransaction vTrans1 = fbConnCommands.BeginTransaction(); After downloading the pdb file, it gave me the line of code that wasn't working. It was the line 474, in BuildTbp (the first line of the for loop for the lock tables). What is odd for me, is that the application runs on my development machine, but fails on their new Windows 2008 R2 server, with all updates installed. I downloaded the source code and commented out that code and everything is working now. I'm now seriously considering to setup a clean system for testing purposes. And, keep up the good work. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-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] FbDbType.Decimal param fails
Hi, At January-25-10, 5:19 PM, Richard Green wrote: Using this, the insert fails with this message: The string was not recognized as a valid DateTime. There is a unknown word starting at index 0 Can you show us all of the insert statement and then the code that creates the FbParameter[] and assigning of the values? -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-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] Firebird Client error during Fetch cycle
Hi, At January-19-10, 6:01 AM, Russell R wrote: Tried putting in a wait between each read and also between each read cycle (every 200 reads for the default fetch size), but I get the same issue. Is it possible that it's a memory resource limit on the client that you are hitting? You did mention that it is a handheld device. What is the hardware configuration(especially memory size)? -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-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, At January-08-10, 3:56 AM, André Knappstein, Controlling wrote: I don't know. If I remember correctly I have read that unicode takes an extra byte per character and I did not want to hit any technical limit (max. lenghth of index key and such...) UTF-8 can take between 1 and 4 bytes per character. The length of the index key in FB 1.5 and up is a quarter of the page size(i.e.: for a page size of 16KB, the maximum index key size will be 4KB). And I dimly remember that there were such limits for FB 1.5, which have been extended along with 2.x. Here you are correct, with regards to index key size. The only limitation that existed in FB 1.5, that was basically removed from FB 2.0+, was the table size limit, which under FB 1.5 was 40GB/table and is now(in FB 2.0+) a few TB/table. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- 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] .NET 4
Hi, At January-03-10, 12:20 PM, Jiri Cincura wrote: 1. Dropping .NET 2.0 support. The .NET 3.0 and mainly .NET 3.5 is just update for .NET 2.0. There's no new runtime or changes in bases. So there's no risk installing this update. This step will provide us option to use new features and make the code more clean and probably also faster. Taking into account limited resources project has, this will also allow focus more on new features. Until the official .NET 4 release there will be still support for .NET 2.0. But not after it. Builds for .NET 3.5 and .NET 4 will be provided on site as now. I would suggest that the version 2.x of the Firebird ADO.Net provider would be the last version to support .Net 2.0. And, that Firebird ADO.Net provider version 3.0+ will support .Net 3.5(with EF installed) and .Net 4(EF already included). And, of what I can see, there will most likely need two distributions(one for .Net 3.5 and the other for .Net 4), read it as being that the provider is compiled for each .Net version. 2. CSC 4 will be the official compiler. New compiler means (maybe) better code. New features and syntactic sugars means faster development. You don't need to build provider yourself so you are not affected by this. If you're building it yourself you don't need VS2010 to install. Just use CSC thru cmd/MSBuild and you're fine. [1] 3. Switching the solution(s) to VS2010. With 2. this is pretty obvious. As you're safe with us using new compiler, this is more true for new IDE. [1] I agree on points 2 and 3. What I don't know is whether there's some demand on VS2005 DDEX support dropping and extending support for new stuff in VS2008. VS2008 adds some really minor features, as far as I remember when checking it, so it's probably not worth doing it. But maybe you have different opinion. If it is to drop the support for VS2005 DDEX, then it would be to still keep it available for download, for those that might still need it. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- 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] Expanding mapping abilities for EF
Hi, At December-30-09, 2:40 PM, Jiri Cincura wrote: Hi *, I was thinking about supporting broader variety of datatypes (from .NET) in EF for mapping. We already had a request for direct guid support and since beginning we have (manual) support for bools. Unfortunately neither of these is available directly in FB, hence there's set of standard workarounds like char(16) octets for guid. And as we started supporting features not available in FB directly through autoincrement field via #PK_GEN# in comment, I would like to propose similar way for bool and guid. I don't like the way of guessing - char(16) octets = guid etc. It may work in 99 percent cases but, sooner or later you hit the wall with bad guess. So my propose is to override the datatype of column reported by provider for EF by two new magic keywords. For guids it'll be #GUID# and for bools #BOOL#. What I'm not sure about is whether do check for the datatype as well. Like smallint #BOOL# is bool, but timestamp #BOOL# is still timestamp. I'm more for blindly using the comment and leave the thinking to developer. Why? Because for i.e. bool you can have smallint, int, bigint and maybe decimal if you're brave enough. For guids with triggers and views maybe some crazy types. This shouldn't create any hidden places with potential error. As if the thinking will be wrong with first let's say insert you'll get an error. But that's only my view. Any comments, thoughts? What happens if someone uses another type for bools? As an example, I usually use CHAR(1) with the values T and F. If it can be configurable, with a default of SMALLINT, it would be even better. And, I could almost say the same for GUIDs, as some might be storing them in a VARCHAR(32), in another charset than OCTET. I currently use ECO and the GUID field is stored in a VARCHAR(32) UTF-8 field. And, don't try to automatically map to those types, because it's possible that someone uses a SMALLINT field as an actual SMALLINT, not a boolean. I could probably say the same for CHAR(16) OCTET, as you might be suspecting for that other 1%, where the assumption might be wrong. I would suggest, if it's possible, to simply give a warning to the developer that #BOOL# and TIMESTAMP don't match, but still let the developer use that combination. And, if an error occurs in runtime, then the developer will realize that it wont work. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- 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] ANN: FirebirdClient 2.5.1 released
Hi, At September-12-09, 11:26 AM, Jiri Cincura wrote: Hi *, I'm proud to announce next version of FirebirdClient - 2.5.1. This release is focused mainly on bug fixes, no new features were added. Is there any changes to the interface, compared to 2.5.0? Because, I'm using ECO that is looking for 2.5.0, and ECO is supposed to be compiled with Specific Version=false. Also, I noticed that the downloads for 2.5.0 are not available on Sourceforge, other than the web provider. And, excellent work! -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ANN: FirebirdClient 2.5.1 released
Hi, At September-23-09, 3:15 PM, Jiri Cincura wrote: On Wed, Sep 23, 2009 at 18:36, Daniel Rail dan...@accra.ca wrote: Is there any changes to the interface, compared to 2.5.0? Nope. Any breaking change will result in b+1 (or a+1 obviously) in a.b.c(.d) our version schema. Thanks for the information. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ 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 FbConnection.ConnectionString Designer
Hi, At Thursday, June 18, 2009, 12:49 PM, Jiri Cincura wrote: On Thu, Jun 18, 2009 at 15:37, Scott Pricescott.pr...@virgin.net wrote: OK, whilst it's good to know that it's not to do with the DDEX, not all software just uses the Microsoft stated methods. I use Firebird with Capable Objects Enterprise Core Objects (ECO) and that only needs the connection, so the only thing I'm actually interested in is the ability to configure the ConnectionString, which was why I noticed the designer was missing. Why not to create connection object in code and load connection string from app.config? That's IMO much better. And BTW having data connection component in UI is a very bad idea. ;) Actually, in this case the data connection component is not placed in the UI. With ECO, you place the connection component in an EcoSpace, which is non-visual, but has a visual designer to drop non-visual components on it. And most likely the data connection component would be used on the application server. But, why was the connection builder dialog disabled, from the ConnectionString property of FbConnection? -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- 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] Problem using provider with IIS 7
Hi, At Tuesday, March 10, 2009, 7:22 PM, Jiri Cincura wrote: Do you have record in DbProviderFactories in machine.config for 64b? Thanks, that worked. And, I did forget about it. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- 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] Problem using provider with IIS 7
Hi all, We have an ASP.Net website that works in IIS 6 on Windows Server 2003, using the Firebird ADO.Net 2.0.1. Now, we are migrating that server to Windows Server 2008 64-bit and IIS 7. But, we are encountering some problems. The error is that it is saying that it cannot find the .Net Data Provider specified. And, the assemblies are located in the bin folder of the website. We also decided to use the Firebird ADO.Net data provider install, and we do notice that it is in the GAC. We're starting to think that we might need to add the assemblies to the list of assemblies in the web.config file. Any help or suggestions would be appreciated. -- Best regards, Daniel Rail Senior System Engineer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) -- 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
Re: [Firebird-net-provider] RFC: Installation
Hi, At Friday, March 07, 2008, 11:15 AM, terrytornado wrote: Hi all, i'm 15 years developing under Delphi. Now i try c# and new to Visual Studio. I have big problems to install the firbird VS add in. It's a big problem to make a full install routine. ?? Making addionally changes in certain files per hand it's not the best way. Too many failures can someone like me to their. Jiri does recognize that the installation of the DDEX support would most likely be better automated via the installation. But, the ADO.Net driver itself is not that complicated to install. Simply add it to the GAC, by using the .Net framework's gacutils.exe command line. Then, you can go in VS and add it to the toolbox, by choosing from the list of components available in the GAC. Or even simpler, skip the GAC registration and go straight into VS and go into the Choose Toolbox Items and Browse for the FirebirdClient dll, to add it to the VS Toolbox. And, then you can use the components for your projects. But, if you want more support within VS, then you have to install FirebirdClient's DDEX. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.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] RFC: Installation
Hi, At Thursday, March 06, 2008, 11:22 AM, Marvin Cook wrote: Jiri, While I agree that most developers have the capability to unpack and add the elements to the correct place, it is an area that prone to error. One of the things a computer is good at is doing tedious things correctly once it has been trained (programmed). To me, it makes more sense to train the computer once and let it do the work than make all the users master the tedious stuff -- again. I have to agree with Marvin. The new developers to .Net and Visual Studio might prefer a full automatic install. Also, it seems easy to make a mistake, and if something isn't working right in VS after making all the manual changes that are required. It might be hard to find what you did wrong. As an example, I know I can't see any problem with the configuration settings that I entered manually, but VS2005 is still telling me that I did something wrong with installing Firebird ADO.Net, when I try to create some of the enterprise solutions that Microsoft provides via their Guidance packages. I just want to see what they are and in which kind of project that I might use them, but for now, I can't. I do have the proper GUID copied from the GAC to those locations that I had to edit manually. So, I wonder if a fully automated install into VS would avoid those problems, that I'm having. Also, I'm just starting to learn C# in VS2005 and VS2008. But, I've been a Delphi developer for 13 years and using Firebird since the first version. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.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] FireBird Crashes when users log onto it
Hi, At November 21, 2007, 10:37 AM, yogiyang wrote: Is the application installed on every client machine, or are you running remote sessions? Yes the Application is installed on every Client as all clients are Thick Clients. That shouldn't make any difference. Because, we have customers that have Firebird servers (Superserver) having over 40 active connections, using Win2003 Standard. When Firebird crashes, what is in Firebird's log file? Excuse me if this is a stupid question, but are you familiar with the concept of backup/restore? I am Familiar with the concept of Backup/Restore. Why? what has that got to do with this problem? Firebird will not automatically shrink a database, unless you do a backup and restore, using GBAK. -- Best regards, Daniel Rail Senior Software Developer ACCRA Solutions Inc. (www.accra.ca) ACCRA Med Software Inc. (www.filopto.com) - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. 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] Problem integrating with VS 2005
Hi, I'm trying to integrate the DDEX in VS 2005, but I'm not being successful. I followed all the directions, even rebooted my computer, but no success. I can use the ADO.Net components in a Windows Forms application without any problems. But, I'm having difficulty trying to get it to work for ASP.Net and the DDEX integration. The error that I'm getting when trying to add a connection is An unexpected error occurred in the .NET Framework Data Provider for Firebird. Please contact the provider vendor to resolve this problem. And, I don't see the connections dialog. Also, I did install the VS 2005 SDK. Any help would be appreciated. Daniel Rail - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider