Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

File .DBF still not working...

Hi everybody,

I'm trying to load a .DBF file on a project, but with http://community.qlik.com/forums/t/20045.aspx I've this error:

SQL Error:[Microsoft][Driver ODBC dBase] Il modulo di gestione di database Microsoft Jet non è riuscito a trovare l'oggetto 'PG45010000910'. Assicurarsi che l'oggetto esista e che il nome e il percorso siano digitati correttamente.

SQL Scriptline:

SQL State:S0002

SQL SELECT *

FROM `C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\DESKTOP`\PG45010000910

and with http://community.qlik.com/forums/t/27496.aspx I have:

ODBC read failed
SQL SELECT *
FROM pg45010000910

but the strange thing is that with the tool "building the select instruction" I'm able to see the file content as shown in picture:

error loading image

I've to underline that i can see everything with MsExcel...

Anybody can help me?

Thanks in advance.

Marco

3 Replies
Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

Hello m.paoltroni

Have you tried using the driver "Driver do Microsoft Visual Fox Pro" BUT 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.

Regards!

richard
Partner - Creator
Partner - Creator

Ciao m.paoltroni,

Download the FoxPro ODBC driver here

http://msdn.microsoft.com/en-us/vfoxpro/bb190233

Install it and then use the ODBC CONNECT32 statement in you Qlikview script.

andriesb
Creator II
Creator II

I normally test my ODBC links- extraction with Excel using the MS Query (load external data). In this way you have another testin option outside of qlikview just to verify your odbc connection.

ODBC driver in use was Microsft access dBase Driver.

I also had to add, on 64 bit OS server (and 64b pc), my odbc driver manager using the 64 bit odbc utility ( C:\Windows\SysWOW64\odbcad32.exe ).