Vista Problem - Incorrect syntax near ...

EderWillian · Post by **EderWillian** » Tue 21 Aug 2007 14:37

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??

Antaeus · Post by **Antaeus** » Wed 22 Aug 2007 08:55

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

EderWillian · Post by **EderWillian** » Wed 22 Aug 2007 17:56

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....

Antaeus · Post by **Antaeus** » Thu 23 Aug 2007 06:35

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.

EderWillian · Post by **EderWillian** » Wed 29 Aug 2007 11:32

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

Antaeus · Post by **Antaeus** » Wed 29 Aug 2007 13:49

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.