7 Replies Latest reply: Mar 27, 2012 6:18 PM by Emmanuelle Bustos RSS

    SECOND SELECT STATEMENT: "Unexpected error from external database driver (8961)"

    Joe Kirwan

      Firstly, I am a QlikView newbie and also only starting out on SQL!

      I have used the Edit Script to connect to a .dbf table. I structured LOAD and SELECT statements (as per http://community.qlik.com/forums/t/36463.aspx) and succesfully pulled in the data from the .dbf table.

      Now I want to load data from a second table within the same directory.

      Using the same LOAD and SELECT structure, I compiled my script, referring to the fields in my new table.

      When I execute my script, it loads the data from the first table correctly as before, but then I get my "Script Error":

      SQL##f - SqlState: S1000, ErrorCode: 4294962280, ErrorMsg: [Microsoft][ODBC dBase Driver] Unexpected error from external database driver (8961).
      SELECT
      CODE as ACCCODE,
      NAME

      FROM C:\INTLOCAL\COMPANY1\CUSTS

      where CUSTS is the second table name.

      Can anyone help?