Could not convert database value to object member.

BIZ TMS Aurelius
1

Could not convert database value to object member.
Class name: ...
Column name: effDate
Attribute name: FeffDate
Database value: 2025-03-06

On my Windows 11 Desktop all works fine. When running the program on Windows Server 2019 I get this error. I am suspecting it is a driver issue of some sort. Settings for Aurelius Connection or to use Native Drivers MSSQL. Is there a setting or specific Native Driver that needs to be installed to resolve?

2

That can be related to driver, regional settings, the database column type, etc.

Is the database you are accessing from Windows 11 Desktop different than the one you access from Windows Server 2019?

What is the type of column effDate?

What is the type of field FeffDate?

In any case, try to use the same driver to isolate the problem.

3

effDate is a Date field in the Azure SQL DB. Using same Azure SQL server from both machines feffDate or ORM property for effDate. Not sure what driver is being used since we are selecting the built in MSSQL option in Aurelius
image.

Is there any way to tell which driver it is using on the desktop (OLE DB, ODBC etc.) to match with the Server? Other option would be to not use the native driver support and use UniDAC I guess.

4

This is what you can use to get the used connection string from an IDBConnection interface with MSSQL native driver:

  var Conn: IDBConnection := AureliusConnection1.CreateConnection;
  var OdbcConn := (Conn as TOdbcNativeConnectionAdapter);
  Memo1.Lines.Add(OdbcConn.ConnectionString);

The connection string will contain the driver being used.