Board index » delphi » ms sql server 6.5 & datetime part II

ms sql server 6.5 & datetime part II

hi, i have problems with sql 6.5 and delphi accesing datetime fields.

i'm working with:

delphi c/s 3.02 (bde 4.51) english
sql server 6.5 sp5a english
w95 spanish
winnt 4.0 server spanish sp4
winnt 4.0 workstation spanish sp4

when use in w95 all work OK., but when work in winnt 4 sp4 (server or
workstation ) bde report
"SQL Error Syntax error converting DATETIME from characters string"

try insert dates in somes months (january,april,aug,decem) causes the error
other dates work fine

pd: in winnt 4.0 english version i not have problems

why?

sorry by my bad english

Adrian Lorenzo
cons...@nt.com.ar

 

Re:ms sql server 6.5 & datetime part II


    You can:

*    Open the SQL Client Configuration Utility from the Microsoft SQL Server
6.5 Group and uncheck 'Use international Settings'

or

*    Open the SQL Enterprise Manager, choose Tools / SQL Query Tools, load
and execute the INSTLANG.SQL script ( is in the C:\MSSQL\INSTALL folder),
and then set in your login the default languaje as Espa?ol.

A. Lorenzo <cons...@nt.com.ar> escribi en el mensaje de noticias
7mfrl8$f...@forums.borland.com...

Quote
> hi, i have problems with sql 6.5 and delphi accesing datetime fields.

> i'm working with:

> delphi c/s 3.02 (bde 4.51) english
> sql server 6.5 sp5a english
> w95 spanish
> winnt 4.0 server spanish sp4
> winnt 4.0 workstation spanish sp4

> when use in w95 all work OK., but when work in winnt 4 sp4 (server or
> workstation ) bde report
> "SQL Error Syntax error converting DATETIME from characters string"

> try insert dates in somes months (january,april,aug,decem) causes the
error
> other dates work fine

> pd: in winnt 4.0 english version i not have problems

> why?

> sorry by my bad english

> Adrian Lorenzo
> cons...@nt.com.ar

Other Threads