DateTime and Money errors with Delphi 3.0 and SQL Server 6.5

Ricardo René Fuschilo

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

DateTime and Money errors with Delphi 3.0 and SQL Server 6.5

--------------8783FB3FF27F97C07D69C231
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I'm running a Windows NT 4.0 (portuguese) version, and Delphi 3.0 and
SQL Server 6.5 (english) version.

I have a simple table with one DateTime field and another Money field.
When I try to input values for the date (that have the prefix different
between english and portuguese - ex: 'SEPtember' - 'SETembro') or the
money (uppdating the field), I get the errors:

For DateTime - "General sql error. Syntax error converting DATETIME from
character string."
For Money - "General sql error. Cannot convert CHAR value to MONEY. The
CHAR value has incorrect syntax."

Do somebody had this problem before and can HELP me?

--------------8783FB3FF27F97C07D69C231
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML>
I'm running a Windows NT 4.0 (portuguese) version, and Delphi 3.0 and SQL
Server 6.5 (english) version.

I have a simple table with one DateTime field and another Money field.
When I try to input values for the date (that have the prefix different
between english and portuguese - ex: 'SEPtember' - 'SETembro')
or the money (uppdating the field), I get the errors:

For DateTime - "General
sql error. Syntax error converting DATETIME from character string."
 For Money - "General sql error. Cannot convert
CHAR value to MONEY. The CHAR value has incorrect syntax."

Do somebody had this problem before and can HELP
me?</HTML>

--------------8783FB3FF27F97C07D69C231--

Giancarlo Genoves

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:DateTime and Money errors with Delphi 3.0 and SQL Server 6.5

I have the same problem whith NT 4.0 (italian) but, at the moment, I don't
know how to solve it.
I'll get in touch with you if I find a solution and I hope You'll do the
same with me.

E-mail giancarlo.genov...@filodoro.com
Ricardo Ren Fuschilo ha scritto nel messaggio
<34913BA2.BB74B...@trip.com.br>...
I'm running a Windows NT 4.0 (portuguese) version, and Delphi 3.0 and
SQL Server 6.5 (english) version.
I have a simple table with one DateTime field and another Money field.
When I try to input values for the date (that have the prefix different
between english and portuguese - ex: 'SEPtember' - 'SETembro') or the money
(uppdating the field), I get the errors:

For DateTime - "General sql error. Syntax error converting DATETIME from
character string."
For Money - "General sql error. Cannot convert CHAR value to MONEY. The
CHAR value has incorrect syntax."

Do somebody had this problem before and can HELP me?

Ricardo René Fuschil

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:DateTime and Money errors with Delphi 3.0 and SQL Server 6.5

BINGO!!!

I found the solution looking trought this miraculous Forum...

The thing is really simple... You have to run SQL Client Configuration
Utility and uncheck the "Use International Settings" option on DB
Library Configuration!!! Remember that the problem happens only on a
machime that have Delphi 3.0 installed!!

Regards,

rfusch...@trip.com.br

Quote

Giancarlo Genovesi wrote:
> I have the same problem whith NT 4.0 (italian) but, at the moment, I
> don't
> know how to solve it.
> I'll get in touch with you if I find a solution and I hope You'll do
> the
> same with me.

> E-mail giancarlo.genov...@filodoro.com
> Ricardo Ren Fuschilo ha scritto nel messaggio
> <34913BA2.BB74B...@trip.com.br>...
> I'm running a Windows NT 4.0 (portuguese) version, and Delphi 3.0
> and
> SQL Server 6.5 (english) version.
> I have a simple table with one DateTime field and another Money
> field.
> When I try to input values for the date (that have the prefix
> different
> between english and portuguese - ex: 'SEPtember' - 'SETembro') or the
> money
> (uppdating the field), I get the errors:

> For DateTime - "General sql error. Syntax error converting
> DATETIME from
> character string."
> For Money - "General sql error. Cannot convert CHAR value to
> MONEY. The
> CHAR value has incorrect syntax."

> Do somebody had this problem before and can HELP me?

mch..

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:DateTime and Money errors with Delphi 3.0 and SQL Server 6.5

Quote

>I'm running a Windows NT 4.0 (portuguese) version, and Delphi 3.0 and
>SQL Server 6.5 (english) version.

>I have a simple table with one DateTime field and another Money field.
>When I try to input values for the date (that have the prefix different
>between english and portuguese - ex: 'SEPtember' - 'SETembro') or the
>money (uppdating the field), I get the errors:

>For DateTime - "General sql error. Syntax error converting DATETIME from
>character string."
>For Money - "General sql error. Cannot convert CHAR value to MONEY. The
>CHAR value has incorrect syntax."

The LANGDRIVER in SQL Links Driver config for MSSQL might resolve your
problem.

Quote

>Do somebody had this problem before and can HELP me?

>--------------8783FB3FF27F97C07D69C231
>Content-Type: text/html; charset=us-ascii
>Content-Transfer-Encoding: 7bit

><HTML>
>I'm running a Windows NT 4.0 (portuguese) version, and Delphi 3.0 and SQL
>Server 6.5 (english) version.

>I have a simple table with one DateTime field and another Money field.
>When I try to input values for the date (that have the prefix different
>between english and portuguese - ex: 'SEPtember' - 'SETembro')
>or the money (uppdating the field), I get the errors:

>For DateTime - "General
>sql error. Syntax error converting DATETIME from character string."
> For Money - "General sql error. Cannot convert
>CHAR value to MONEY. The CHAR value has incorrect syntax."

>Do somebody had this problem before and can HELP
>me?</HTML>

>--------------8783FB3FF27F97C07D69C231--

Other Threads

1. DATETIME error working with Delphi 3 / SQL Server 6.5

2. Sql Server 6.5, Delphi 3, Money Fields

3. MS SQL Server 6.5, Delphi 4.0 and DateTime

4. Problem with Datetime field en SQL Server 6.5 and Delphi 3

5. Accessing SQL Server 6.5 from Delphi 3.0 Cli/svr

6. MS SQL Server 6.5 + Delphi 3.0 = ???

7. Blobs greater than 32K in SQL-Server 6.5/Delphi 3.0

8. Delphi 3.0 and MS SQL Server 6.5

9. Delphi 3.0 with MS SQL server 6.5

10. Pb dateTime Delphi 3.0 + MS SQLServer 6.5 French