Re: DBF WITH EXTENSION OTHER THAN .DBF ( I.E. DAT )
- From: "Herbert" <Herbert@xxxxxxxxxxx>
- Date: Sat, 29 Oct 2005 19:07:34 -0300
I use TADOQuery for open table1.dat without problem, I put an example at
the botom,
my problem is How I can to make for the tables in the SELECT use the index
files table1.ind and
table2.ind ?
for example
SELECT * FROM table1.dat, table2.dat
WHERE table1.field1 = table2.field2
If I not use the indexed file the query get long time
Thanks
---------------------------
FOR DBF WITH EXTENSION OTHER THAN .DBF ( I.E. DAT )
I set 2 properties
1- ConnectionString=
Provider=MSDASQL.1;Persist Security Info=False;Data Source=Visual FoxPro
Tables;Extended Properties="DSN=Visual FoxPro Tables;UID=;
(here are the directory) !!!!!!!!!!!!!!!!
SourceDB=e:\42;
SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=No;Dele
ted=No;"
2- SQL= SELECT * FROM table1.dat
---------------------------
"michael" <mgoh_id@xxxxxxxxxxx> escribió en el mensaje
news:430c6581@xxxxxxxxxxxxxxxxxxxxxxxxx
> Dear All,
>
> I have few dbase files from older application. They are using .dat as the
> extension.
> If I rename the file to dbf and using odbc or jet 4.0 ( ole ) I managed to
> open connection and read table as it is.
> The problem is to make it compatible with older application.
>
> I read in MSDN about Jet 4.0, It is saying that with the previous version
of
> Jet 4.0, it is allowed to read dbase file with extension other than .dbf
> Due to security measure, it has been disallowed
>
> The Problem is :
> I have to read .dat as it is w/o renaming the file due to it might be used
> when reading the file.
> Copying before renaming might be my last effort, as I prefer to be real
time
> rather than copying the file.
>
> Is there some way to get around this problem ?
>
> Thanks
>
> Regards
>
> Michael
>
>
.
- Prev by Date: Re: Pb while closing ADO query
- Next by Date: ARITHABORT problem
- Previous by thread: Pb while closing ADO query
- Next by thread: ARITHABORT problem
- Index(es):
Relevant Pages
|
