Help needed to connect to Oracle server?

Tue, 22 Nov 2011 19:12:22 GMT

I'm new to QV, cn some provide step by step approach to connect to Oracle db,

Instance name: oxxl

tried using the drivers built in QV, no success

~Eric

Help needed to connect to Oracle server?

swarup_malli — Tue, 22 Nov 2011 19:46:32 GMT

Steps for getting an ODBC connection to the YourDbName database on a local machine:

Get an Oracle client on your machine:

- First, go to the Oracle instant client download page (http://www.oracle.com/technetwork/topics/winsoft-085727.html) and download the ‘Instant Client Package – Basic’ – it’s the first one.

- Extract the contents of the downloaded zip file to C:\Oracle

Create a TNS names file:

- Copy the following text into a blank text file:

TNS Name=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1800))

)

(CONNECT_DATA =

(SERVICE_NAME = )

)

- Save this text file into the C:/Oracle/network/admin folder (create it if it doesn’t exist already), and name it tnsnames.ora (if you have a tnsnames.ora file already, add the copied text to the end of it.

- Go to ‘My Computer’ -> Properties -> Advanced -> Environment Variables, and under ‘User variables’, add a new variable with name TNS_ADMIN, and value ‘C:/Oracle/network/admin’ (or wherever your tnsnames.ora file is)

Create an ODBC Data Source:

- Go to Control Panel -> Data Sources (ODBC) -> System DSN, and click Add..

- Scroll to the bottom of the list and select ‘Oracle in instantclient_11_2’

- Create a data source

topic Help needed to connect to Oracle server? in QlikView

Help needed to connect to Oracle server?

Help needed to connect to Oracle server?