Rick
Tue May 25 14:47:37 CDT 2004
Lee,
Actually, fpsql.fll is a 16-bit DLL written for use under Win3.x by FPW. =
(I've got this file, and using a hex viewer, it clearly says "Microsoft =
FoxPro Connectivity Kit for Windows Version 2.6a".) I believe the DOS =
version was a .PLB. However, I couldn't find a copy of it on my systems =
to verify this.
Rick
=20
"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message =
news:DJjCgUoQEHA.1516@cpmsftngxa10.phx.gbl...
> Hi Jorge:
>=20
> I would like to add to Rick's response. FoxPro 2.6 for DOS did have=20
> something called the Connectivity Kit that allowed you connect to =
Oracle=20
> and SQL Server. If you have the Professional version of FPD 2.6, then =
you=20
> should have this software. However, I have no idea if the fpsql.dll =
still=20
> works under the modern operating systems; this DLL was created to work =
> under MS-DOS and not Windows.=20
>=20
> While it is conceptually possible to connect from a FPD 2.6 program to =
SQL=20
> Server, I really doubt it is practical. You should move all the code =
and=20
> VFP data into VFP and use remote views or SQL Passthrough to connect =
to SQL=20
> Server. =20
>=20
> I hope this helps.=20
>=20
> This posting is provided "AS IS" with no warranties, and confers no =
rights.
>=20
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>=20
> *-- VFP8 HAS ARRIVED!! --*
> Read about all the new features of VFP8 here:
>
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
> Purchase VFP8 here:
>
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=3D11518
> =20
> Keep an eye on the product lifecycle for Visual FoxPro here:=20
>
http://support.microsoft.com/default.aspx?id=3Dfh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retires Sept. 30th, 2003
>=20
> >Jorge,
> >FP DOS cannot directly access SQL Server. You'd have to maintain the =
data=20
> in two formats and >use VFP to "sync" the data as necessary.
> >Rick
> >"Jorge" <anonymous@discussions.microsoft.com> wrote in message=20
> news:CB9B1B14-110E->4E0A-A1C3-C21D87DA1FE5@microsoft.com...
> > I need to migrate from Fox DOS Database to SQL Server and VFP, but i =
need=20
> to access data >from old programs in Fox 2.6 to new BD in SQL Server =
2000=20
> in the migratio process. It could be >possible ??
> > Thanks
> >
>=20
>