Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Driver vs more recent ODBC driver
Message
From
24/11/2018 02:22:03
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Miscellaneous
Thread ID:
01663573
Message ID:
01663773
Views:
39
Likes (1)
>>
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform