Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mazacini
Creator III
Creator III

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

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?

7 Replies
prieper
Master II
Master II

If you wish to refer to an SQL-database (as the error-code looks like) you need to set up on ODBC-connection first. Suggest to consult the manual or try to use the wizard.

What happens if you try to load the second table as first?
If the above is all your code, surely the line FROM .... is wrong (no indication of file-type, parameters and the semicolon)

HTH
Peter

mazacini
Creator III
Creator III
Author

Hi Peter

Tried the second statement first, but same error.

As regards code, I do have the semicolon at the end of the line - the code for second table in fact follows that for first table, with no file-type indicator.

I'm sure my problem is with the ODBC connection as you suggest. I have to say I find this area very confusing.

I used the OLE DB wizard to set up a connection "Co 1" - this connects to the directory in which the target directory resides. I then use the ODBC option to select the specific table within the directory. This worked fine for my first table. (In fact, once I had connected, I eventually edited direct script for my LOAD and SELECT).

.........

I just tried another option. i started a new QVW file; set up a new connection to the same directory, this time called "Co 3". Used the ODBC option to SELECT my table; selected all fields, using "*".

However, when I run the edit script, I get the same error - maybe problem is with the particular table?

………

I reverted to my original QVW file, and, using the ODBC wizard, have successfully selected a number of different tables from the directory. (this time using just the SQL SELECT, rather than LOAD and SELECT).

It would seem that my coding is ok, and that my connection is ok, but that my problem is with the particular table I am using?

Sorry to lay all this on you, but I think it is worth being detailed for the sake of future readers.

To close, I would welcome any thoughts you might have on my problem table.

Joe

mazacini
Creator III
Creator III
Author

Deleted Duplicate Posting

mazacini
Creator III
Creator III
Author

Hi Peter

Not sure if this is relevant...

When I select a table using my ODBC wizard, the Fields in the table are normally listed after the * in the right hand section of the dialog box.

However, for my problem table, I can only see the * ie the individual fields are not listed.

There are 279 fields in the table.

Anything relevant here?

Joe

Miguel_Angel_Baeyens

Hello Joe,

Sounds like some 64 bit OS / QlikView version, 32 bit ODBC driver or some postgres error we already have seen here. It shouldn't happen if you are using QlikView 10, but it does when you use version 9. I'll check for those posts in the forum, search in google for

odbc 64 32 site:qlik.com
or something.

Hope this helps

mazacini
Creator III
Creator III
Author

Hi Miguel

Thanks for your message. I have to confess that this is too technical for me!

I am using version 10. I also don't understand how come I can connect to some tables in the directory but not connect to others. Would the problem you describe not be preventing connection to any table?

I checked out this topic, but it is also too technical! http://community.qlik.com/forums/p/31450/121077.aspx

i would appreciate any more assistance?

Joe

Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

Hello everyone

Having the same issue and tryin a lot of things i finally could find that the driver needed is the "Driver do Microsoft Visual Fox Pro" but you should specify when  create the DSN that there are Tables instead of BD and set the directory where the files .bdf are stored, so you can create the connection with QV using that DSN.