SQL v10 numeric field = -1

[Guy]

Hello,__I^m using for the first time the sql version and after conversion of my old report xbase version, i saw that all numeric value with my MSSQL server 2000 now look just with -1. No good data. all my fields characters are all right.__Where is a problem__Thank you__Guy

[kfleming]

Which ODBC driver are you using? What is the data type that is being used within SQL Server? Does same problem happen with a new report?____Kathleen__R&R Support

[Guy]

I tried with 2 different driver (SqL server 2000.81.9031.14 and data direct sql server 4.20) it^s the same__With a new report it^s the same also__And my numeric data are decimal 5__Thanks for help

[Guy]

After a lot of test, i noticed that just "int" works fine. Decimal, numeric, money... doesn^t work__May be a problem with comma and delimeters ? I^m french with a system french, don^t you ?__But should i do to work fine ?__Guy

[Guy]

Hello,__Nobody to help me ?__Guy

[kfleming]

My SQL Server 2000 uses US settings and can see each of these field types without error.____What happens if you use another application such as MSAccess to connect via ODBC to your server? Is it good or bad?____Kathleen__R&R Support

[Guy]

I tested with a windows 2000 pro french station and all is allright.__Only with windows xp pro it^s not good . i search what happens but i don^t find.__Help