Connecting to a FoxPro DBF file
From: Duncan (ddimech_at_ads.com.mt)
Date: 11/22/04
- Next message: Jens Geyer: "Re: ADO Installation"
- Previous message: DCB: "Changing an Access query using VC++"
- Next in thread: Veign: "Re: Connecting to a FoxPro DBF file"
- Reply: Veign: "Re: Connecting to a FoxPro DBF file"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 22 Nov 2004 16:09:23 +0100
Dear All,
I have designed a routine inVB 6 which opens the data from a FoxPro DBF
file, does some manipulation and saves it in an SQL Database
This work fine on the machine it was designed on but when it was installed
on two oth machines it started to give the following error: -
-2147217865 [Microsoft][ODBC Visual FoxPro Driver]File 'client.dbf' does not
exist.
The connection string used is :-
Set DBS_SB = New ADODB.Connection
DBS_SB.Open "UID=;PWD=;SourceDB=" & FilePath &
";SourceType=DBF;Driver={Microsoft Visual FoxPro
Driver};Exclusive=No;BackgroundFetch=Yes;Collate=Machine;"
Set ADO_SB = New ADODB.Recordset
ADO_SB.Open "select * from CLIENT", DBS_SB
and the error appears when the recordset is opened
and the file does exist and it is not corrupted
Thanks and Regards
Duncan
- Next message: Jens Geyer: "Re: ADO Installation"
- Previous message: DCB: "Changing an Access query using VC++"
- Next in thread: Veign: "Re: Connecting to a FoxPro DBF file"
- Reply: Veign: "Re: Connecting to a FoxPro DBF file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
