Oracle Database Discussions

Hello everyone,

Apologies if this is the wrong forum for this.

I am attempting to use SQL Server to report on the Oracle XE database. I've configured initodbc.ora, listener.ora and tnsnames.ora.

I've tried to log in via SQL Plus using the following credentials: <h5>brian/0*****5@IFLPC45</h5>. However I get the aforementioned Ora 12537 error.

Here are my listener, init and tnsnames files:

-----
tnsnames.ora
<h5>
bEXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)



XE=
(DESCRIPTION =
(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.1.66)(PORT=1521)
)
(CONNECT_DATA =
(SERVICE_NAME=XE)
)
(HS=OK)
)

IFLPC45=
(DESCRIPTION =
(ADDRESS = (PROTOCOL=TCP)(HOST=IFLPC45)(PORT=1433)
)
(CONNECT_DATA =
(SERVICE_NAME=IFLPC45)
)
(HS=OK)
)
</h5>

-----
listener.ora
<h5>
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = HSODBC)
)
(SID_DESC =
(SID_NAME = IFLPC45)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = HSODBC)
)

)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.66)(PORT = 1521))
)
)
</h5>

-----
initodbc.ora
<h5>
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = IFLPC45
HS_FDS_TRACE_LEVEL = OFF


#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
</h5>

Any help would be greatly appreciated.

Thanks,

Brian