Re: Provider error trying to connect to Oracle 10g

From: Matthias Hoys <anti_at_spam.com>
Date: Fri, 26 May 2006 18:45:10 +0200
Message-ID: <44773097$0$23535$ba620e4c@news.skynet.be>

<jduhler_at_hotmail.com> wrote in message
news:1148653575.348159.86020_at_j33g2000cwa.googlegroups.com...
>I am developing with ASP.NET 1.1 with VB.NET on Windows 2003 Server
> with IIS 6.0.
>
> When I attempt to make an OLEDB connection to an Oracle 10g database
> with ASP.NET I receive:
>
> An OLE DB Provider was not specified in the ConnectionString. An
> example would be, 'Provider=SQLOLEDB;'.
>
> Once I add the Provider=msdaora or Provider=OraOLEDB.Oracle then it
> says:
>
> Keyword not supported: 'provider'.
>
> My connection string is: Provider=OraOLEDB.Oracle;Data Source=test;User
>
> ID=test;Password=test. A DSN exists for "test".
>
> Any idea what I need to do? Something with ODBC connections?
>
> JD
>

Did you install the Oracle client software on the server ? You still need those (+ MDAC) for a connection to Oracle. Received on Fri May 26 2006 - 11:45:10 CDT