Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 9i connection string with SYS account
You'll have to set "O7_DICTIONARY_ACCESSIBILITY=TRUE" in the init.ora [not sure if it can be dynamically modified in 9i] and restart the instance.
Hemant K Chitale
"Bertus Dam" <b.dam_at_gmx.net> wrote in message
news:3cfc878f$1_at_news.mhogaming.com...
> I'm trying to create a connectionstring in my application to an oracle 9i
> database.
> I can't get it to work though. This is what I try:
>
> Provider=OraOLEDB.Oracle;Data Source=svr;User
> ID=SYS;Password=change_on_install;
>
> Errormessage:
>
> Message: "ORA-28009: connection to sys should be as sysdba or sysoper"
>
> How can I fix this? Or how do I create a connectionstring which uses
> integrated O/S security?
>
>
>
> Thanx, Bertus
>
>
>
Received on Tue Jun 04 2002 - 09:53:48 CDT