Qlikview Server and Oracle ODBC, problem with connection!

Fri, 20 Nov 2020 18:02:30 GMT

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

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

beanmachine — Mon, 31 Aug 2015 08:22:35 GMT

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?

topic Qlikview Server and Oracle ODBC, problem with connection! in QlikView

Qlikview Server and Oracle ODBC, problem with connection!

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