topic ODBC read fails in QlikView

ODBC read fails

Fri, 21 May 2010 16:50:27 GMT

Hello,

I am facing a strange problem. I am connecting to my microsoft sql server using ODBC and the connection is successful. I am able to select tables and am able to see the data in the table rows and columns. But when I save and load, the read fails giving me an error

ODBC read failed
SQL SELECT *
FROM "TMS_Data".dbo.billingterms

Can someone help on what's going on?

regards,

Manoj Agrawal

ODBC read fails

disqr_rm — Fri, 21 May 2010 17:34:18 GMT

I have seen this sometimes. You may need to close the QV completely, exit out and restart app and it should be fine.

ODBC read fails

Fri, 21 May 2010 17:58:48 GMT

Hi Rakesh,

Thanks for the reply. However, it has been happening ever since that I have been trying fetch the data from this table and it's been couple of days now. Every time the connection is successful, i can see the tables as well as data yet the read fails.

regards,

Manoj Agrawal

ODBC read fails

Fri, 21 May 2010 18:51:10 GMT

Found a solution. Just removed 'ODBC' from the connection string so that it uses OLE DB as default. Reads the data now.

thanks,

ODBC read fails

Wed, 02 Jun 2010 14:47:23 GMT

Hi Manoj,

I'm not sure if this has been resolved for you, and I don't have an answer. I have a similar problem. I think mine stems from using an ODBC driver on my 32-bit development environment calling a stored procedure on SQL Server 2008 64-bit. We just went through a migration from SQL Server 2000 32 bit to SQL Server 2008 64-bit. All of my stored procedures that were written prior to the migration work fine, but a new one is not. I can run it in the Management Studio just fine, but I get a ODBC Read Error in QlikView. I think it has something to do with when the stored procedures were compiled. Our technicians restored a backup from the SQL Server 2000 to the SQL Server 2008. I think in doing it that way the old stored procedures weren't recompiled. I did some digging and found SQL error codes, but they don't have a Read Error. So is this issue an ODBC issue or a QlikView issue?

Here's the link to SQL error Codes.

Allen

ODBC read fails

Wed, 02 Jun 2010 15:27:19 GMT

Allen,

As mentioned in my previous post, yes I got it working. Deleted the work 'ODBC' from the connection string so that it uses OLE DB connect by default.

So now my connection string reads

CONNECT TO WEBTMS etc. etc etc.

instead of

ODBC CONNECT to WEBTMS etc etc etc

regards,

ODBC read fails

Mon, 12 Jul 2010 02:03:20 GMT

Hi,

I also have the same problem and have tried removing the 'ODBC' but still get the same issue, well 'OLEDB Read Failed'

I'm trying to connect to a MS Access db that I suspect is corrupt?

Any ideas?

ODBC read fails

suniljain — Mon, 12 Jul 2010 14:56:27 GMT

Can give me script which you write for save and load.

ODBC read fails

Mon, 12 Jul 2010 23:45:32 GMT

Thanks but I have solved it. The access database I was connecting to seemed to have got corrupted. I went back to the previous backup and now everything works ok. The funny thing was I could open the queries in Access but I guess it must've had something to do with the way Access provides data to other programs

ODBC read fails

mike_garcia — Tue, 13 Jul 2010 00:22:02 GMT

The exact same behavior is seen when the user and password are not embedded in the connection string. When you connect to the ODBC/OLEDB and dont type the password in the first window (Called Connect To DataSource) but rather in a subsequent window asking specifically for the user and password, it will not be embedded and you WILL be able to select the tables and all (because you just typed the credentials), but when trying to reload, since it has no password to communicate with the source, it will fail.

Mike.

ODBC read fails

suniljain — Tue, 20 Jul 2010 13:59:58 GMT

Dear Manoj ,

pls Try with OLEDB , it will work fine in my case.

Regards,

Sunil Jain.

Re: ODBC read fails

Sat, 20 Oct 2012 07:58:40 GMT

I took this error ,

if you take scritp in db , your colomn name musn't similar , you have to give alias this column.

select

a.name,

b.name ,

a.aaa,

b.dfdfd,

b.aaa

from a ,b;

Re: ODBC read fails

Tue, 23 Oct 2012 20:27:31 GMT

In my case, the problem was the column name length.