FoxPro database connector - More SQL craziness

Author

More SQL craziness

Liska Station

2006-01-09, 1:24 pm

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

2006-01-09, 1:24 pm

Hi Liska Station:

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

http://www.west-wind.com/presentati...netenabling.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/i...cid=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

>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

Liska Station

2006-01-09, 8:27 pm

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

Thanks again!

Leemi@online.microsoft.com (Lee Mitchell) wrote in news:HkohyuUFGHA.3764
@TK2MSFTNGXA02.phx.gbl:

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

Kanis Rufus

2006-03-07, 8:25 pm

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.

"Liska Station" < msnewsJUNKFILTER@Duf
fyWeber.com> wrote in message
news:Xns974689044EDF
8LiskaStation@207.46.248.16...
> 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

Sponsored Links