SQL Connections in FoxPro

SQL Database in FoxPro is possible using the Connections feature of this application. As you can see I have three different database from SQL Server. The InfoConnString, MoneyConnString and SQLConnString. Now I am able to access the tables from those database. But of course, I need to provide a connection string to access.

SQL Connections

Using SQL Server, you will need a connection string to be able to access the database. Here is the basic connection string format.

DRIVER=sql server;SERVER=ServerName;UID=UserName;PWD=Password;APP=Microsoft Visual;WSID=PcName;DATABASE=DatabaseName

Do not forget to verify connection.