Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to setup sql connection to qlikview, I have oracle sql developer on my system. I have been told that I don't have Oracle plugin to make the connection. Can anybody please guide me of a way to do that? I have added the screenshot of the OLE DB Connect,
Also I have made an odbc connection and I am trying to run the following query but I keep getting an error "ODBC read failed" I am guessing it's the syntax. Can anybody please correct the query?
ODBC CONNECT TO [alpcisdd.corporate.com;DBQ=GSCMDMD] (XUserId is bZBOSGRINaXGVKBKMSUeFJdJcB, XPassword is MQMTCTWJdAWF);
GSL:
LOAD *;
SQL SELECT * FROM PRE_LDG.T_ARAVO_SUPPLIER_DETAILS_HIST S, PRE_LDG.T_ARAVO_LOCATION_DETAILS_HIST L WHERE s.GSL6=l.GSL6';
Thanks
It looks like your Oracle SQL has a lonely quotation mark:
SQL SELECT * FROM PRE_LDG.T_ARAVO_SUPPLIER_DETAILS_HIST S, PRE_LDG.T_ARAVO_LOCATION_DETAILS_HIST L WHERE s.GSL6=l.GSL6';
Shouldn't i be without the '
Or a beginning quote after the equal sign?
1. I have been told that I don't have Oracle plugin to make the connection. Can anybody please guide me of a way to do that?--ask admin team to help on this,they suppose to download and install.
U have to create ODBC connection from SYSTEM TAB not on USER TAB,hope tht's creating this issue and make sure abt ur machine is either 32/64 bit,accordingly u have to select ur drivers!
ODBC read failed
SQL SELECT * FROM PRE_LDG.T_ARAVO_SUPPLIER_DETAILS_HIST S, PRE_LDG.T_ARAVO_LOCATION_DETAILS_HIST L WHERE s.GSL6=l.GSL6
Hi Petter, I tried without that too, didnt work
Not sure if this is the problem, but you have mixed the case of the S & L table aliases:
SQL SELECT * FROM PRE_LDG.T_ARAVO_SUPPLIER_DETAILS_HIST S, PRE_LDG.T_ARAVO_LOCATION_DETAILS_HIST L WHERE S.GSL6=L.GSL6
Still didn't work Jonathan, good observation though
ODBC read failed
SQL SELECT * FROM PRE_LDG.T_ARAVO_SUPPLIER_DETAILS_HIST S, PRE_LDG.T_ARAVO_LOCATION_DETAILS_HIST L WHERE S.GSL6=L.GSL6
This is the driver you need most probably:
64-bit Oracle ODBC Driver 12.1.0.2.0
If you Google this:
oracle odac odbc 64-bit
You will come to Oracle Technology Network where you will find several different release of packages ~300 MB download containing the ODBC driver. To be able to do the download you will have to register there - but that is for
free.
are u tried the above suggested solution by me?
If you want to make sure that you are connected to Oracle you could just write this SQL and see if you get a result:
select sysdate from dual;
This should work on any Oracle database that you connect to since it only returns the sysdate (a function call) and referencing a dummy table called DUAL...
I am using Oracle 11.02.00.01, Oracle in OraClient11g_home1