FoxPro Help and Support - Read Sequel Server with FoxPro. How?

Author

Read Sequel Server with FoxPro. How?

Barley Man

2005-05-12, 8:25 pm

A client has a huge Sequel server database. He wants me to 'report' on it via
VFP7:

1) Is it physically possible to take copies of his 'tables' 'databases' in
Sequel format to my 'home' machine and read the data via ODBJ WITHOUT
having a running copy of Sequel Server Run Time (or whatever it's called) on
my 'home' machine. I.e., can Fox read the Sequel Server 'tables' without
owning a copy of Sequel Server.

2) What's the best way to 'read' a Sequel Server 'table' with Fox? Can Fox
pass 'queries' to Sequel Server to process on the Server only returning the
data that has been 'filtered' or do I have to process it in the standard
"send me all the data and I'll filter it" approach.

Any other ideas which may help me?

Ian

Dan Freeman

2005-05-12, 8:25 pm

Go to http://www.hentzenwerke.com/catalog/csvfp.htm

This book, and literally hundreds of magazine articles written in the last
10 years, provide a lot of useful information.

The help file is actually pretty helpful in this regard too. <g>

Dan

Barley Man wrote:
> A client has a huge Sequel server database. He wants me to 'report'
> on it via VFP7:
>
> 1) Is it physically possible to take copies of his 'tables'
> 'databases' in Sequel format to my 'home' machine and read the data
> via ODBJ WITHOUT having a running copy of Sequel Server Run Time
> (or whatever it's called) on my 'home' machine. I.e., can Fox read
> the Sequel Server 'tables' without owning a copy of Sequel Server.
>
> 2) What's the best way to 'read' a Sequel Server 'table' with Fox?
> Can Fox pass 'queries' to Sequel Server to process on the Server only
> returning the data that has been 'filtered' or do I have to process
> it in the standard "send me all the data and I'll filter it" approach.
>
> Any other ideas which may help me?
>
> Ian

Anders Altberg

2005-05-12, 8:25 pm

SQLServer ODBC (Open Database Connectivity) is free from Microsoft. The free
version of SQLServer is called MSDE and a copy you can use is delivered with
the VFP install disks.
In VFP, check out all the functions name SQL.. , like SQLConnect(),
SQLEXEC() , SQLGETPROP() and so on.
In Help, read up on CREATE DATABASE, CREATE CONNECTION and CREATE SQL VIEW
xx REMOTE CONNECTION.
-Anders

"Barley Man" < BarleyMan@discussion
s.microsoft.com> wrote in message
news:7BAE0FBA-6B96-4FA4-B90D- E4C27EF674B3@microso
ft.com...
> A client has a huge Sequel server database. He wants me to 'report' on it
via
> VFP7:
>
> 1) Is it physically possible to take copies of his 'tables' 'databases' in
> Sequel format to my 'home' machine and read the data via ODBJ WITHOUT
> having a running copy of Sequel Server Run Time (or whatever it's called)
on
> my 'home' machine. I.e., can Fox read the Sequel Server 'tables' without
> owning a copy of Sequel Server.
>
> 2) What's the best way to 'read' a Sequel Server 'table' with Fox? Can Fox
> pass 'queries' to Sequel Server to process on the Server only returning
the
> data that has been 'filtered' or do I have to process it in the standard
> "send me all the data and I'll filter it" approach.
>
> Any other ideas which may help me?
>
> Ian

Anders Altberg

2005-05-13, 7:24 am

Let med add thast VFP9 does a better job of this and has new datatypes the
match the data types in SQLServer.
-Anders

"Barley Man" < BarleyMan@discussion
s.microsoft.com> wrote in message
news:7BAE0FBA-6B96-4FA4-B90D- E4C27EF674B3@microso
ft.com...
> A client has a huge Sequel server database. He wants me to 'report' on it
via
> VFP7:
>
> 1) Is it physically possible to take copies of his 'tables' 'databases' in
> Sequel format to my 'home' machine and read the data via ODBJ WITHOUT
> having a running copy of Sequel Server Run Time (or whatever it's called)
on
> my 'home' machine. I.e., can Fox read the Sequel Server 'tables' without
> owning a copy of Sequel Server.
>
> 2) What's the best way to 'read' a Sequel Server 'table' with Fox? Can Fox
> pass 'queries' to Sequel Server to process on the Server only returning
the
> data that has been 'filtered' or do I have to process it in the standard
> "send me all the data and I'll filter it" approach.
>
> Any other ideas which may help me?
>
> Ian

Craig Berntson

2005-05-13, 11:24 am

"Barley Man" < BarleyMan@discussion
s.microsoft.com> wrote in message
news:7BAE0FBA-6B96-4FA4-B90D- E4C27EF674B3@microso
ft.com...
>A client has a huge Sequel server database. He wants me to 'report' on it
>via
> VFP7:
>
> 1) Is it physically possible to take copies of his 'tables' 'databases' in
> Sequel format to my 'home' machine and read the data via ODBJ WITHOUT
> having a running copy of Sequel Server Run Time (or whatever it's called)
> on
> my 'home' machine. I.e., can Fox read the Sequel Server 'tables' without
> owning a copy of Sequel Server.

No. You need some type of SQL Server. The Developer Version is only $50 and
has all the tools you need to get up and running. MSDE is free, but has no
management GUI and is limited in the database size.

>
> 2) What's the best way to 'read' a Sequel Server 'table' with Fox? Can Fox
> pass 'queries' to Sequel Server to process on the Server only returning
> the
> data that has been 'filtered' or do I have to process it in the standard
> "send me all the data and I'll filter it" approach.

Server-based systems, like SQL Server, Oracle, MySQL, and others all return
only the data requested in the query.

In addition to the VFP docs, here are some places to get started. Some of
these articles are a bit dated and talk about some technologies that are no
longer used (RDS for example), but still contain some good information.

http://msdn.microsoft.com/archive/e.../msdn_bko01.asp
http://msdn.microsoft.com/archive/e...sdn_fpsqlcs.asp
http://msdn.microsoft.com/archive/e.../msdn_bko02.asp
http://msdn.microsoft.com/archive/e...msdn_usevfp.asp
http://msdn.microsoft.com/library/e...tml/adojump.asp
http://msdn.microsoft.com/library/e...beddingmsde.asp

There are some sample chapters you can download from
http://www.hentzenwerke.com/catalog/csvfp.htm

>
> Any other ideas which may help me?
>
> Ian

--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net

swdev2

2005-05-14, 1:23 pm

Heya Ian -
for the last bit that hasn't been answered yet [can I read client's stuff at
home] -

You should script out, in seperate output files, back at the client's office
:
1. database schema without data
2. database schema WITH data but without security
3. database schema WITH data WITH security

The scripts that are generated here are all ASCII, so you can compress them
with winzip or winrar.
You can run the script files on your local SQL Server Instance.

Then - once you have a working sql db back at your home office, you can
utilize VFP 7 and a sql odbc layer to get to the data either via
parameterized remote views
or
sql pass through ..
then write up your reports in VFP 7 back at your home office.

You can then take your compiled EXE to your client's office .

slan [Bill]
---

"Barley Man" < BarleyMan@discussion
s.microsoft.com> wrote in message
news:7BAE0FBA-6B96-4FA4-B90D- E4C27EF674B3@microso
ft.com...
> A client has a huge Sequel server database. He wants me to 'report' on it
via
> VFP7:
>
> 1) Is it physically possible to take copies of his 'tables' 'databases' in
> Sequel format to my 'home' machine and read the data via ODBJ WITHOUT
> having a running copy of Sequel Server Run Time (or whatever it's called)
on
> my 'home' machine. I.e., can Fox read the Sequel Server 'tables' without
> owning a copy of Sequel Server.
>
> 2) What's the best way to 'read' a Sequel Server 'table' with Fox? Can Fox
> pass 'queries' to Sequel Server to process on the Server only returning
the
> data that has been 'filtered' or do I have to process it in the standard
> "send me all the data and I'll filter it" approach.
>
> Any other ideas which may help me?
>
> Ian

Sponsored Links