More SQL craziness

[Liska Station]

Hi guys! Just got the specs from the client's IT dept. and oooo boy, is it
different thatn what I thought it'd be.

How would I connect to e remote SQL server using something like a
SQLCONNECT() Or a SQLStringCONNECT() with the following little... quirk:

The remote server is (for our example here) intranet.orgname.org, and the
sql table name is "patients".

Basically they're going to VPN into the main network, and they want this to
work remotely from the user's offsite laptops.

All I need to do is get either a view or a handle to this SQL table and be
able to filter and search it like VFP data. Not a problem when I've got an
onsite SQL server set up (Thanks Fred!), but with remote data on a
webserver, it's kicking my tail.

Any ideas, or good examples? I've searched the UT, MSDN, and foxite, but
haven't found anything remotely useful about this.

Thanks!

-LS

[Lee Mitchell]

Hi Liska Station:

Have you looked at this article from the www.west-wind.com Web site?

http://www.west-wind.com/presentations/internetenabling/internetenabling.htm

I think you can use the part that discussed accessing table using TCP/IP.

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

Post by Liska Station
Hi guys! Just got the specs from the client's IT dept. and oooo boy, is it
different thatn what I thought it'd be.
How would I connect to e remote SQL server using something like a
The remote server is (for our example here) intranet.orgname.org, and the
sql table name is "patients".
Basically they're going to VPN into the main network, and they want this to
work remotely from the user's offsite laptops.
All I need to do is get either a view or a handle to this SQL table and be
able to filter and search it like VFP data. Not a problem when I've got an
onsite SQL server set up (Thanks Fred!), but with remote data on a
webserver, it's kicking my tail.
Any ideas, or good examples? I've searched the UT, MSDN, and foxite, but
haven't found anything remotely useful about this.
Thanks!
-LS

[Liska Station]

Thanks! Got it figured out thanks to that westwind article. Turned out to
be mostly a syntax issue on the connection sting.

Thanks again!

Post by Lee Mitchell
http://www.west-

wind.com/presentations/internetenabling/internetenabling.htm

[Kanis Rufus]

We are also using a custom class lib based on the cursor adapter to connect
seemlessly to either SQL Server or VFP data. Was really easy to set up.

Post by Liska Station
Hi guys! Just got the specs from the client's IT dept. and oooo boy, is it
different thatn what I thought it'd be.
How would I connect to e remote SQL server using something like a
The remote server is (for our example here) intranet.orgname.org, and the
sql table name is "patients".
Basically they're going to VPN into the main network, and they want this to
work remotely from the user's offsite laptops.
All I need to do is get either a view or a handle to this SQL table and be
able to filter and search it like VFP data. Not a problem when I've got an
onsite SQL server set up (Thanks Fred!), but with remote data on a
webserver, it's kicking my tail.
Any ideas, or good examples? I've searched the UT, MSDN, and foxite, but
haven't found anything remotely useful about this.
Thanks!
-LS