index to foxpro files

[ray well]

i need to access a legacy database that uses dBase files running under
foxpro for read only purposes, within net 2.0, ado 2.0 using vb and sql
statements. i have no problem getting the info i need, but it is very slow.
i'm not using any indexes which the databases have, *.idx files, i don't
know how to access them.

the connection string i use is:

DBFConnedction = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=dBASE
IV;User ID=Admin;Password=;Data Source=""M:\Names\""

M is a network drive, Names is the folder name where the databases are.

how do i make my data access go thru the indexes, do i change the connection
string, or the sql statement, or something else? i would appreciate a code
snippet.

thanks

ray

[aaron.kempf]

just use SQL Server you friggin NooB


On Mar 6, 8:01 am, "ray well" <[e-mail]:

i need to access a legacy database that uses dBase files running under
foxpro for read only purposes, within net 2.0, ado 2.0 using vb and sql
statements. i have no problem getting the info i need, but it is very slow.
i'm not using any indexes which the databases have, *.idx files, i don't
know how to access them.

the connection string i use is:

DBFConnedction = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=dBASE
IV;User ID=Admin;Password=;Data Source=""M:\Names\""

M is a network drive, Names is the folder name where the databases are.

how do i make my data access go thru the indexes, do i change the connection
string, or the sql statement, or something else? i would appreciate a code
snippet.

thanks

ray