topic 64 bit ODBC Problem in QlikView

64 bit ODBC Problem

Tue, 13 Jul 2010 09:10:53 GMT

Hi All;

i upload my screenshot blow there and my mproblem is i do not connect oracle database via ODBC
my pc is win 7(ultimate) OS and 64 bit. But in same OS in 32 bit i can connect to oracle DB via ODBC.
I set all configuration clearly i tested connection and it works correctly.
but in QV ODBC connection i see my user data source but i can not connect to my tables.

so i think it is about win 7 64 bit version...

Is any body can help me !!!

Thanks in Advance

64 bit ODBC Problem

Tue, 13 Jul 2010 09:47:33 GMT

Are you sure your ODBC connection is 64 bits ?

Did you set your TNSNAME.ora and SQL files correctly ?

To test it you can double check with Excel for example.

I'm able to make it work using Win 2003 64 Bits after installing the correct ODBC driver (64). So I guess this could be the issue..

Rgds,

Sébastien

64 bit ODBC Problem

colinh — Tue, 13 Jul 2010 10:22:18 GMT

You can find the 64 bit Oracle 10g Client here: http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winx64soft.html

If your database is earlier than 9i you might have a problem. I could not find a 64 bit driver that would work with Oracle 8.0.5 and the 32 bit driver would not work with QlikView, either 32 bit or 64 bit, installed on a 64 bit machine. I resorted to extracting on a 32 bit machine and copying the QVDs to the 64 bit machine with a scheduled batch file.

Good luck...

64 bit ODBC Problem

Tue, 13 Jul 2010 10:26:48 GMT

There is the option to install the 32 bits Driver and install Qlikview Developper 32 bits on your server.

Then you create the qvds using a batch.

Rgds,

Sébastien

64 bit ODBC Problem

tatengue — Fri, 22 Oct 2010 14:11:43 GMT

Hi Selcuk,

I have the same problem with ORACLE ODBC DRIVER 64 bit

How resolve this issue?

Regards.

Enrique.

64 bit ODBC Problem

Mon, 25 Oct 2010 07:42:28 GMT

Hi;

I just saw your post.

Firstly i reinstalled my oracle client

In my PC (Dell Win7 64bit), ODBC Data Source Administrator is in different folder.

I found ODBC Data Source Administrator in this path: C:\Windows\SysWOW64\odbcad32.exe

redefine my data source then the problem is over.

If something obsess you, please ask me...

Best Regards...

64 bit ODBC Problem

Miguel_Angel_Baeyens — Mon, 25 Oct 2010 08:12:28 GMT

Hello Selcuk,

In addition to this, if you are using QV version 9, you will need to have both 64 and 32 bits versions installed, since in QV 9 64 you cannot access to 32 bit ODBC sources and otherwise.

Installations can coexist if you install them in different folders.

Regards.

64 bit ODBC Problem

Tue, 18 Jan 2011 22:41:23 GMT

Hi, How did you redifine? I have the same problem. 64 bit odbc drivers are not seen through 32 bit odbc programs. I have to odbc programs as follows.

C:\WiNNT\SysWOW64\odbcad32.exe - 32 bit drivers

C:\WINNT\system32\odbcad32.exe - 64 bit drivers.

I am unable to load using publisher.It gives following error

Failed to read ScriptErrorCount. Exception=System.NullReferenceException: Object reference not set to an instance of an object.
at QVBWrapper.Document.Reload(ILogBucket i_LogBucket, Boolean i_MonitorQVBCPUUsage, Boolean i_Partial, Boolean i_ReadDocumentLog)
The Source Document was NOT reloaded successfully.

Reload failed.
Reload failed. Distribution skipped.
The task "db_conn" failed. ErrorCount=4