Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP's DBC and ODBC
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01062718
Message ID:
01062815
Views:
18
>Hello !
>
>As my application got bigger, sometimes it "gifts" me with some corruption data, so I'm thinking on moving to a "real" database, such as MSDE.
>
>But I Know some people use the ODBC to control the data from DBCs, using remote views.
>Is it worth a try ? What would be the advantages / disadvantages ?
>
>What about the speed to access the data ?
>
>Thanks in antecipation,
>
>Cesar

I've done this. The biggest advantage is that if you make your VFP tables properly (make them compatible with SQL Server tables - for example use DATETIME fields, and not Date fields) - then when you want to move from VFP backend, to SQL Server backend, all you have to do is change the connection string your remote views are using.
I did not have any problems with speed to access the data.
ICQ 10556 (ya), 254117
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform