mssql server 2012 express

[jayadevu]

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

[mol]

I removed trusted connection without effect.
I know SQLMIX because many years ago I wrote an application for document workflow and it worked very well for few years.

[mol]

Problem was trivial.
I've defined 15 years ago constant RDDI_CONNECT ad 1003
It should be 61 as in dbinfo.ch
Now it's working