Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and Progress RDMS
Message
From
11/10/2002 12:49:46
 
 
To
11/10/2002 12:44:56
Norman Avila
Universal Computadora Guatemala, S.A.
Guatemala, Guatemala
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00710406
Message ID:
00710414
Views:
12
>Hi all, I need to aquire a new development tool for a big local company, and
>as my knowledge for enterprise development I will like to to use VPME/VFP but
>have the following concerns:
>
>1. will it work with Progress RDMS (the company has all its prior data in
>progress in a unix server) Has some one have experience with this database?,
>it does not provide a odbc, there are some other odbc providers but dont
>know exactly its performance.
>

There are ODBC and OLEDB drivers available for Progress, so that you can use RVs/SPT and ADO to access Progress files. there's no direct upsizing wizard for it like there is for SQL Server and Oracle AFAIK. With VFP8 and the CA, the backend issue becomes trivial.

>3. we will like to start moving to another db, what will you suggest
>(SQLserver, .....) What is the best approach to connect to sqlserver is
>there a direct connection, since saw a program made in vfp that uses mssql
>but says has vbasic in the middle for connection.
>

There is a direct upsizing wizard for SQL Server that builds RVs; you can port SPs from the Progress environment by hand to SQL Server by translating them to T-SQL. Again, with the CA, once you figure out how to get the data into the backend, accessing it becomes easy with VFP8.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform