Re: fox pro, odbc, remote web server, firewall

From: Beau (webfireinc_at_hotmail.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 11:20:16 -0500

Some articles mentions this, but I think they were outdated. I am still
looking for this answer and I came across references like this..

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dggrfoledbproviderforvisualfoxpro.asp

and this

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q165/4/92.ASP&NoWebContent=1

and some others that mention the mdac2.5 comes with vfpoledb drivers. mdac
2.6 and above do NOT scome with the driver.

I really need to know what port oledb uses to connect. I am used to sql
server. This is tiring. I need to access this data thru a pix so I need to
know what minimal communications I need to allow. Being in a 'protected
area', you only want minimum connectivity necessary to complete the task. I
can allow file sharing but that defeates the purpose of the
firewall/dmz/protected setup.

There is a cisco2600 first, then theres a web server in the dmz, then a pix
506e behind that and a sql box behind that.

I got everything working except web>sql box. (the sql box also contains the
foxpro db. The inhouse billing software I am interfacing is an inbetween
version that uses BOTH sql server and foxpro. They rolled out an incomplete
version, and I am an outside consultant brought in to interface the existing
software and provide a web interface version of the billing system. I can
access the sql no problem because oledb lets you specify an IP/port combo. I
only have to open one port on one ip into the protected side for sql. But
fox pro is like access, you need a file location (i.e.
c:\directory\dbfile.dbf) and that makes problems.

any other workarounds you could suggest would be great. 

-- 
Beau D'Amore,
Robert Half International Inc.
beau@webfireinc.com
www.webfireinc.com
"Cindy Winegarden" <cindy.winegarden@mvps.org> wrote in message
news:%23AIbOgpEEHA.2460@TK2MSFTNGP10.phx.gbl...
> In news: %23ceODNpEEHA.2564@TK2MSFTNGP11.phx.gbl,
> Beau <webfireinc@hotmail.com> wrote:
> > Issues: I cannot install fox pro on the web server. I understand that
> > vfpoledb will not work without fox pro installed ON the web server.
>
> Hi Beau,
>
> I haven't worked with web servers, but it's new to me that the Visual
FoxPro
> IDE needs to be installed on the web server for the Visual FoxPro OLE DB
> provider to work. Can you tell me more?
>
> -- 
> Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP
> cindy.winegarden@mvps.org  www.cindywinegarden.com
>
>
>

Relevant Pages

  • Re: How to load the web server for CE and SQL for CE
    ... it's unreasonable to expect an OEM to be able to include every ... The Pocket PC SDK comes with the Web Server install, and the SQL ...
    (microsoft.public.pocketpc.developer)
  • Re: SQL connection issue
    ... Make sure you have mixed mode security (rerun install if not) - sounds ... Check what libraries you have available. ... TCP/IP to avoid having to contact SQL via named pipes (and its install on ... the web server). ...
    (microsoft.public.dotnet.framework.aspnet)
  • Strange error after installing SQL Client Tools
    ... this isn't related to SQL 7.0 or anything. ... >SP3a on our production web server last night. ... >related to the SQL Client Tools install. ...
    (microsoft.public.sqlserver.server)
  • Re: crystal report "logon failed" on windows server 2003
    ... The sql server's collating ... sequence is not compatible with the web server. ... After i install "East ...
    (microsoft.public.windows.server.general)
  • Deploy to web server ( soft-sys )
    ... I would like to run my script on a web server that I do not have root ... access with (i.e. cannot install anything). ... This appears to me to be potentially against the license terms. ...
    (comp.soft-sys.matlab)