OLEDB Not working with v9

[#1]

We have been testing QV 8.5) for 2 weeks, this moning we installed our first offical v9 licensie.

But the apps we developped, of even a total new one, can't use the OLEDB connecter to a SQL Server 2008 database. It finally sees the fields as defined in the query, but no data can be transferred, i'm only getting an error message OLEDB Read Failed.

Anybody has seen this behaviour before ?

[#2]

Anybody a suggestion , this is blockig me completelly .....

[#3]

More investigations ...

Think this is stuff for QlikTech technical people.

Only happens with the x64 version !! strange thing is thar the build of the query the generation of the select with the button works fine, but when you execute the query .. Then you get this error.

How can we send a budreport to QlikTech ??

[sathishkumar_go]

Hi Harry,

Check Username and Password for DB Access.

-Sathish

[rwunderlich]

Harry Leboeuf wrote:How can we send a budreport to QlikTech ??

Harry,

The support link is not very easy to find on the web site at the moment. Try this one:

http://www.qlik.com/formpage.aspx?id=1500

-Rob

[#6]

I've had similar problems connecting to various databases. Make sure to input a specific username and password for that database you are connecting to. I find that you are able to preview the tables without inputting a username and password, but on reload it will fail.

[#7]

I'm working with windows authentication (SqlServer2008), so the problem won't be username and password.

Normally i never use the Sql Statement builder that is in a soft (i'm writing sql for over 15 years now), but here i tested it in order to find out what coudl be wrong. That's fully operational, seeing all my tables/schema's. After the reload is done, i'm having no data but i'm having the right columns names ....

I'm passing it to TechSupport.

[#8 · Accepted solution]

That to Support i've found the problem.

The Microsoft OLEDB driver for SqlServer works fine. Both 'Sql Native Client' drivers (2008,2008) fail to work in the QV64 version for fetching data. Building queries and connecting work fine.

Strange but good to know.

[#9]

Hello,

i have the same issue you had (QV9 on x64 windows 2003 server and SQL Server native client)

Did you solve the problem ?

thank you

Richard