I had the same problem on one of my computers and did the following as a work around. 1) copy the machine.config to another directory you own and make changes to file in this directory. 2) Copy machine.config back to original directory. I know it sounds odd because if you can't modify a file you should be able to overwrite it, but it worked for me. HTH John
-----Original Message----- From: firebird-net-provider-requ...@lists.sourceforge.net [mailto:firebird-net-provider-requ...@lists.sourceforge.net] Sent: Sunday, June 13, 2010 10:14 AM To: firebird-net-provider@lists.sourceforge.net Subject: Firebird-net-provider Digest, Vol 50, Issue 4 Send Firebird-net-provider mailing list submissions to firebird-net-provider@lists.sourceforge.net To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/firebird-net-provider or, via email, send a message with subject or body 'help' to firebird-net-provider-requ...@lists.sourceforge.net You can reach the person managing the list at firebird-net-provider-ow...@lists.sourceforge.net When replying, please edit your Subject line so it is more specific than "Re: Contents of Firebird-net-provider digest..." Today's Topics: 1. Re: DDEX Provider installed and works....but not correctly (will ferguson) 2. Re: FbDataAdapter, commands and transactions (Pierre Arnaud) 3. [FB-Tracker] Created: (DNET-325) fbConnection.State returns Open even when connection to the server was lost. (Luciano Mendes (JIRA)) 4. Rename a table (sqlsvr) 5. Re: Rename a table (Michael Ludwig) 6. Re: Rename a table (sqlsvr) 7. Re: Rename a table (sqlsvr) 8. Re: Rename a table (marius adrian popa) ---------------------------------------------------------------------- Message: 1 Date: Fri, 11 Jun 2010 17:54:41 -0700 From: will ferguson <willfergu...@westruss.com.au> Subject: Re: [Firebird-net-provider] DDEX Provider installed and works....but not correctly To: "For users and developers of the Firebird .NET providers" <firebird-net-provider@lists.sourceforge.net> Message-ID: <0fa04f67a57a6d4faf6d13be1ec6d955dff6626...@sg1rd3xvs041.red003.local> Content-Type: text/plain; charset="us-ascii" Trying to use ddex. I'm having difficulty making changes to my machine.config file.. access denied. I'm a local admin. But I notice the permissions on this file are locked down. "Trusted Installer" account has full control rights though?? Any thoughts -----Original Message----- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Saturday, 12 June 2010 3:28 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] DDEX Provider installed and works....but not correctly On Fri, Jun 11, 2010 at 16:13, sqlsvr <sql...@yahoo.com> wrote: > Then what is the point of the DDEX provider? Support stuff build on top of it. Connections configurators, wizards, ... and also see DB structure. On the other hand you can step into and add the support. We'll be happy to include it. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------ ------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------ Message: 2 Date: Sat, 12 Jun 2010 13:55:10 +0200 From: "Pierre Arnaud" <pierre.arn...@opac.ch> Subject: Re: [Firebird-net-provider] FbDataAdapter, commands and transactions To: "'For users and developers of the Firebird .NET providers'" <firebird-net-provider@lists.sourceforge.net> Message-ID: <021f01cb0a26$1c158b00$5440a1...@opac.ch> Content-Type: text/plain; charset="us-ascii" No, I do not call SqlCommandBuilder.GetUpdateCommand. All I do is call IDataAdapter.Update on the data set. > -----Original Message----- > From: Jiri Cincura [mailto:disk...@cincura.net] > Sent: Thursday, June 10, 2010 9:01 AM > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] FbDataAdapter, commands and > transactions > > On Wed, Jun 9, 2010 at 22:39, Pierre Arnaud <pierre.arn...@opac.ch> wrote: > > Because adapter.UpdateCommand stays null for the whole execution of > > my program! > > Are you calling GetUpdateCommand somewhere and using the result? > > -- > Jiri {x2} Cincura (CTO x2develop.com) > http://blog.cincura.net/ | http://www.ID3renamer.com > > ------------------------------------------------------------------------ -- > ---- > ThinkGeek and WIRED's GeekDad team up for the Ultimate > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the > lucky parental unit. See the prize list and enter to win: > http://p.sf.net/sfu/thinkgeek-promo > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------ Message: 3 Date: Sat, 12 Jun 2010 12:07:59 +0000 (GMT+00:00) From: "Luciano Mendes (JIRA)" <trac...@firebirdsql.org> Subject: [Firebird-net-provider] [FB-Tracker] Created: (DNET-325) fbConnection.State returns Open even when connection to the server was lost. To: firebird-net-provider@lists.sourceforge.net Message-ID: <2128536147.7491276344479532.javamail.tom...@tracker.firebirdsql.org> Content-Type: text/plain; charset=UTF-8 fbConnection.State returns Open even when connection to the server was lost. ------------------------------------------------------------------------ ---- Key: DNET-325 URL: http://tracker.firebirdsql.org/browse/DNET-325 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider Affects Versions: 2.5.2 Environment: Windows 7 Ultimate; Microsoft Visual C# 2010 Express; Firebird 2.5.0.25920 Release candidate 2; Reporter: Luciano Mendes Assignee: Jiri Cincura ACTUAL RESULT: fbConnection.State returns Open even when connection to the server was lost. EXPECTED RESULT: fbConnection.State should not returns Open when connection to the server was lost. STEPS TO REPRODUCE THIS ISSUE: 1- Start Firebird service and connect with a database [fbConnection]: Verify that after that fbConnection.State returns Open; 2- Stop Firebird Service and compare fbConnection.State with ConnectionState.Open: ISSUE: Verify that: if (fbConnection.State == ConnectionState.Open) returns true; ================================================================ ENVIRONMENT - ADO.NET Data Provider Version: 05-Jun-2010 19:07 - http://netprovider.cincura.net/FirebirdSql.Data.FirebirdClient.dll; - Windows 7 Ultimate; - Microsoft Visual C# 2010 Express; - Firebird 2.5.0.25920 Release candidate 2; ================================================================ -- 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 ------------------------------ Message: 4 Date: Sat, 12 Jun 2010 21:28:25 -0700 (PDT) From: sqlsvr <sql...@yahoo.com> Subject: [Firebird-net-provider] Rename a table To: firebird-net-provider@lists.sourceforge.net Message-ID: <1276403305811-2253220.p...@n4.nabble.com> Content-Type: text/plain; charset=us-ascii How do you rename a table? Every other DBMS supports renaming a table. During development, table names can AND DO change and firebird does not support this. I see that there is already an old request in the firebird tracker that the "firebird developers arrogance" has chosen to ignore...a real shame....if this is the case, I assume that "firebird developers" never worked in a production/development environment....I'm switching back to Oracle. -- View this message in context: http://firebird.1100200.n4.nabble.com/Rename-a-table-tp2253220p2253220.h tml Sent from the firebird-net-provider mailing list archive at Nabble.com. ------------------------------ Message: 5 Date: Sun, 13 Jun 2010 12:42:13 +0200 From: Michael Ludwig <mil...@gmx.de> Subject: Re: [Firebird-net-provider] Rename a table To: firebird-net-provider@lists.sourceforge.net Message-ID: <20100613104212.ga3...@wladimir> Content-Type: text/plain; charset=us-ascii sqlsvr schrieb am 12.06.2010 um 21:28 (-0700): > > How do you rename a table? Every other DBMS supports renaming a table. > During development, table names can AND DO change and firebird does > not support this. Apparently true. But during development it is not much of a problem provided you develop a DDL script that drops and recreates the entire set of objects in the database. Just drop the old set of objects (table plus all dependent objects), rename the table in your script, and then recreate the database. If your database setup involves time-consuming import of lots of data, that is apparently not an entirely satisfactory solution. > I see that there is already an old request in the firebird tracker > that the "firebird developers arrogance" has chosen to ignore... You're probably talking about this one: http://tracker.firebirdsql.org/browse/CORE-2486 You say that "every other DBMS supports renaming a table." Well, MySQL/MyISAM can do it quite easily because it hardly supports any referential integrity. Reading the issue, the way this is implemented in real SQL servers is not as useful as it sounds: This feature could only be implemented after support for "invalidating" metadata objects was added to the Firebird engine, since attempting to replace all table references in the source 'code' of the dependent objects would be much too risky to consider. (This is how Oracle and Postgres have implemented the feature -- they mark all existing objects as invalid and require the developer to correct the references themselves.) So it's far from automatic. All things considered, editing the DDL script using search/replace and recreating the database may be a lot easier. > a real shame....if this is the case, I assume that "firebird > developers" never worked in a production/development > environment....I'm switching back to Oracle. Sorry to hear that: I shall miss the display of skilled arrogance in your provocative posts ... -- Michael Ludwig ------------------------------ Message: 6 Date: Sun, 13 Jun 2010 06:29:23 -0700 (PDT) From: sqlsvr <sql...@yahoo.com> Subject: Re: [Firebird-net-provider] Rename a table To: firebird-net-provider@lists.sourceforge.net Message-ID: <1276435763174-2253431.p...@n4.nabble.com> Content-Type: text/plain; charset=us-ascii I'm appalled at how developers ignore this request, it is either a lack of experience (they never worked in a REAL company in a REAL production environment) or arrogance. Just last week, we renamed a table in SQL Server on a production environment....the table itself contained over 1 TERABYTE of data. The rename operation took 2-3 seconds. So on firebird, you want me to create a new table, import 1 TERABYTE of data, REBUILD THE INDEXES, and drop the old table? What kind of ****** nonsense is that? That is a minimum 3 day operation and meanwhile, all the production applications (that are updated to use the new table name) will be unavailable during that time. Again, what kind of ****** nonsense is that? Why firebird developers ignore this request....it's just amazing. Vote for this request: http://tracker.firebirdsql.org/browse/CORE-3040 -- View this message in context: http://firebird.1100200.n4.nabble.com/Rename-a-table-tp2253220p2253431.h tml Sent from the firebird-net-provider mailing list archive at Nabble.com. ------------------------------ Message: 7 Date: Sun, 13 Jun 2010 06:31:40 -0700 (PDT) From: sqlsvr <sql...@yahoo.com> Subject: Re: [Firebird-net-provider] Rename a table To: firebird-net-provider@lists.sourceforge.net Message-ID: <1276435900814-2253437.p...@n4.nabble.com> Content-Type: text/plain; charset=us-ascii The actual firebird developers response to this CRITICAL BUG is: Thousands of developers worldwide are fine with horse drawn carriages, who needs cars? FIREBIRD IS DANGEROUS, DO NOT USE FOR PRODUCTION ENVIRONMENTS! Also, read Dr. Codds specifications, a DBMS is not a DBMS BY DEFINITION IF IT DOES NOT SUPPORT TABLE RENAMING. -- View this message in context: http://firebird.1100200.n4.nabble.com/Rename-a-table-tp2253220p2253437.h tml Sent from the firebird-net-provider mailing list archive at Nabble.com. ------------------------------ Message: 8 Date: Sun, 13 Jun 2010 17:13:37 +0300 From: marius adrian popa <map...@gmail.com> Subject: Re: [Firebird-net-provider] Rename a table To: "For users and developers of the Firebird .NET providers" <firebird-net-provider@lists.sourceforge.net> Message-ID: <aanlktik4n-iwxvu1ongkvk2fdq3cyavk8gl-igqln...@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 On Sun, Jun 13, 2010 at 4:31 PM, sqlsvr <sql...@yahoo.com> wrote: > > The actual firebird developers response to this CRITICAL BUG is: > Thousands of developers worldwide are fine with horse drawn carriages, who > needs cars? > > FIREBIRD IS DANGEROUS, DO NOT USE FOR PRODUCTION ENVIRONMENTS! > > Also, read Dr. Codds specifications, a DBMS is not a DBMS BY DEFINITION IF > IT DOES NOT SUPPORT TABLE RENAMING. > -- > View this message in context: http://firebird.1100200.n4.nabble.com/Rename-a-table-tp2253220p2253437.h tml > Sent from the firebird-net-provider mailing list archive at Nabble.com. you are screaming with CAPS on and that is not good from dialogue point of view please , the bug or feature that you request is or it will be on developers radar if is simple enough or if there are radical changes in the engine then it will be deffered to a later point oh yes if you scream you don't solve nothing , if you care about your 1T of data then is better in the end to start the dialogue and not screaming that we don't understand the issue or that we don't want , yes we want but maybe changing this in the engile will bring other bugs or is too complicated at the moment. All databases do have bugs and there are relational unexplored corners on all of them but please don't be a a troll and fill a wrong mailing list with wrong question and big caps we are all smart , and you too and we do know how to solve the rdbms issues and workarounds and in the end what this has to do with this .net list ? > > ------------------------------------------------------------------------ ------ > ThinkGeek and WIRED's GeekDad team up for the Ultimate > GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the > lucky parental unit. ?See the prize list and enter to win: > http://p.sf.net/sfu/thinkgeek-promo > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------ ------------------------------------------------------------------------ ------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ------------------------------ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider End of Firebird-net-provider Digest, Vol 50, Issue 4 **************************************************** ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider