Re: VFP 6.0 & ODBC
- From: "Demetrios Panayotakopoulos" <dpanayotakopoulos_123@xxxxxxxxxxxx>
- Date: Tue, 6 Dec 2005 15:51:17 +0200
Ohh...thank you so much Cindy.
The latest driver did work indeed.
Demetrios, Greece
"Cindy Winegarden" <cindy_winegarden@xxxxxxx> wrote in message
news:25C969C9-900C-4F89-A81D-2AFDD0C27C3A@xxxxxxxxxxxxxxxx
Hi Demetrios,
The latest FoxPro and Visual FoxPro ODBC driver, version 6.0.8629.1, is
downloadable from http://msdn.microsoft.com/vfoxpro/downloads/updates.
Try that and see if you still get the same errors.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Demetrios Panayotakopoulos" wrote:
> As a part of a test, I try to access VFP Tables through ODBC.
>
> Here is what I do:
> o I create a System DSN using "Microsoft Visual ForPro Driver"
> 2.00.8167.00,
> VFPODBC.DLL
> o Set the Data Source Name as "mailw"
> o Set the Database Type as Visual FoxPro database (.DBC)
> o and the path as: "c:\MyApps\Mailw2000\mailw2000.dbc"
>
> Trying:
> SQLConnect("mailw")
> I get -1 (failure)
>
> If instead, I create the same as above, using "Free table directory"
> instead
> of .DBC
> and set the pasth to: "c:\MyApps\Mailw2000"
>
> SQLConnect("mailw") returns a conection handler.
> But truing to select data from existing table in the directory, I get -1
> again.
> h=SQLConnect("mailw")
> ? SQLExec(h, 'Select * from Names')
.
- References:
- VFP 6.0 & ODBC
- From: Demetrios Panayotakopoulos
- VFP 6.0 & ODBC
- Prev by Date: Re: [crystal report] passing parameter from VFP to CR
- Next by Date: sms modem string
- Previous by thread: Re: VFP 6.0 & ODBC
- Next by thread: Task manager Memory usage
- Index(es):
Relevant Pages
|
Loading
