Problem with masking dates on application.

Compiled application works perfectly on the development computer. When deployed on clients machine all data appear like / /10 instead of 2/2/10. Using native sql server. Any ideas? Using windev 22.

DBNETLIB or SQLNCLI?
If SQLNCLI what is the SQLNCLI version and what is the SQLSERVER version?
What are the formats of the date columns in the DB, date or datetime?

Regards

Paulo Oliveira

sql server version 2008
format is datetime

not sure of sqlncli or dbnet.lib

using pcsoft native access



Edited 1 time(s). Last edit at 02/04/2019 02:50PM by jcsoft.

How are your tables define in the analysis, datetime or date?

Regards

Paulo Oliveira

datetime

With this kind of problems you are problably using SQLNCLI, please check the SQLNCLI version in the client machines and update it if necessary.

In you development machine you have the SQL SERVER installed as well? If yes you are using the SQLNCLI installed with the SQL SERVER and the client machine are problably using some other version.


Check this help pages an the related ones:
[doc.windev.com]
[doc.windev.com]
[doc.windev.com]

Regards

Paulo Oliveira

I run the program on my machine using a vpn to get to the clients sql server. Here it works.

When I upload the program to the clients workstation that is when the problem starts.

Joe



Edited 1 time(s). Last edit at 02/04/2019 06:11PM by jcsoft.

If i understand it correctly you are running the app in your pc connected to the client sql server database.
In this case everything is pointing to the SQLNCLI version installed in the client machine.

Don't forget that the SQLNCLI must be installed in every PC. Check the SQLNCLI version used in your PC and in the client machine, you can do it in the same place you use to define the ODBC connections.

You can download the SQLNCLI from the MICROSOFT web site, check this pages:
[docs.microsoft.com]
[www.microsoft.com]

The new MSOLEDBSQL will be supported by PCSOFT in version 24. [doc.pcsoft.fr]

Regards

Paulo Oliveira



Edited 5 time(s). Last edit at 02/04/2019 07:19PM by pao.

Thank you. Downloaded and installed SQLNCLI. It worked !!!

Joe