Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_frauenkn
Contributor
Contributor

Problem with odbc connect

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

1 Reply
Not applicable

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 ------