PB with some Data_type importing with ODBC link in QLIKVIEW

bati_taf

Hello all,

I just began using the Personnal version of Qlikview.

I was able to connect my Qlikview with my Microsoft Navision Dynamics (which is in C/SIDE, native database) with the ODBC connector.

I also was able to import part of my data without problem (data type = Code)

My problem : for some fields who are in navision in these two formats, "Option" and "Text" it did not work:



When I tried to view data in Qlikview





When I import, I have no error message.



I have no data in Qlikview, whereas in the navision table I have data. I don't understand why?

I think I forgot to do something, I'm a beginner in Qlikview with ODBC connection.

I tested my odbc connector in Excel and It's working, I was able to have all data in all type of data (Text or Option).


Thanks in advance for your answer (and sorry if it's very simple, i searched on the web without success)

einsTeIn.NET

You have to be careful which version (32bit/64bit) of ODBC driver you use. Please have a look at your QlikView help (topic "connect"). There should be a table containing the connect statement you have to use depending on your current system setup.

bati_taf

Hello einsTeIn.NET,

Thanks for your answer. My server, and client are in 32bits, I used the 32 bits odbc driver.
I search in the QLIKVIEW HELP, and try to connect with connect32 option, for the same result.

Thanks for your help,

einsTeIn.NET

In your ODBC driver setup, what did you set-up in "Option Field Type" and in "Language"?

bati_taf

This is my configuration:



So strange, but in Excel when I use this ODBC driver i have no problem all is working (I can export data with type "TEXT", but in QLIKVIEW, it's not working (I can export all data except fiel whith data "TEXT"

Thanks,

einsTeIn.NET

Try to use Option Field Type Integer instead.

bati_taf

I tried with integer for the same result

einsTeIn.NET

Are you sure that you use the correct ODBC version for your database?
Maybe a restart helps to apply your settings?

bati_taf

Hello,

I try to reboot without more sucess, always the same problem.
I'm sure I used the good ODBC driver (NODBC V4.0 SP3). This driver work perfectly in Excel. I have only problem in Qlikview

einsTeIn.NET

Strange! We use it in NAV 3.60. No problem so far. Can't believe that it don't work in higher version. :-k I'll test it next week and give you a feedback.

einsTeIn.NET

For me it works like a charm. I can even use Type Text for Option Fields and it shows the correct equivalent.

Are you sure your NODBC driver has the same Build No. than your client? I use 23305.