I'm doing queries on .dbf files.
When I have 5 inner join clause
there is this error

-2147467259 (80004005)
[Microsoft][ ODBC dbase Driver ] Unexpected error from external database driver
If I run this query in Acces or in Paradox there's no problem and the data comes out (select statement)

I tried two connection strings
conADO.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=""DSN=dBASE Files;DBQ=" & strDatabaseImos & ";DefaultDir=" & strDatabase & ";DriverId=533;MaxBufferSize=2048;PageTimeout= 5;"" "

and this one
conADO.ConnectionString = "Driver={Microsoft dBASE Driver (*.dbf)}; DriverID=277; Dbq=" & strDatabase & ";"


the same error came out.

I look in google and msdn and find nothing interresting.
Somebody got an idea ? or need more information ?

What kind of DB is it? I know that some .dbf files only allow an ODBC connection if the number of fields in the table is less than 255. This criteria may also include Joins...so if the sum of all the fields in your joined tables is greater than 255, you may see a problem...This is just a shot in the dark.

Foxpro (if dos version or below 3.0) does not support mulitple join queries.