Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
beanmachine
Contributor III
Contributor III

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?