Can we have Visual Foxpro 6.0 front end and SQL-Server backend 1

[narenkv]

Can we have Visual Foxpro 6.0 front end and SQL-Server backend
using odbc .

---

NAREN

 

[Neil Toulouse]

Simple answer, yes!

"I like work. It fascinates me. I can sit and look at it for hours..."

 

[Mike Gagnon]

narenkv

Do a search in the Keyword search on SQL, you will many posts on the subject.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[nicuschor]

Yup

Go to databases, select (or create) one, and create a "connection".

BUT:
- you need a SQLserver with access rights
- get the newest VFP service pack from microsoft


Luck!

 

[JackTheC]

I'm currently working on my first SQL Server project with VFP as front end.

It's a little bit different then I used to with native DBF, but nevertheless, when you got the hang of it, it works great.

You can use REMOTE VIEWS (via a connection) for the most part, or use SQL PASS THROUGH functions with SQLEXEC() for direct access to the server.
Both work amazingly fast.

But remember, native DBF is table/record-based and commands like GOTO BOTTOM work very fast and don't generate traffic, but SQL Server is Set-based, so you have to parameterize big table-views to prevent huge networkload.