Oracle Database Connection

[Sanskey]

Hello everybody!

I’m currently struggling with the Oracle database connection. I tried millions of combinations without any success. I’ve checked in the Control Panel -> Administrative Tools->Data Sources (ODBC)->The driver seems to be in place (showing Oracle in XE). From there I’ve also made a successful test connection to the database.

My whole script is currently:
Let>str=Driver={Oracle in XE};dbq=localhost:1521/XE;Uid=USER;Pwd=PASSWORD;
DBConnect>str,dbH
DBQuery>dbH,SELECT * FROM TABLE,rset,NumRecs,NumFields,0

According to connectionstrings.com I tried also

Driver=(Oracle in XEClient);dbq=localhost:1521/XE;Uid=USER;Pwd=PASSWORD;

I always end up with the info not having a valid connection.

Any idea how to get this done?

[Marcus Tettmar]

Before we try anything else can we confirm the following: Have you installed the 32 bit ODBC drivers? Macro Scheduler is 32 bit so you'd need the 32 bit version of the ODBC driver.

[Sanskey]

Hi Marcus,

I assume it is 32 Bit, because the Driver is called SQORA32.dll

Sandro

[Marcus Tettmar]

I believe both the 64 bit and 32 bit versions are called SQORA32.dll. It would be best to specifically download and install the 32 bit version to be sure.