Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Upsizing - VFP 5 to SQL Server 7
Message
From
06/05/1999 14:48:48
Mark Ganchrow
Dataware Technology Group, Ltd.
Rochester, New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Upsizing - VFP 5 to SQL Server 7
Miscellaneous
Thread ID:
00215821
Message ID:
00215821
Views:
53
Can this be done? I've done the following:
Installed SQL Server Desktop edition on my Window 98 PC.
Created the database for my app in SQL Server.
Created a System DSN in ODBC Administrator for SQL Server and my new database.

When I run the upsizing wizard, it find the DSN as an ODBC data source and it asks me to log in. After I log in, it gives me the following message:
To upsize to SQL Server 6.x, please install a SQL Server ODBC Driver version 2.05 or later

There are 2 things wrong here:
1. I'm upsizing to SQL Server 7, not 6.x
2. The ODBC administrator shows the SQL Server ODBC driver as version 3.7.

So...
Can this (upsizing VFP 5 to SQL Server 7) be done?

And once it is (even if I have to go to VFP 6, which is do-able), what's the best way for getting the SQL database and its accompanying info to the client site? Does the DSN need to be set up on each PC that will be running this app?

Thanks
mganchrow@networks-inc.net
Next
Reply
Map
View

Click here to load this message in the networking platform