Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Dimitris Chrysomallis 21 posts 73 karma points
    Apr 13, 2011 @ 14:40
    Dimitris Chrysomallis
    0

    Setting OLEDB DataSource for Oracle gives NullReferenceException

    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:

    • Object reference not set to an instance of an object.

    Is this a known issue?

     

    Thank you

     

  • Comment author was deleted

    Apr 13, 2011 @ 14:42

    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, ..)?

  • Dimitris Chrysomallis 21 posts 73 karma points
    Apr 13, 2011 @ 15:13
    Dimitris Chrysomallis
    0

    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.

  • Comment author was deleted

    Apr 13, 2011 @ 15:25

    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

  • Dimitris Chrysomallis 21 posts 73 karma points
    Apr 13, 2011 @ 15:52
    Dimitris Chrysomallis
    0

    Ok then!

    Thank you very much.

    Dimitris

Please Sign in or register to post replies

Write your reply to:

Draft