Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting VFP app to SQL Server
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 6.5 and older
Application:
Web
Miscellaneous
Thread ID:
01579673
Message ID:
01579702
Views:
50
Firewall blocking it maybe?

>ODBC
>
>>How is your VFP app connecting to the SQL server?
>>
>>Is it using ODBC or a direct connection?
>>
>>
>>>Hi,
>>>I may have asked a similar question before but forgot the answer. So bear with me if I am repeating.
>>>
>>>I have a new customer where we are trying to run VFP 9 application with SQL Server database. The VFP 9 application executable is on one server (VM) and the SQL Server is on another VM. I can ping the SQL Server IP from the application VM box. They (IT) told me that the port 1433 (I understand this is a default port of SQL connection) is open (however, I don't know how to test and verify it).
>>>
>>>But when I start the application I get message something to the effect "Server not found or cannot connect". I have seen this message before. It tells me that SQL Server does not allow connection.
>>>
>>>Note that I have this application running successfully on other VM boxes. That is, the SQL Server has several databases, each one used for different site and each application has its own VM box. Therefore, the SQL Server VM probably has anything that needs to be configured, done. (Otherwise, it would not work from other VMs).
>>>
>>>What else can I check on the application VM box? I suspect the issue is a firewall but don't know how to check it. If you have any suggestions, on how to set/test the firewall on the VM box, I would appreciate it too.
>>>
>>>TIA.
ICQ 10556 (ya), 254117
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform