Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
maneshkhottcpl
Contributor III

MS SQL ODBC data read fail error

Hi Friends,

I am getting the error while pulling the data from MS sql server 2005. The description of error as follows.

I have data server with Ms sql 2005 (32 bit) and m pulling the data from development server having qv 9.0 and MS sql 2008 (64 bit). I  am abale to create the dsn of sql server successfully. But when i m trying to pull the data  using dsn with qlikview its showing the error "ODBC read fail" error.

The error is arrieses if i try to pull single field too.

Please help me to resolve this issue.

Thank in Advance

Manesh Khot

2 Replies
danielrozental
Honored Contributor II

MS SQL ODBC data read fail error

You should look into adding the "with nolocks" statement to your selects.

Sokkorn
Honored Contributor

MS SQL ODBC data read fail error

Hi Manesh,

Check in check box (Force 32 bit) under ODBC connection.

Regards,

Sokkorn

Community Browser