How to connect to MSSQL remotely using Visual FoxPro

Upon assisting a customer with this, the following connection string worked fine on a Windows 7, Visual Fox Pro 9.0 setup -

DRIVER=SQL Server Native Client 10.0;SERVER=SERVER.arvixe.com;UID=myuserid;PWD=mypassword;APP=Microsoft Visual FoxPro;DATABASE=mydatabase; Where SERVER is the name of the server you are on (based on the email that you received) and myuserid, mypassword and mydatabase are outlined from within your control panel under the Databases section

  • 1 användare blev hjälpta av detta svar
Hjälpte svaret dig?

Relaterade artiklar

Do you allow remote MSSQL access?

Yes. We do allow remote access to the MSSQL. It is offered on the regular port...

Helm shows MSSQL 2005. I thought you offered MSSQL 2008?

Yes. The MSSQL server is 2008 however since Helm's theme/skin does not offer a way to add MSSQL...

Is there a limit to the size of a database that I can have?

Yes. MSSQL databases are limited to a size of 3 GB.

Do you have a connection string I can use to connect to the local MSSQL database?

 Yes. Please use the following connection string and fill in the necessary spots with your...