Re: [Firebird-net-provider] Rename a table

2010-06-13 Thread Michael Ludwig
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

Re: [Firebird-net-provider] Rename a table

2010-06-13 Thread sqlsvr
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 environmentthe table itself contained over 1 TERABYTE

Re: [Firebird-net-provider] Rename a table

2010-06-13 Thread sqlsvr
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

Re: [Firebird-net-provider] Rename a table

2010-06-13 Thread marius adrian popa
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

Re: [Firebird-net-provider] DDEX Provider installed and works....but not correctly

2010-06-13 Thread Jiri Cincura
On Sat, Jun 12, 2010 at 02:54, will ferguson willfergu...@westruss.com.au wrote: 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 UAC? -- Jiri {x2} Cincura (CTO x2develop.com)

Re: [Firebird-net-provider] FbDataAdapter, commands and transactions

2010-06-13 Thread Jiri Cincura
On Sat, Jun 12, 2010 at 13:55, Pierre Arnaud pierre.arn...@opac.ch wrote: No, I do not call SqlCommandBuilder.GetUpdateCommand. All I do is call IDataAdapter.Update on the data set. In the first example, you created instance. Maybe it's good idea to use these commands explicitly and set

Re: [Firebird-net-provider] Rename a table

2010-06-13 Thread Michael Ludwig
sqlsvr schrieb am 13.06.2010 um 06:29 (-0700): 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

Re: [Firebird-net-provider] DDEX Provider installed and works....but not correctly

2010-06-13 Thread Gerdus van Zyl
Try right clicking on eg notepad Run as Administrator and opening and saving using that. On Sun, Jun 13, 2010 at 5:46 PM, Jiri Cincura disk...@cincura.net wrote: On Sat, Jun 12, 2010 at 02:54, will ferguson willfergu...@westruss.com.au wrote: I'm a local admin. But I notice the permissions on

[Firebird-net-provider] Vol 50, Issue 4 Item 1

2010-06-13 Thread John R. Tomaselli
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

Re: [Firebird-net-provider] Rename a table

2010-06-13 Thread Alexander Muylaert
Then stick with oracle, it is a good/better database, but stop spamming my mail account. I'm subscribed to this newsgroup because I care and sponsor the .net provider. Not to listen to some hysterical chicken threatening to go back to oracle. Did you know firebird doesn't support fulltext