Re: mssql server 2012 express
Posted: Thu Aug 04, 2022 2:25 pm
Hi Mol,
I have made many connections to MS SQL / MySql using SQLMIX. All work well. As I had pointed out in the Harbour-user group, remove the trusted connection and see.
As a second step, create a DSN from adminstrative tools->Odbc and connect with SQLMIX using only the DSN name removing other parameters and check.
SQLMIX has good speed. One point to remember though, the result set is presented as a dbf file but is actually a in-memory database, all CREATE/INSERT/UPDATE/DELETE Options have to be executed on the SQL table directly and the data has to be refreshed. Any attempt to append to/update the result set dbf will only be in memory and the actual underlying table is not updated.
Hope that helps.
Warm regards,
Jayadev
I have made many connections to MS SQL / MySql using SQLMIX. All work well. As I had pointed out in the Harbour-user group, remove the trusted connection and see.
As a second step, create a DSN from adminstrative tools->Odbc and connect with SQLMIX using only the DSN name removing other parameters and check.
SQLMIX has good speed. One point to remember though, the result set is presented as a dbf file but is actually a in-memory database, all CREATE/INSERT/UPDATE/DELETE Options have to be executed on the SQL table directly and the data has to be refreshed. Any attempt to append to/update the result set dbf will only be in memory and the actual underlying table is not updated.
Hope that helps.
Warm regards,
Jayadev