Gene Wirchenko
2010-07-13 21:01:48 UTC
Dear Vixens and Reynards:
My VFP app has always been using Fox tables. The company I am
working for is now looking at better data inegration and, for better
or worse, has decided to go with SQL Server.
The existing app is written using xBASE data access for the
basics (though I do use SQL for reports). Obviously, somewhat of a
rewrite is necessary.
How difficult is it to get access to an SQL Server database? I
tried to use Express some time ago, but it was a rather unpleasant
experience, and I did not get far.
I would appreciate pointers to books or articles on connecting
VFP and SQL Server. Ideally, I want a basic tutorial that I can
follow for the first try. It would cover setting up SQL Express and
VFP correctly and have a simple but not simplistic example of a
database.
Sincerely,
Gene Wirchenko
My VFP app has always been using Fox tables. The company I am
working for is now looking at better data inegration and, for better
or worse, has decided to go with SQL Server.
The existing app is written using xBASE data access for the
basics (though I do use SQL for reports). Obviously, somewhat of a
rewrite is necessary.
How difficult is it to get access to an SQL Server database? I
tried to use Express some time ago, but it was a rather unpleasant
experience, and I did not get far.
I would appreciate pointers to books or articles on connecting
VFP and SQL Server. Ideally, I want a basic tutorial that I can
follow for the first try. It would cover setting up SQL Express and
VFP correctly and have a simple but not simplistic example of a
database.
Sincerely,
Gene Wirchenko