Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server Driver vs more recent ODBC driver
Message
De
24/11/2018 02:22:03
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Divers
Thread ID:
01663573
Message ID:
01663773
Vues:
40
J'aime (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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform