Oracle Database Connection

K

KIKE

New Member
Hello guys,

I have to get a collection from Oracle Database, but I could not get it. I threw an error message 'OraOLEDB.Oracle' provider is not registered on the local machine. I followed the steps given on earlier post about this issue but I didn't get it. I'm not sure if the problem is because a lack of any driver or because of a wrong development. I show some screenshots.

Thank you very much
 

Attachments

  • Capture.PNG
    108.7 KB · Views: 111
  • Capture1.PNG
    71.1 KB · Views: 103
  • Capture2.PNG
    25.6 KB · Views: 83
K

KIKE

New Member
Hello guys,

Finally I could set the connection to Oracle Database but now i cannot get the output because I need to execute BEGIN k.session#.open_session; END; before running the SQL string. Does anyone know how to do that?
 
R

RobertJ

New Member
Elhamdouni,

The error listed in your attachment 1548234496922.png references SQL Server. I think you may be using the SQL Server VBO instead of the oleDB object which would be needed for Oracle.
 
Sukesh Kumaru

Sukesh Kumaru

Active Member
Hello,

Just check with the dbtable you are using in sql query whether it may looked by other user, Instead try to open another db.table which is free.

Good Luck.
 
You must log in or register to reply here.
Top