Failed to create DNS with ODBC Datadirect Driver - error missing or invalid option

2617972

Dear All,

I tried to post a first time and get my post thrown away. So please just tell me if that's not the place to post such questions. I tried this forum because I didn't find any revelant information yet on internet.

I installed Informatica and Oracle 11g, tried to create my DSN with the Driver DataDirect Oracle Wire Protocol. I keep bumping into the message " [Informatica][ODBC Oracle wire protocol driver][Oracle] ora-00922: missing or invalid option".

Can you please help to understand where the error comes from?

Here are my current status :

* My table in the Oracle database is created with every field followed by NOT NULL option, the table is successfully created.

* The connection to the Oracle database using Oracle TNSNames Connection server name and TNSNames files seem to work, I tried to connect with another driver Oracle in OraDB 11g_home1. This one succeeds.

* Listener.ora:

# listener.ora Network Configuration File: C:\app\ql186003\product\11.2.0\dbhome_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = C:\app\ql186003\product\11.2.0\dbhome_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\ql186003\product\11.2.0\dbhome_1\bin\oraclr11.dll")

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    )

  )

ADR_BASE_LISTENER = C:\app\ql186003

* Running lsnrctl STATUS:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

Start Date                22-FEB-2014 21:43:22

Uptime                    0 days 1 hr. 8 min. 33 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   C:\app\ql186003\product\11.2.0\dbhome_1\network\admin\listener.ora

Listener Log File         c:\app\ql186003\diag\tnslsnr\WBEQL186003-Q4G\listener\alert\log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Services Summary...

Service "CLRExtProc" has 1 instance(s).

  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "TESTDBXDB" has 1 instance(s).

  Instance "testdb", status READY, has 1 handler(s) for this service...

Service "TEST_DB" has 1 instance(s).

  Instance "testdb", status READY, has 1 handler(s) for this service...

Service "orcl.TD.TERADATA.COM" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclXDB.TD.TERADATA.COM" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

Thank you very much for any guidance.

Qiong