Hello,
i've connected Qlikview to Oracle database and everything worked perfect. But when i upload my application on a Qlikview Server and do a reload Qlikview tells me that it has some problems with connection. I've installed desktop version on server computer, and it works perfectly good. I'm connecting to Oracle 11g via ODBC. I've tried with checked Force 32 bit checkbox, and same mistake. My Qlikview version is 64 bit.
Here is a log file:
| 2014-07-02 09:39:50: | Execution started. |
| 2014-07-02 09:39:50: | QlikView Version:11.20.12354.0 |
| 2014-07-02 09:39:50: | CPU Target | x64 |
| 2014-07-02 09:39:50: | Operating System | Windows 7 Enterprise Service Pack 1 (64 bit edition) |
| 2014-07-02 09:39:50: | Wow64 mode | Not using Wow64 |
| 2014-07-02 09:39:50: | MDAC Version | 6.1.7601.17514 |
| 2014-07-02 09:39:50: | MDAC Full Install Version | 6.1.7601.17514 |
| 2014-07-02 09:39:50: | PreferredCompression | 2 |
| 2014-07-02 09:39:50: | EnableParallelReload | 1 |
| 2014-07-02 09:39:50: | ParallelizeQvdLoads | 1 |
| 2014-07-02 09:39:50: | AutoSaveAfterReload | 0 |
| 2014-07-02 09:39:50: | BackupBeforeReload | 0 |
| 2014-07-02 09:39:50: | EnableFlushLog | 0 |
| 2014-07-02 09:39:50: | SaveInfoWhenSavingFile | 0 |
| 2014-07-02 09:39:50: | UserLogfileCharset | 1200 |
| 2014-07-02 09:39:50: | OdbcLoginTimeout | -1 |
| 2014-07-02 09:39:50: | OdbcConnectionTimeout | -1 |
| 2014-07-02 09:39:50: | ScriptWantsDbWrite | false |
| 2014-07-02 09:39:50: | ScriptWantsExe | false |
| 2014-07-02 09:39:50: | LogFile CodePage Used: | 1200 |
| 2014-07-02 09:39:50: | Reload Executed By TPVM0C291E7E23\qlikview |
| 2014-07-02 09:39:50: | Process Executing: QVB |
| 2014-07-02 09:39:50: | Process ID: 4744 |
2014-07-02 09:39:50: 0002 SET ThousandSep=' '
2014-07-02 09:39:50: 0003 SET DecimalSep=','
2014-07-02 09:39:50: 0004 SET MoneyThousandSep=' '
2014-07-02 09:39:50: 0005 SET MoneyDecimalSep=','
2014-07-02 09:39:50: 0006 SET MoneyFormat='# ##0,00 zl;-# ##0,00 zl'
2014-07-02 09:39:50: 0007 SET TimeFormat='hh:mm:ss'
2014-07-02 09:39:50: 0008 SET DateFormat='YYYY-MM-DD'
2014-07-02 09:39:50: 0009 SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff]'
2014-07-02 09:39:50: 0010 SET MonthNames='sty;lut;mar;kwi;maj;cze;lip;sie;wrz;paź;lis;gru'
2014-07-02 09:39:50: 0011 SET DayNames='Pn;Wt;Śr;Cz;Pt;So;N'
2014-07-02 09:39:50: 0013 LET vDayVariable=(Timestamp(Now()-1/144,'YYYYMMDDhhmm'))
2014-07-02 09:39:50: 0014 LET vDayNowVariable=(Timestamp(Now(),'YYYYMMDDhhmm'))
2014-07-02 09:39:50: 0015 LET vMonth=if(Day(Today())<=5,Month(MakeDate(2014,Month(Today())-1,10)),Month(MakeDate(2014,Month(Today()),10)))
2014-07-02 09:39:50: 0016 LET vPreviousMonth=if(Day(Today())<=5,Month(MakeDate(2014,Month(Today())-2,10)),Month(MakeDate(2014,Month(Today())-1,10)))
2014-07-02 09:39:50: 0018 ODBC CONNECT32*XUserId*XPassword*
| 2014-07-02 09:39:51: | Error: SQL##f - SqlState: IM004, ErrorCode: 0, ErrorMsg: [Microsoft][Menedżer sterowników ODBC] Procedura SQLAllocHandle sterownika nie powiodła się na operacji SQL_HANDLE_ENV |
| 2014-07-02 09:39:51: | General Script Error |
| 2014-07-02 09:39:51: | Execution Failed |
| 2014-07-02 09:39:51: | Execution finished. |
thanks in advance,
Jacek Mossakowski
