topic Re: odbc connection failed? in QlikView

odbc connection failed?

Tue, 04 Nov 2014 08:01:44 GMT

Hi experts,

i have a qvw and when i try reload i am getting error ODBC connection failed , if i skip that error then next i am getting table field not found .

but same application in same server if i tried from some other pc its working fine what is the problem here?

Re: odbc connection failed?

Peter_Cammaert — Tue, 04 Nov 2014 08:04:38 GMT

Can you post the exact wording of the ODBC failure message? Otherwise it'll be guesswork. An ODBC connection can fail because of a missing definition, lack of privileges, a wrong userid / password, and even maybe because you're trying to use a 32-bit definition while the actual definition resides in the 64-bit list.

Peter

Re: odbc connection failed?

Tue, 04 Nov 2014 08:08:05 GMT

getting error like

odbc connection failed

sql select a.tablesppacename,

where tablespacename=1 .......order by 1

Re: odbc connection failed?

jagan — Tue, 04 Nov 2014 08:15:46 GMT

Hi,

Did you have valid ODBC driver created in your machine? Try to create the new ODBC datasource and check whether you are able to connect?

I think the issue is with ODBC, whether it is not there in your machine or it is wrongly configured.

Regards,

jagan.

Re: odbc connection failed?

Tue, 04 Nov 2014 08:18:54 GMT

Hi jagan ,

how to identify valid odbc driver or not ?

Re: odbc connection failed?

jagan — Tue, 04 Nov 2014 08:21:17 GMT

Hi,

Check there is ODBC in your machine

Control Panel -> Administrative Tools -> DataSources (ODBC) and check the one which you are using is exists in this.

Regards,

jagan.

Re: odbc connection failed?

ashfaq_haseeb — Tue, 04 Nov 2014 08:24:10 GMT

Hi,

After you make ODBC connection, did you connected successfully?

Did you test that?

Regards

ASHFAQ

Re: odbc connection failed?

Tue, 04 Nov 2014 08:26:54 GMT

i can see there odbc is avaliable here

Re: odbc connection failed?

jagan — Tue, 04 Nov 2014 08:32:17 GMT

Hi,

check this

ODBC CONNECT TO ODBCDriverName (XUserId is testuser, XPassword is testpwd);

Check ODBCDriverName is exists in that screen, if not then you have create it with server, database.

Regards,

Jagan.

Re: odbc connection failed?

Peter_Cammaert — Tue, 04 Nov 2014 08:47:11 GMT

Enable the Document Log in your QlikView application (see Settings->Document Properties->General->Generate Logfile), save and reload. A text file will be generated that contains the message your ODBC drivers returns upon failure.

Please post the log file.

Peter

Re: odbc connection failed?

Tue, 04 Nov 2014 09:33:32 GMT

in that log file i can see

odbc connection failed

general script error

Re: odbc connection failed?

avinashelite — Tue, 04 Nov 2014 09:45:29 GMT

Hi Manoj,

Create a new connection with the same username and password, then test the connection if succeeds then username ,password, data source are correct then you will be able to connect. Otherwise check with the username and password

Re: odbc connection failed?

jagan — Tue, 04 Nov 2014 09:52:00 GMT

Hi,

Create a new ODBC datasource and Test Connection works in that wizard itself.

Regards,

jagan.

Re: odbc connection failed?

Wed, 19 Nov 2014 06:08:40 GMT

me to had the same issue, the mistake what i have done is i had placed the data connection tab(Main tab) in second position where my first tab(Data tab) loads data from data source.

Since in Qlikview execution takes place from tab left to right i rearranged the tab (i.e) placed main tab as first and it works like a charm...