Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using SQL Database in vfp6 sp5
Message
From
06/04/2002 09:08:31
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
06/04/2002 05:23:41
Hisham Serry
Al-Bahar United Company
Kuwait, Kuwait
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00641756
Message ID:
00641784
Views:
13
>Hi Every Body,
>
>I would like to know how can I use an SQL database within Visual Fox, should I creat foxpro database also or directly I can use SQL database ?
>
>I would like to use SQL database directly. I do not like to use ODBC because it slows the system.
>
>any idea ? I will be happy to get answers on this issue.
>
>thanks
>Hisham Serry

Hisham,
You might create a VFP database and define remote views or use SPT (SQL pass through). In either case you'd be using ODBC.
Another alternative is to use OLEDB and ADO. This would need more understanding and conversion in cases.
For a discussion about them and speed diference check wiki site (http://fox.wikis.com/wc.dll?Wiki~CategoryClient/Server) ODBC way might be the one you're looking for.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform