Oracle SQL Developer Connection

[Anonymous]

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

[petter]

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?

[buzzy996]

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!

[Anonymous]

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

[jonathandienst]

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

[Anonymous]

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

[petter]

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.

[buzzy996]

are u tried the above suggested solution by me?

[petter]

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

[Anonymous]

I am using Oracle 11.02.00.01, Oracle in OraClient11g_home1