I am trying to establish a connection to Oracle 9i from
asp.net.(.net 2003) The code is

Dim con As New ADODB.Connection

con.ConnectionString = "PROVIDER=MSDASQL;DRIVER=
{Microsoft ODBC for oracle};SERVER={server name};UID={user
id};PWD={password};"

con.Open()

It gives error message [Microsoft][ODBC driver for Oracle]
[Oracle]

If I use the same code in VB 6.0 it works. I am using
Windows 2000 operating system. If I try from Windows XP
it works from asp.net after changing security for
ociw32.dll. I tried to do the same on Windows 2000.
Still it does not work. Any other way of making it work?

Hi,

You should use System.Data.Oracle namespace and the classes within
(OracleConnection etc.) - managed providers.

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"va" <(E-Mail Removed)> wrote in message
news:092501c3c8dc$16a9c150$(E-Mail Removed)...
> I am trying to establish a connection to Oracle 9i from
> asp.net.(.net 2003) The code is
>
> Dim con As New ADODB.Connection
>
> con.ConnectionString = "PROVIDER=MSDASQL;DRIVER=
> {Microsoft ODBC for oracle};SERVER={server name};UID={user
> id};PWD={password};"
>
> con.Open()
>
> It gives error message [Microsoft][ODBC driver for Oracle]
> [Oracle]
>
> If I use the same code in VB 6.0 it works. I am using
> Windows 2000 operating system. If I try from Windows XP
> it works from asp.net after changing security for
> ociw32.dll. I tried to do the same on Windows 2000.
> Still it does not work. Any other way of making it work?

It is OracleClient and not Oracle namespace...

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Miha Markic" <miha at rthand com> wrote in message
news:%(E-Mail Removed)...
> Hi,
>
> You should use System.Data.Oracle namespace and the classes within
> (OracleConnection etc.) - managed providers.
>
> --
> Miha Markic - RightHand .NET consulting & software development
> miha at rthand com
> www.rthand.com
>
> "va" <(E-Mail Removed)> wrote in message
> news:092501c3c8dc$16a9c150$(E-Mail Removed)...
> > I am trying to establish a connection to Oracle 9i from
> > asp.net.(.net 2003) The code is
> >
> > Dim con As New ADODB.Connection
> >
> > con.ConnectionString = "PROVIDER=MSDASQL;DRIVER=
> > {Microsoft ODBC for oracle};SERVER={server name};UID={user
> > id};PWD={password};"
> >
> > con.Open()
> >
> > It gives error message [Microsoft][ODBC driver for Oracle]
> > [Oracle]
> >
> > If I use the same code in VB 6.0 it works. I am using
> > Windows 2000 operating system. If I try from Windows XP
> > it works from asp.net after changing security for
> > ociw32.dll. I tried to do the same on Windows 2000.
> > Still it does not work. Any other way of making it work?
>
>

On Mon, 22 Dec 2003 14:36:49 -0800, "va" <(E-Mail Removed)> wrote:

¤ I am trying to establish a connection to Oracle 9i from
¤ asp.net.(.net 2003) The code is
¤
¤ Dim con As New ADODB.Connection
¤
¤ con.ConnectionString = "PROVIDER=MSDASQL;DRIVER=
¤ {Microsoft ODBC for oracle};SERVER={server name};UID={user
¤ id};PWD={password};"
¤
¤ con.Open()
¤
¤ It gives error message [Microsoft][ODBC driver for Oracle]
¤ [Oracle]
¤
¤ If I use the same code in VB 6.0 it works. I am using
¤ Windows 2000 operating system. If I try from Windows XP
¤ it works from asp.net after changing security for
¤ ociw32.dll. I tried to do the same on Windows 2000.
¤ Still it does not work. Any other way of making it work?

Is there a reason why you are using ADO instead of ADO.NET?

You should be using Oracle specific drivers:

http://www.able-consulting.com/MDAC/...eFromMicrosoft
http://www.able-consulting.com/MDAC/...riverForOracle


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)