Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What port does VFP use for SQL Connection
Message
From
11/06/2019 11:47:58
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01669000
Message ID:
01669004
Views:
63
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform