odbc connection failed?

[#1]

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?

[Peter_Cammaert]

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

[#3]

getting error like

odbc connection failed

sql select a.tablesppacename,

.

.

.

.

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

[jagan · Accepted solution]

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.

[#5]

Hi jagan ,

how to identify valid odbc driver or not ?

[jagan]

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.

[ashfaq_haseeb]

Hi,

After you make ODBC connection, did you connected successfully?

Did you test that?

Regards

ASHFAQ

[#8]

i can see there odbc is avaliable  here

[jagan]

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.

[Peter_Cammaert]

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