Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What port does VFP use for SQL Connection
Message
De
11/06/2019 11:47:58
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01669000
Message ID:
01669004
Vues:
64
>>Got a VFP app that I'd like to take to a SQL backend, but it won't connect. Says everything is fine, but when I try to do anything on the connection it gives me an error that basically says 'Not connected'
>>
>>Research on that error generally comes back to 'port issue' so, what port does VFP default to use and is it possible to change it?
>
>If you are not set the exact port the VFP uses 1433 (default). But you should check what protocols are enabled on both:
>Server and Local machine.
>If SQL Server is enabled in Windows Firewall.

So, of course I'm getting a different error now.
NOW it's telling me that it can't log in to the database that I can connect to in SQL itself with the same login creds.
::Headdesk::
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform