Not getting numeric data when trying to connect an odbc resource

[muhammadraza]

Hello Guys,

I have connected Tally ERP with Qlikview via ODBC, the problem is that I am not getting numeric data and only getting Text data. The table name is Ledger and all field in this table are varchar.

I am getting everything when I use some third party odbc connector tool to get the data from the resource (as shown below)

But when I use Qlikview to retrieve the data

It displays everything except the data which is numeric.

Please guide what can be the issue.

Best Regards,

Muhammad Raza

[hic]

The SELECT statement is evaluated by the ODBC driver and not by QlikView. In my experience, QlikView always shows what it gets from the ODBC driver, so I suspect there is something wrong with the parameters of the ODBC data source.

What do you see when you create your SELECT statement? Can you see the values then? See picture below.

HIC

[muhammadraza]

Actually I am not able to see the preview because when I try to see the (selected) columns preview I get some error from Tally which actually closes the ODBC connection.

Besides ODBC connector tool we are also able to connect this ODBC from excel and see the numbers as well as the text, but it is only creating problem with the Qlikview.

[muhammadraza · Accepted solution]

I have solved this problem by connecting through OLE DB (32 bit) instead of ODBC (32 bit)

//ODBC CONNECT32 TO TallyODBC_9000;

OLEDB CONNECT32 TO [Provider=MSDASQL.1;Persist Security Info=False;Data Source=TallyODBC_9000;Extended Properties=""];