Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Qlikview Server and Oracle ODBC, problem with connection!

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

1 Reply
New Contributor III

Re: Qlikview Server and Oracle ODBC, problem with connection!

Is your ODBC DSN a user or a system one?  If it is a user one it will work for you but when the server tries it, it may well be using a different account (as setup in the QV services) and the DSN may not exist for that account.  If that is the case, setup your DSN as a system one.  Or, the server user may not have the correct permissions to the Oracle database?