Re: Using vfoledb with webservices?
From: Anders Altberg (x_pragma_at_telia.com)
Date: 10/24/04
- Next message: sameer: "tables are not updating properly"
- Previous message: Roger Ansell: "Re: View PDF in VFP Form, Edit Form Field, Capture PDF Form Data"
- In reply to: Kenneth P: "Re: Using vfoledb with webservices?"
- Next in thread: Kenneth P: "Re: Using vfoledb with webservices?"
- Reply: Kenneth P: "Re: Using vfoledb with webservices?"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 24 Oct 2004 19:51:22 +0200
Hi Kenneth
Windows 2000 installs MDAC 2.5, Windows XP installs MDAC 2.7, Windows 2003
installs MDAC 2.8. If you want to upgrade any of these systems you get a
later MDAC package and install that. If they install SQL Server 2000, it
will also install MDAC 2.6.
MDAC 2.7 or 2.8 doesn't install specific OLE or ODBC drivers for any
particular database engines except Oracle and SQL Server. In order to be
able to support Jet ODBC or Jet OLE DB or Visual FoxPro ODBC or VFP OLE DB
they have to get these drivers separately. Some of them were included as
components in MDAC 2.5. VFPOLE.DLL is available from Microsoft separately
or as a component in Visual FoxPro. The current released version is VFPOLEDB
8. MDAC is primarily a client package.
If you're providing a Web Service with any other database as data source
than SQLServer or Oracle (using Microsoft's driver for Oracle) then you
have to install the specific driver for that database. Microsoft provides to
additional OLEDB drivers, the one for Jet and the one for Visual FoxPro.
Maybe your Web hotel didn't realize this simple fact.
So if your Web hosts asked the question 'is VFPOLEDB in MDAC 2.8' the
correct answer is 'No'. If they ask "Does MDAC 2.8 support VFOPLEDB' the
correct answer is 'Yes', and the correct and complete answer is 'Yes. Just
download the driver and install it."
You could also include VFPOLEDB.MSM in a FoxPro install package that
installed the FoxPro database and VFPOLEDB. You could also wrap these into
the ASP.NET distribution package. In other words, it not necessary for the
hotel host to install the ole db drivers as a separate job they would have
to do.
-Anders
"Kenneth P" <KennethP@discussions.microsoft.com> wrote in message
news:30ADBE6A-9572-41BD-A59E-718D586DF847@microsoft.com...
> Anders,
>
> I just got a mail from a webhostel saying that they have Windows Server
2003
> and that they only support what's in this server.
>
> A friend of mine just said that mdac is just a container for drivers. Is
> vfoledb.dll included? And from mdac 2.6 including vfoledb for foxpro v7
> databases?
>
> So if a webhostel on a Windows 2000 Server have installed mdac 2.6 or
> higher, will they have access to vf databases?
>
> Which mdac is installed on a Windows Server 2003? v2.6, 2.7 or 2.8?
>
> Am I wrong about this? Is vfoledb.dll needed at all if a webhostel or my
> development computer has mdac 2.6 or higher installed?
>
> /Kenneth P
>
> "Anders Altberg" wrote:
>
> > Hi Kenneth
> > Could you talk to Mr B again and find out exactly what he asked and why
MS
> > Sweden said this would be against the licencing conditions. Or did MS
Sweden
> > say it wouldn't work. I can believe anything. I'm wondering how they
phrased
> > the question to get such a crazy answer.
> >
> > VFOLEDB was introduced with Visual FoxPro 7. It is supported by all
versions
> > of MDAC since 2.6. VFPODBC has not been updated since VFP 6 and MDAC
2.5.
> > It runs perfectly well with all later versions of MDAC too. What you
want to
> > use is of course VFPOLEDB. The latest release is actually VFPOLEDB
version
> > 9, but it's only in beta with VFP9. The beta is a
http://msdn.com/vfoxpro.
> >
> > You don't even have to distribute VFPOLEDB.DLL version 8 to the Web
hotal.
> > They can get it themselves from
> >
<<http://www.microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE
> > 1-A59E-965869CB3BC9&displaylang=en>>
> > (remove line break if any)
> >
> > "Kenneth P" <KennethP@discussions.microsoft.com> wrote in message
> > news:5BF6BD9C-04F8-42FC-88D7-CF4C63E6B47F@microsoft.com...
> > > No, I haven't. I only talked to Mr A on the phone. With Mr B I have
never
> > > talked a word, I even don't know who he is.
> > >
> > > Another thing that caused my mind.
> > >
> > > As I remeber it, vfpoledb is only supported upto mdac 2.6, not in 2.7
and
> > > 2.8. What happens if mdac 2.6 is on a server and is installed with
mdac
> > 2.7
> > > to achieve .net methods as well? Does the vfpoledb methods vanish or?
> > >
> > > Just asking!
> > >
> > > /Kenneth
> > >
> > > "Anders Altberg" wrote:
> > >
> > > > Hi Kenneth
> > > > I asked a Fox person about a scenario of providing a Web Service
with
> > > > ASP.NET + VFPOLEDB + VFP database. The answer was in short "of
course".
> > > > However only MS legal persons can be directly quoted in matters of
EULA
> > > > interpretation. It's their domain.
> > > > Have you got a transcript you can mail me of the exchange between
person
> > > > 'B' and person 'A'.
> > > > -Anders
> > > > MS VFP MVP
> > > >
> > >
> >
> >
- Next message: sameer: "tables are not updating properly"
- Previous message: Roger Ansell: "Re: View PDF in VFP Form, Edit Form Field, Capture PDF Form Data"
- In reply to: Kenneth P: "Re: Using vfoledb with webservices?"
- Next in thread: Kenneth P: "Re: Using vfoledb with webservices?"
- Reply: Kenneth P: "Re: Using vfoledb with webservices?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
