topic Problem with odbc connect in QlikView

Problem with odbc connect

samuel_frauenkn — Thu, 13 Feb 2014 16:39:56 GMT

Hi all,

till we have installed the releas 11.20 SR5 we have a Problem to make a Connection to the Database with ODBC.

Before the Installation the call in the script was:

ODBC CONNECT TO [xxxx]
If I let the script run, the QV asked me about my credentials for the connection. With the correct Username and Password the connection was ok.

Now, (on WindowsServer 2012 and QV 11.20 SR5) if I let the same script run, there comes an errormessage "Not enough information to log on ODBC CONNECT TO [xxxx]".

If I make the connection with this call: "ODBC CONNECT TO [xxxx] (XUserID Is nnnnConnection is correct.

Does any body know, why QV didn't ask me about my credentials anymore and how I can change that?

Thanks for your help!

Greets Samuel

P.S.: the Database is Teradata

Re: Problem with odbc connect

Mon, 28 Apr 2014 10:23:57 GMT

Hello,

I have installed 11.20 releas SR6, I'm trying to load data with ODBC and get stuck loading the first table. This is the sript:

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='h:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff]';
SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';
SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

ODBC CONNECT TO ORACLE_XE(XUserId is USER, XPassword is PASSWORD);
//-------- Start Multiple Select Statements ------
SQL SELECT COMM, DEPTNO, EMPNO, ENAME, HIREDATE, JOB, MGR, SAL FROM EMP;
SQL SELECT DEPTNO, DNAME, LOC FROM DEPT;
//-------- End Multiple Select Statements ------