>>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.
>
>If you're using OBDC are you creating a DSN?
>If so, how?

yes that is a good place to start. If you have the connection setup in the ODBC Data Source Administrator you can click "test connection" and see if that works. Also WHERE you put that could be a problem. If you put it in the USER DSN as opposed to the SYSTEM DSN that could cause a problem if you have different users trying to use it.