Hi,

I have a nice SQL Connection wit ah Oracle DB.
With the Connection Wizzard I was able to declare an ODBC connection to the DB :

DRIVER={Oracle dans OraDb10g_home1};UID=SYS;PWD=******** as sysdba;DBQ=TELEG1P;DBA=R;

When I test the connection it is succesful.

But when I try to use this connection in a task, I get this error message :

"Exception in Task: The connection has been disabled."

The DB is MOUNTED, not OPEN. As sysdba one can connect to a DB even if it is not OPEN.

Thank you for your kind help.

Christian

Is the SQL explorer working? I mean, can you enter queries there?

---

Hi Henrik !

Sorry for the delay in the answer, I have not received notification that you updated my thread. Under SQL explorer, when I double click on the connection to the database, I get this windows message titled "System.ArgumentNullException" : "Value cannot be null. Parametername:server version Database Objects".

Thank you for your kind help.

Christian

Could you take a screenshot of that error?

---

Please using the Oracle Direct instead of ODBC.

---