Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Hello,
We are trying to connect to an oracle db through oledb:
Provider=MSDAORA.1;Data Source=OracleDataSource;Password=password;User ID=userid
The error is:
Is this a known issue?
Thank you
Comment author was deleted
Hi Dimitris,
Well we haven't tested with an oracle db, and the error message doesn't provide a lot of details.
Did you set the rest of the settings (table name, ..)?
Hi Tim,
Yes I did set a tablename. It seems to make a connection, since if I set a bogus table name I get an oracle error:
Table does not exist. ORA-00942: table or view does not exist
With prevalue sources I get a different oracle error:
One or more errors occurred during processing of command. ORA-00923: FROM keyword not found where expected
Also, I'm on umbraco 4.6.1 and contour version 1.1.5.
OLEDB Connections to sql server work as expected.
I'm affraid that oracle isn't supported then.
What you could do is write your own custom prevaluesource and datasource type since it seems to default ones can't deal with oracle
You can find the sourcecode for the default providers here: http://our.umbraco.org/projects/developer-tools/umbraco-contour-shared-source
Ok then!
Thank you very much.
Dimitris
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
Setting OLEDB DataSource for Oracle gives NullReferenceException
Hello,
We are trying to connect to an oracle db through oledb:
The error is:
Is this a known issue?
Thank you
Comment author was deleted
Hi Dimitris,
Well we haven't tested with an oracle db, and the error message doesn't provide a lot of details.
Did you set the rest of the settings (table name, ..)?
Hi Tim,
Yes I did set a tablename. It seems to make a connection, since if I set a bogus table name I get an oracle error:
With prevalue sources I get a different oracle error:
Also, I'm on umbraco 4.6.1 and contour version 1.1.5.
OLEDB Connections to sql server work as expected.
Comment author was deleted
Hi Dimitris,
I'm affraid that oracle isn't supported then.
What you could do is write your own custom prevaluesource and datasource type since it seems to default ones can't deal with oracle
You can find the sourcecode for the default providers here: http://our.umbraco.org/projects/developer-tools/umbraco-contour-shared-source
Ok then!
Thank you very much.
Dimitris
is working on a reply...