Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odbc and vfp 9
Message
From
28/09/2006 12:09:41
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
28/09/2006 11:56:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01157769
Message ID:
01157880
Views:
19
>>>Hello All,
>>>
>>>I need to use ODBC on a VFP 9 database. This ODBC connection should be used from a PHP script.
>>>
>>>I have installed VFP 9 with SP1 (all ODBC drivers installed).
>>>
>>>However, I cannot create any DSN because ODBC claims that there is no Visual FoxPro ODBC driver installed.
>>>
>>>I insist that I need to do this with and ODBC connection (no ADO permitted).
>>>
>>>Can someone give me a hand on this?
>>>
>>>Pat
>>
>>Hi Pat,
>>How are you doing:) No one can give you a hand on that anymore:( VFPOLEDB is the way to go.
>>You might install latest ODBC driver downloading from MS site (included with MDAC 2.5) if you don't need to access VFP9 specific databases.
>>Cetin
>
>Hello Cetin,
>
>It's been quite a long time now! I haven't been touching VFP for a while : very busy with C projects and Web projects (involving PHP).
>
>Here's what I need to do: from a PHP script, I need to interact with VFP 9 data files. The client said that it needs to be working with ODBC and not with ADO (I don't know why).
>
>But whatever way I am using, it seems that I am always blocked somewhere along the road.
>
>Should you use ASP .NET, Cetin, how would you interact with VFP databases then (If I see how it works with ASP .NET, I will be able to extrapolate it to PHP)? Even If I need to use VFPOLEDB ...
>
>Pat

Yes Pat,
I use ASP.Net and C#. Hang on... Few code pointers are coming (all use VFPOLEDB and ADO.Net - you can tell them ADO.Net is not ADO:)
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