Hi,
i've got a problem with my dotnet application reading data from different tables of my advantage database server through a sql "join" statement. The tables are from an old clipper application, so the table type is "ntx". One *.dbf and several *.ntx files for each table.
I use the dotnet data provider to connect to the database. Connection String: Data Source=\PathToDatabase\database.add;Password=*;User ID=adssys;CharType=GENERAL_VFP_CI_AS_437;ServerType=REMOTE;LockMode=COMPATIBLE;Shared=True;TableType=NTX;UnicodeCollation=de_DE"
Everything works fine until applying a "join" in the sql statement. The server always returns an empty table.
Without setting the charType in the connection string, the server returns the correct result.
How is it possible to define a "join" statement with CharType set to GENERAL_VFP_CI_AS_437?
Thanks
Christian