Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Posts
    8

    Unanswered: can't solve weird ODBC dbase Driver error

    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 ?

  2. #2
    Join Date
    Jan 2004
    Posts
    1

    Re: can't solve weird ODBC dbase Driver error

    Originally posted by stauf
    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 ?

  3. #3
    Join Date
    Nov 2003
    Posts
    9

    Re: can't solve weird ODBC dbase Driver error

    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.

  4. #4
    Join Date
    Mar 2004
    Posts
    8

    Re: can't solve weird ODBC dbase Driver error

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


    Originally posted by stauf
    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 ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •