Connecting to Oracle 9i

[va]

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

Dim con As New ADODB.Connectio n

con.ConnectionS tring = "PROVIDER=MSDAS QL;DRIVER=
{Microsoft ODBC for oracle};SERVER= {server name};UID={user
id};PWD={passwo rd};"

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?

[Miha Markic]

Hi,

You should use System.Data.Ora cle namespace and the classes within
(OracleConnecti on etc.) - managed providers.

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

"va" <vi************ @mail.com> wrote in message
news:09******** *************** *****@phx.gbl.. .

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

Dim con As New ADODB.Connectio n

con.ConnectionS tring = "PROVIDER=MSDAS QL;DRIVER=
{Microsoft ODBC for oracle};SERVER= {server name};UID={user
id};PWD={passwo rd};"

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?

[Miha Markic]

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:%2******** ********@TK2MSF TNGP10.phx.gbl. ..

Hi,

You should use System.Data.Ora cle namespace and the classes within
(OracleConnecti on etc.) - managed providers.

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

"va" <vi************ @mail.com> wrote in message
news:09******** *************** *****@phx.gbl.. .

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

Dim con As New ADODB.Connectio n

con.ConnectionS tring = "PROVIDER=MSDAS QL;DRIVER=
{Microsoft ODBC for oracle};SERVER= {server name};UID={user
id};PWD={passwo rd};"

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?

[Paul Clement]

On Mon, 22 Dec 2003 14:36:49 -0800, "va" <vi************ @mail.com> wrote:

¤ I am trying to establish a connection to Oracle 9i from
¤ asp.net.(.net 2003) The code is
¤
¤ Dim con As New ADODB.Connectio n
¤
¤ con.ConnectionS tring = "PROVIDER=MSDAS QL;DRIVER=
¤ {Microsoft ODBC for oracle};SERVER= {server name};UID={user
¤ id};PWD={passwo rd};"
¤
¤ 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 ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)