connessione a dbf foxpro

Article View: free.it.visual-basic

Article #1719

Back to free.it.visual-basic Previous Next

#1719

From: Cerberus
Date: Mon, 23 Feb 2004 08:44

20 lines
1640 bytes

Ciao a tutti ho un problema con questa connessione ad un dadabase dbf Foxpro

funziona perfettamente con win2000 e win98 ma con win XP non va mi
restituisce l'errore -2147467259
qualcuno di voi mi sa aiutare?

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

Grazie a tutti

Technical Details

Message-ID: <G6j_b.6419$UI5.2892@tornado.fastwebnet.it>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-05!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!tiscali!newsfeed1.ip.tiscali.net!tornado.fastwebnet.it!53ab2750!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f94ee,7444c9a5309b4225,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2004-02-23 00:48:49 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-05!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!tiscali!newsfeed1.ip.tiscali.net!tornado.fastwebnet.it!53ab2750!not-for-mail
From: "Cerberus" <posta@postaposta.nu>
Newsgroups: free.it.visual-basic
Subject: connessione a dbf foxpro
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <G6j_b.6419$UI5.2892@tornado.fastwebnet.it>
Date: Mon, 23 Feb 2004 09:44:38 +0100
NNTP-Posting-Host: 39.2.159.66
X-Complaints-To: newsmaster@fastweb.it
X-Trace: tornado.fastwebnet.it 1077526054 39.2.159.66 (Mon, 23 Feb 2004 09:47:34 MET)
NNTP-Posting-Date: Mon, 23 Feb 2004 09:47:34 MET