Errore su SELECT ADO su file DBF.

Article View: free.it.visual-basic

Article #2414

Back to free.it.visual-basic Previous Next

#2414

From: Silvio
Date: Tue, 22 Apr 2003 14:30

34 lines
2091 bytes

Salve, da poco sono passato da DAO ad ADO.
Ho il seguente problema:
Cerco di connettere un database FoxPro usando ADO e quando faccio una select
usando un criterio di confronto con un campo di tipo data mi restituisce il
seguente errore:


Errore di run-time '-2147467259 (80004005)':

[Microsoft][ODBC Visual FoxPro Driver] Missing operand.


Ecco il codice:

 Dim rs As New ADODB.Recordset
 rs.Open "SELECT * FROM Vdeparts WHERE DATEMOV=#3/30/2002#;",
"Provider=MSDASQL.1;Persist Security Info=False;Extended
Properties=DSN=Tabelle di Visual FoxPro;UID=;SourceDB=" & App.Path &
";SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;D
eleted=Yes;"
  While (Not rs.EOF)
    Debug.Print rs(0)
    rs.MoveNext
  Wend
  rs.Close


Premetto la tabella in questione la trasormo in Access e vi accedo sempre
tramite ADO, funziona.
Per� io devo usare il databe FoxPro.
Sbaglio qualcosa nella stringa di connessione, o uso un provider sbagliato ?

Helppppp.
Grazie.

Technical Details

Message-ID: <Bmcpa.42806$%p6.2612181@news.edisontel.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!38.144.126.75.MISMATCH!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp.infostrada.it!newsfeeder.edisontel.com!news.edisontel.com!53ab2750!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ITALIAN,ASCII
X-Google-Thread: f94ee,ca8f4f3635b6ec3f,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2003-04-22 07:30:58 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!38.144.126.75.MISMATCH!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp.infostrada.it!newsfeeder.edisontel.com!news.edisontel.com!53ab2750!not-for-mail
From: "Silvio" <apocalipse@infinito.it>
Newsgroups: free.it.visual-basic
Subject: Errore su SELECT ADO su file DBF.
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <Bmcpa.42806$%p6.2612181@news.edisontel.com>
Date: Tue, 22 Apr 2003 16:30:32 +0200
NNTP-Posting-Host: 62.94.195.212
X-Complaints-To: news@edisontel.com
X-Trace: news.edisontel.com 1051021857 62.94.195.212 (Tue, 22 Apr 2003 16:30:57 MET DST)
NNTP-Posting-Date: Tue, 22 Apr 2003 16:30:57 MET DST
Organization: EdisonTel SpA