ADO and dbf Foxpro - basic.visual

that appears to be a automation error... do you have mdac installed on
WinXP?

check it out
http://msdn.microsoft.com/library/de...dataaccess.asp

Sguindaw

Cerberus wrote:

> Hi
>
> This code work with win2000 and win98 but don't work under win XP
>
> error -2147467259
>
> why?
>
> Set cnFox = New ADODB.Connection
> cnFox.ConnectionString = "Provider=MSDASQL.1;Persist Security
> Info=False;Extended Properties=Driver={Microsoft Visual FoxPro
> Driver};UID=;PWD=;SourceDB=C\;SourceType=DBF;Exclu
> sive=No;BackgroundFetch=Yes;Collate=Machine;Null=Y
> es;Deleted=YES;"
>
> cnFox.Open
>
> Set rsFox = New ADODB.Recordset
> rsFox.Open "select distinct RN_MER from Anagrafiche", cnFox ,
> adOpenForwardOnly, adLockReadOnly
>
> Help Me
> Thanks
>
>

--
Good moorning, Mr. Sguindaw... This is your life, whatever if you like
to live it or not...

I have installed mdac 2.8 and driver foxpro
and now work :-)

Thank you

"Sguindaw" <sguindawQuItA_EsTo@linuxmail.org> ha scritto nel messaggio
news:c1ikuu$1j4d3m$2@ID-10517.news.uni-berlin.de...
> that appears to be a automation error... do you have mdac installed on
> WinXP?
>
> check it out
>
http://msdn.microsoft.com/library/de...ist/dataaccess
..asp
>
> Sguindaw
>
> Cerberus wrote:
>
> > Hi
> >
> > This code work with win2000 and win98 but don't work under win XP
> >
> > error -2147467259
> >
> > why?
> >
> > Set cnFox = New ADODB.Connection
> > cnFox.ConnectionString = "Provider=MSDASQL.1;Persist Security
> > Info=False;Extended Properties=Driver={Microsoft Visual FoxPro
> > Driver};UID=;PWD=;SourceDB=C\;SourceType=DBF;Exclu
> > sive=No;BackgroundFetch=Yes;Collate=Machine;Null=Y
> > es;Deleted=YES;"
> >
> > cnFox.Open
> >
> > Set rsFox = New ADODB.Recordset
> > rsFox.Open "select distinct RN_MER from Anagrafiche", cnFox ,
> > adOpenForwardOnly, adLockReadOnly
> >
> > Help Me
> > Thanks
> >
> >
>
> --
> Good moorning, Mr. Sguindaw... This is your life, whatever if you like
> to live it or not...
>