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..
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.
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...
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. Distribution skipped.
The task "db_conn" failed. ErrorCount=4