Board index » delphi » dbExpress Error: Operation Not Supported.

Raigo Lukk

Delphi Developer
Sun, 30 Oct 2005 21:36:32 GMT

dbExpress Error: Operation Not Supported.

I have on form:
SQLConnection->SQLDataSet->DataSetProvider->ClientDataSet->DataSource->DBGrid

SQLConnection and SQLDataSet have both Active property true, I use
Interbase database.

when I run the application from Delphi 7 IDE I get error: "dbExpress
Error: Operation Not Supported."
In Delphi the DBgrid displays records fine. What may be the problem? Why
doesn't the application run?

I have Delphi 6 and Delphi 7 both on same machine, can this cause
problems? (I read somewhere about D7 overwriting D6 dbExpress drivers).

Also, where to find good examples of dbExpres use? I looked in
Delphi7/demos/db but only dbxexporer uses dbExpress others are with BDE
or IBX.
Does dbExpress have something like IBX has UpdateSQL, DeleteSQL,
InsertSQL properties? do I understand correct that I simply have to edit
data in ClientDataSet and then call

   if ClientDataSet1.Active then ClientDataSet1.ApplyUpdates(-1); ?

 
Flávio Napole?

Delphi Developer
Sun, 30 Oct 2005 22:29:10 GMT

Re:dbExpress Error: Operation Not Supported.


I had the same problem with mysql4/dbexpress. What is your database?
Dettmer, A. L

Delphi Developer
Sun, 30 Oct 2005 23:02:53 GMT

Re:dbExpress Error: Operation Not Supported.


Quote
Flvio Napole?o wrote:
> I had the same problem with mysql4/dbexpress. What is your database?

He said that he is working with interbase...
Dettmer, A. L

Delphi Developer
Sun, 30 Oct 2005 23:02:45 GMT

Re:dbExpress Error: Operation Not Supported.


Raigo:

Quote
Raigo Lukk wrote:
> I have on form:
> SQLConnection->SQLDataSet->DataSetProvider->ClientDataSet->DataSource->DBGrid

Is the SQLDataSet.CommandType set to ctQuery ?
If yes could you show it ?
Dettmer, A. L

Delphi Developer
Sun, 30 Oct 2005 23:05:20 GMT

Re:dbExpress Error: Operation Not Supported.


Quote
> I have Delphi 6 and Delphi 7 both on same machine, can this cause
> problems? (I read somewhere about D7 overwriting D6 dbExpress drivers).

Maybe this could be the problem, check the windows path and make sure
that the version you are using came first. I see something like this
yesterday. I guess that your app run fine in D6...
Raigo Luk

Delphi Developer
Mon, 31 Oct 2005 05:25:56 GMT

Re:dbExpress Error: Operation Not Supported.


Quote
Flvio Napole?o wrote:
> I had the same problem with mysql4/dbexpress. What is your database?

at the moment I used Firebird. But I have plans to also use Interbase
and PostgreSQL with dbExpress.

The problem is Delphi 7 specific. I created new test application with
Delphi 6 the same way and have no errors at all.

Martijn Tonie

Delphi Developer
Mon, 31 Oct 2005 15:15:17 GMT

Re:dbExpress Error: Operation Not Supported.


Hi Raigo,

Quote
> Flvio Napole?o wrote:
> > I had the same problem with mysql4/dbexpress. What is your database?

> at the moment I used Firebird. But I have plans to also use Interbase
> and PostgreSQL with dbExpress.

What driver are you using with Firebird?

Did you try the one at www.upscene.com?

Quote
> The problem is Delphi 7 specific. I created new test application with
> Delphi 6 the same way and have no errors at all.

--

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com

Dettmer, A. L

Delphi Developer
Mon, 31 Oct 2005 23:28:38 GMT

Re:dbExpress Error: Operation Not Supported.


Quote
> The problem is Delphi 7 specific. I created new test application with
> Delphi 6 the same way and have no errors at all.

Raigo, change the your windows path variable, if you want to use d7 it should came before d6...
Quote

Thomas Mille

Delphi Developer
Tue, 01 Nov 2005 01:19:03 GMT

Re:dbExpress Error: Operation Not Supported.


You should take a look dbExpressPlus.  It has specific capabilities
to help you do cross database development.

Quote
Raigo Lukk wrote:

> at the moment I used Firebird. But I have plans to also use Interbase
> and PostgreSQL with dbExpress.

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus

Ernesto Benestant

Delphi Developer
Tue, 15 Nov 2005 09:51:42 GMT

Re:dbExpress Error: Operation Not Supported.


I'm suffering exactly the same problem. I also have D6 and D7 installed.
I've checked my path, deleted any reference to D6 and restarted, but the
problem persists.

I've found that the problem appears only when running the program (any
program that uses dbExpress) from inside the D7 IDE. If I launch the program
from the command line it runs just fine (the same program without
recompiling it).

Did you find a solution?

E.B.

Quote
"Raigo Lukk" <raigo.l...@mail.ee> wrote in message

news:3ec2453d@newsgroups.borland.com...
Quote
> I have on form:

SQLConnection->SQLDataSet->DataSetProvider->ClientDataSet->DataSource->DBGri
d
Quote

> SQLConnection and SQLDataSet have both Active property true, I use
> Interbase database.

> when I run the application from Delphi 7 IDE I get error: "dbExpress
> Error: Operation Not Supported."
> In Delphi the DBgrid displays records fine. What may be the problem? Why
> doesn't the application run?

> I have Delphi 6 and Delphi 7 both on same machine, can this cause
> problems? (I read somewhere about D7 overwriting D6 dbExpress drivers).

> Also, where to find good examples of dbExpres use? I looked in
> Delphi7/demos/db but only dbxexporer uses dbExpress others are with BDE
> or IBX.
> Does dbExpress have something like IBX has UpdateSQL, DeleteSQL,
> InsertSQL properties? do I understand correct that I simply have to edit
> data in ClientDataSet and then call

>    if ClientDataSet1.Active then ClientDataSet1.ApplyUpdates(-1); ?

Andrew Whit

Delphi Developer
Fri, 18 Nov 2005 18:24:01 GMT

Re:dbExpress Error: Operation Not Supported.


Hi,

Its probably a problem with the MIDAS.dll version.
Probably the best thing to do is include / use the midas libary in your
code.

Regards,
Andrew

"Ernesto Benestante" <n/a> schrieb im Newsbeitrag
news:3ed6b93a@newsgroups.borland.com...

Quote
> I'm suffering exactly the same problem. I also have D6 and D7 installed.
> I've checked my path, deleted any reference to D6 and restarted, but the
> problem persists.

> I've found that the problem appears only when running the program (any
> program that uses dbExpress) from inside the D7 IDE. If I launch the
program
> from the command line it runs just fine (the same program without
> recompiling it).

> Did you find a solution?

> E.B.

> "Raigo Lukk" <raigo.l...@mail.ee> wrote in message
> news:3ec2453d@newsgroups.borland.com...
> > I have on form:

SQLConnection->SQLDataSet->DataSetProvider->ClientDataSet->DataSource->DBGri

- Show quoted text -

Quote
> d

> > SQLConnection and SQLDataSet have both Active property true, I use
> > Interbase database.

> > when I run the application from Delphi 7 IDE I get error: "dbExpress
> > Error: Operation Not Supported."
> > In Delphi the DBgrid displays records fine. What may be the problem? Why
> > doesn't the application run?

> > I have Delphi 6 and Delphi 7 both on same machine, can this cause
> > problems? (I read somewhere about D7 overwriting D6 dbExpress drivers).

> > Also, where to find good examples of dbExpres use? I looked in
> > Delphi7/demos/db but only dbxexporer uses dbExpress others are with BDE
> > or IBX.
> > Does dbExpress have something like IBX has UpdateSQL, DeleteSQL,
> > InsertSQL properties? do I understand correct that I simply have to edit
> > data in ClientDataSet and then call

> >    if ClientDataSet1.Active then ClientDataSet1.ApplyUpdates(-1); ?

Ernesto Benestant

Delphi Developer
Sat, 19 Nov 2005 06:54:34 GMT

Re:dbExpress Error: Operation Not Supported.


I've already solved my problem. Thanks for your comments anyway.

I found that the Delphi installer copied dbxexpint.dll to the Delphi's Bin
folder instead of putting it in the the Windows system folder. When I moved
the file the the system folder the problem just disappeared...

Thanks again,

E.B.

Quote
"Andrew White" <apwh...@nospam.hotmail.com> wrote in message

news:3edb25c9$1@newsgroups.borland.com...
Quote
> Hi,

> Its probably a problem with the MIDAS.dll version.
> Probably the best thing to do is include / use the midas libary in your
> code.

> Regards,
> Andrew

> "Ernesto Benestante" <n/a> schrieb im Newsbeitrag
> news:3ed6b93a@newsgroups.borland.com...
> > I'm suffering exactly the same problem. I also have D6 and D7 installed.
> > I've checked my path, deleted any reference to D6 and restarted, but the
> > problem persists.

> > I've found that the problem appears only when running the program (any
> > program that uses dbExpress) from inside the D7 IDE. If I launch the
> program
> > from the command line it runs just fine (the same program without
> > recompiling it).

> > Did you find a solution?

> > E.B.

> > "Raigo Lukk" <raigo.l...@mail.ee> wrote in message
> > news:3ec2453d@newsgroups.borland.com...
> > > I have on form:

SQLConnection->SQLDataSet->DataSetProvider->ClientDataSet->DataSource->DBGri

- Show quoted text -

Quote
> > d

> > > SQLConnection and SQLDataSet have both Active property true, I use
> > > Interbase database.

> > > when I run the application from Delphi 7 IDE I get error: "dbExpress
> > > Error: Operation Not Supported."
> > > In Delphi the DBgrid displays records fine. What may be the problem?
Why
> > > doesn't the application run?

> > > I have Delphi 6 and Delphi 7 both on same machine, can this cause
> > > problems? (I read somewhere about D7 overwriting D6 dbExpress
drivers).

> > > Also, where to find good examples of dbExpres use? I looked in
> > > Delphi7/demos/db but only dbxexporer uses dbExpress others are with
BDE
> > > or IBX.
> > > Does dbExpress have something like IBX has UpdateSQL, DeleteSQL,
> > > InsertSQL properties? do I understand correct that I simply have to
edit
> > > data in ClientDataSet and then call

> > >    if ClientDataSet1.Active then ClientDataSet1.ApplyUpdates(-1); ?

Thomas Mille

Delphi Developer
Sat, 19 Nov 2005 07:57:21 GMT

Re:dbExpress Error: Operation Not Supported.


This probably means you have another copy of the dll on your machine.
It just so happens that the System directory is one of the first
directories searched, so it is now picking up the right one.

Quote
Ernesto Benestante wrote:
> I've already solved my problem. Thanks for your comments anyway.

> I found that the Delphi installer copied dbxexpint.dll to the Delphi's Bin
> folder instead of putting it in the the Windows system folder. When I moved
> the file the the system folder the problem just disappeared...

> Thanks again,

> E.B.

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus

Ernesto Benestant

Delphi Developer
Mon, 21 Nov 2005 09:08:11 GMT

Re:dbExpress Error: Operation Not Supported.


You were right: I have four of them...

E.B.

Quote
"Thomas Miller" <tmil...@bss-software.com> wrote in message

news:3edbe310$1@newsgroups.borland.com...
Quote
> This probably means you have another copy of the dll on your machine.
> It just so happens that the System directory is one of the first
> directories searched, so it is now picking up the right one.

> Ernesto Benestante wrote:
> > I've already solved my problem. Thanks for your comments anyway.

> > I found that the Delphi installer copied dbxexpint.dll to the Delphi's
Bin
> > folder instead of putting it in the the Windows system folder. When I
moved
> > the file the the system folder the problem just disappeared...

> > Thanks again,

> > E.B.

> --
> Thomas Miller
> Delphi Client/Server Certified Developer
> BSS Accounting & Distribution Software
> BSS Enterprise Accounting FrameWork

> http://www.bss-software.com
> http://sourceforge.net/projects/dbexpressplus

Other Threads

1. SQL error: Table does not support this operation because it is not uniquely indexed

2. ERROR: Operation not supported...

3. Error: Blob and array types are not supported for compare operations

4. DBX Error: Operation Not Supported.

5. Error : Table does not support this operation

6. Error:Table Does not Support this operation

7. Operation not supported error for Join with LIKE clause

8. D7: dbExpress error when driver not support Schema

9. MSSQL:Table does not support this operation because it is not uniquely indexed

10. Table does not support this operation because it is not uniquely indexed