Devart Forums

hello dear friends.

I've encountered a big problem in windows vista with dbexpress MSSqlServer Driver version 3.10.8.0.

Durying the Open method of a ClientDataSet, occurs the folowing errors in some different points of application:

1) SQL Server Error: Line 10: Incorrect syntax near ','. Line 8: Incorrect syntax near ','. Line 8: Incorrect syntax near '?'.

2) SQL Server Error: Line 26: Incorrect syntax near ','. Line 22: Incorrect syntax near 'o?A'.

The CommandText not have parameters, and these caracters under quotation not exists in the query.

In others Windows (XP, Win98, etc) the application works fine.

Some help??

Please specify, what IDE do you use on Windows XP, and on Windows Vista.

Antaeus wrote:Please specify, what IDE do you use on Windows XP, and on Windows Vista.

Sory,

I'm using delphi 7, but the machines using Window Vista and XP aren't delphi instaled. There are final user machines....

Please send me a complete small sample at evgeniyD*crlab*com to demonstrate the problem, including script to create and fill table(s) used in your sample. Also specify the server version you work with.

Antaeus wrote:Please send me a complete small sample at evgeniyD*crlab*com to demonstrate the problem, including script to create and fill table(s) used in your sample. Also specify the server version you work with.

This will be a problem!!!

My application run in a lot of 500 computers in different customers. Only 1 machine give this error.

I Can't reproduce the problem, but analysing the madexcept error message, its impossible occur the error.

Some help

Please trace what command is sent from your application to the server, and what command is received by the server.
You can do the first with the SQLMonitor component of dbExpress, and the second with the SQL Server Profiler.