>>
>>If you are absolutely sure that the 32 bit driver is installed, then change the program to fetch the reason why the connection failed - AERROR() will populate an array with the information on the condition that is leading SQLCONNECT() to return -1.
>
>The error is "no connection could be made because the target machine actively refuses it". I guess my test PC does not like the Devart driver. It was a nice try though.
>Thank you.
Dmitry, it seems like a network connectivity error. Since the other drivers are reaching the target server (aren't they?), could it be the case that the SQL Server is not listening to the default 1433 port?
You may try to change the reference to the server in
#DEFINE SERVER_NAME "YourServerNameOrAddress"
to
#DEFINE SERVER_NAME "YourServerNameOrAddress\InstanceName"
or, after finding out which port is being used, to
#DEFINE SERVER_NAME "YourServerNameOrAddress,PortNumber"
----------------------------------
António Tavares Lopes