Cannot connection to Oracle DB

I create my datasource using the OLE DB data provider for oracle an when i
test the connection it is successful. When I create the dataset it cannot
connect to the database and says "System.Data.Oracle Client requires Oracle
Client Software version 8.1.7 or greater". I am using PL/SQL Developer that
says it is 9i compatible. Im so lost here and need help. Thanks.We had the Oracle client set up quite a while ago so forgot the steps to set
it up. We did run into some issues. If my memory serves me right, the default
9i installation allows the oci.dll to admin group only, and the web app
(ASPNET by default) or reporting service account (the one you chose during
setup) may not have the necessary permission to see this file. It is one
possible reason.
"Steve" wrote:
> I create my datasource using the OLE DB data provider for oracle an when i
> test the connection it is successful. When I create the dataset it cannot
> connect to the database and says "System.Data.Oracle Client requires Oracle
> Client Software version 8.1.7 or greater". I am using PL/SQL Developer that
> says it is 9i compatible. Im so lost here and need help. Thanks.
>|||Specifically, you may want to check this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;870668
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Terence Leung" <TerenceLeung@.discussions.microsoft.com> wrote in message
news:9349134D-7982-4C1E-995B-3A761058945E@.microsoft.com...
> We had the Oracle client set up quite a while ago so forgot the steps to
> set
> it up. We did run into some issues. If my memory serves me right, the
> default
> 9i installation allows the oci.dll to admin group only, and the web app
> (ASPNET by default) or reporting service account (the one you chose during
> setup) may not have the necessary permission to see this file. It is one
> possible reason.
> "Steve" wrote:
>> I create my datasource using the OLE DB data provider for oracle an when
>> i
>> test the connection it is successful. When I create the dataset it
>> cannot
>> connect to the database and says "System.Data.Oracle Client requires
>> Oracle
>> Client Software version 8.1.7 or greater". I am using PL/SQL Developer
>> that
>> says it is 9i compatible. Im so lost here and need help. Thanks.|||Niether of those ideas worked. I do not have and oci.dll file on my system
and I am developing on an XP system not a 2003 server system.
"Robert Bruckner [MSFT]" wrote:
> Specifically, you may want to check this KB article:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;870668
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Terence Leung" <TerenceLeung@.discussions.microsoft.com> wrote in message
> news:9349134D-7982-4C1E-995B-3A761058945E@.microsoft.com...
> > We had the Oracle client set up quite a while ago so forgot the steps to
> > set
> > it up. We did run into some issues. If my memory serves me right, the
> > default
> > 9i installation allows the oci.dll to admin group only, and the web app
> > (ASPNET by default) or reporting service account (the one you chose during
> > setup) may not have the necessary permission to see this file. It is one
> > possible reason.
> >
> > "Steve" wrote:
> >
> >> I create my datasource using the OLE DB data provider for oracle an when
> >> i
> >> test the connection it is successful. When I create the dataset it
> >> cannot
> >> connect to the database and says "System.Data.Oracle Client requires
> >> Oracle
> >> Client Software version 8.1.7 or greater". I am using PL/SQL Developer
> >> that
> >> says it is 9i compatible. Im so lost here and need help. Thanks.
> >>
>
>|||If there is no oci.dll on your machine, then the Oracle client software is
not installed. It won't work without it. You can download the Oracle client
software from Oracle Technology Network (www.oracle.com/otn).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"steve" <steve@.discussions.microsoft.com> wrote in message
news:9BDF4BD5-DF7E-4134-8873-94FBFB5E35AD@.microsoft.com...
> Niether of those ideas worked. I do not have and oci.dll file on my
> system
> and I am developing on an XP system not a 2003 server system.
>
> "Robert Bruckner [MSFT]" wrote:
>> Specifically, you may want to check this KB article:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;870668
>>
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Terence Leung" <TerenceLeung@.discussions.microsoft.com> wrote in message
>> news:9349134D-7982-4C1E-995B-3A761058945E@.microsoft.com...
>> > We had the Oracle client set up quite a while ago so forgot the steps
>> > to
>> > set
>> > it up. We did run into some issues. If my memory serves me right, the
>> > default
>> > 9i installation allows the oci.dll to admin group only, and the web app
>> > (ASPNET by default) or reporting service account (the one you chose
>> > during
>> > setup) may not have the necessary permission to see this file. It is
>> > one
>> > possible reason.
>> >
>> > "Steve" wrote:
>> >
>> >> I create my datasource using the OLE DB data provider for oracle an
>> >> when
>> >> i
>> >> test the connection it is successful. When I create the dataset it
>> >> cannot
>> >> connect to the database and says "System.Data.Oracle Client requires
>> >> Oracle
>> >> Client Software version 8.1.7 or greater". I am using PL/SQL
>> >> Developer
>> >> that
>> >> says it is 9i compatible. Im so lost here and need help. Thanks.
>> >>
>>