topic Re: ODBC connection suddenly doesn't work in QlikView

ODBC connection suddenly doesn't work

Tue, 13 Sep 2016 12:39:42 GMT

Hi,

i have a QVD generator that through a ODBC connection reads from a database and stores in to r-.qvds. This has been working for a year, now suddenly it doesn't?

see attached for the error message: Invalid object name thats just crazy when it's been working everyday for the past half year.

Anyway to debug or find what's been going wrong here?

Re: ODBC connection suddenly doesn't work

stabben23 — Tue, 13 Sep 2016 12:45:37 GMT

Hi,

have there been some password changes for the user who read from SQL?

Can you Connect or Select from Your script to the database?

Re: ODBC connection suddenly doesn't work

tracysmart — Tue, 13 Sep 2016 12:47:09 GMT

It might sound like an obvious question but have you checked the database to make sure that the table hasn't been renamed/deleted and ruled that out first?

Re: ODBC connection suddenly doesn't work

Tue, 13 Sep 2016 13:46:57 GMT

Staffan, Actually now that you ar ementioning this. I have changed my AD password upon automatic request from our system. But qlikview is running on an external server which has its own log ins.

Re: ODBC connection suddenly doesn't work

Tue, 13 Sep 2016 13:47:21 GMT

Yes ofcourse. Nothing like that

Re: ODBC connection suddenly doesn't work

miguelbraga — Tue, 13 Sep 2016 13:59:30 GMT

Hey there,

Try creating another QVW and try to access your database from the new app. There might be a possibility that your database have become corrupt and/or changed the location by another user. Please let us know what is happening...

Regards,

Re: ODBC connection suddenly doesn't work

rupamjyotidas — Tue, 13 Sep 2016 14:10:41 GMT

Hope the database is not upgraded to 64 bit and your connector to database is 32 bit.

Re: ODBC connection suddenly doesn't work

krishnacbe — Tue, 13 Sep 2016 14:15:41 GMT

To check the access stuffs you can connect to SQL server using the functional ID or if you do not have SQL server try to connect through OLEDB.

If connection is fine and only issue with table you need to contact the SQL administrator.

Re: ODBC connection suddenly doesn't work

stabben23 — Wed, 14 Sep 2016 05:34:55 GMT

Ok, check Your connectionstring and see so its not Your user thats Connect to the database. Also check the user on qlikview server, make sure that this account have password never expired.

Re: ODBC connection suddenly doesn't work

Anonymous — Mon, 30 Jan 2017 11:37:01 GMT

Hi Niklas!

I had the same prbolem , and i tell you how i solved it.

Well my problem was with the connection ODBC in oracle

i just selected OLE DB and i checked the "Forced 32 Bit" chek box. And then it worked .. wierd but its how it work for me.

Cheers.