Asp.net / iis / oracle problem

[BookerW]

I am not sure which forum I should post this on, but here is the problem. I
have a front end web application(VB) on asp,net 1.1 framework. Inside of the
code, I have the following lines to connect to the database

If gbSQLServer Then
'sConnectionStr ing = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
Source=c:\w\vgy l\hy.mdb"
gsConnectionStr ing = "Provider=SQLOL EDB;Data Source=frt4;Ini tial
Catalog=SRMSM;I ntegrated Security=SSPI"
Else
If gbDevelopment Then
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgy"
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgyl"
Else
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgyl"
End If
And in most places when the code tries to connect to the database, it is
done in this format:

Dim cn As OleDbConnection = OpenDatabase(OL EDB_PROVIDER &
gsConnectionStr ing)

The error that I get is below, and I am not sure if the error is related to
the attempt to open the data source, or if it is as plain as stated, that the
box does not think that the Oracle Client is not installed... WHICH it is. I
installed oracle 9i client

Server Error in '/gt' Application.
--------------------------------------------------------------------------------

Oracle client and networking components were not found. These components are
supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or
later client software installation. Provider is unable to function until
these components are installed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: Oracle client and
networking components were not found. These components are supplied by Oracle
Corporation and are part of the Oracle Version 7.3.3 or later client software
installation. Provider is unable to function until these components are
installed.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:
[OleDbException (0x80004005): Oracle client and networking components were
not found. These components are supplied by Oracle Corporation and are part
of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.]
System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr) +20
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider() +57
System.Data.Ole Db.OleDbConnect ion.Open() +203
GT.StudentSearc h.Page_Load(Obj ect sender, EventArgs e) +224
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +750


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET
Version:1.1.432 2.2300

[Cowboy \(Gregory A. Beamer\)]

Oracle is a pain. You need a good portion of the Oracle client software
installed to use .NET with the OracleClient namespace (or even ODP.NET for
that matter). It is more than the libraries necessary for the Oracle SQL
tools, like SQL*Plus.

Watch your connection string, as well. You are concatenating OLEDB_PROVIDER
twice. Once in your If ... Else and once in the OleDbConnection creation.

--
Gregory A. Beamer

*************** *************** *************** ****
Think Outside the Box!
*************** *************** *************** ****
"BookerW" <Bo*****@discus sions.microsoft .com> wrote in message
news:75******** *************** ***********@mic rosoft.com...

I am not sure which forum I should post this on, but here is the problem.
I
have a front end web application(VB) on asp,net 1.1 framework. Inside of
the
code, I have the following lines to connect to the database

If gbSQLServer Then
'sConnectionStr ing = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
Source=c:\w\vgy l\hy.mdb"
gsConnectionStr ing = "Provider=SQLOL EDB;Data Source=frt4;Ini tial
Catalog=SRMSM;I ntegrated Security=SSPI"
Else
If gbDevelopment Then
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgy"
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgyl"
Else
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgyl"
End If
And in most places when the code tries to connect to the database, it is
done in this format:

Dim cn As OleDbConnection = OpenDatabase(OL EDB_PROVIDER &
gsConnectionStr ing)

The error that I get is below, and I am not sure if the error is related
to
the attempt to open the data source, or if it is as plain as stated, that
the
box does not think that the Oracle Client is not installed... WHICH it is.
I
installed oracle 9i client

Server Error in '/gt' Application.
--------------------------------------------------------------------------------

Oracle client and networking components were not found. These components
are
supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or
later client software installation. Provider is unable to function until
these components are installed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: Oracle client and
networking components were not found. These components are supplied by
Oracle
Corporation and are part of the Oracle Version 7.3.3 or later client
software
installation. Provider is unable to function until these components are
installed.

Source Error:

An unhandled exception was generated during the execution of the current
web
request. Information regarding the origin and location of the exception
can
be identified using the exception stack trace below.

Stack Trace:
[OleDbException (0x80004005): Oracle client and networking components were
not found. These components are supplied by Oracle Corporation and are
part
of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.]
System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr) +20
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider() +57
System.Data.Ole Db.OleDbConnect ion.Open() +203
GT.StudentSearc h.Page_Load(Obj ect sender, EventArgs e) +224
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +750


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300;
ASP.NET
Version:1.1.432 2.2300

[BookerW]

ok, i removed the double concatenating, and i will try it again. Can i
download the odp.net stuff

"Cowboy (Gregory A. Beamer)" wrote:

Oracle is a pain. You need a good portion of the Oracle client software
installed to use .NET with the OracleClient namespace (or even ODP.NET for
that matter). It is more than the libraries necessary for the Oracle SQL
tools, like SQL*Plus.

Watch your connection string, as well. You are concatenating OLEDB_PROVIDER
twice. Once in your If ... Else and once in the OleDbConnection creation.

--
Gregory A. Beamer

*************** *************** *************** ****
Think Outside the Box!
*************** *************** *************** ****
"BookerW" <Bo*****@discus sions.microsoft .com> wrote in message
news:75******** *************** ***********@mic rosoft.com...

I am not sure which forum I should post this on, but here is the problem.
I
have a front end web application(VB) on asp,net 1.1 framework. Inside of
the
code, I have the following lines to connect to the database

If gbSQLServer Then
'sConnectionStr ing = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
Source=c:\w\vgy l\hy.mdb"
gsConnectionStr ing = "Provider=SQLOL EDB;Data Source=frt4;Ini tial
Catalog=SRMSM;I ntegrated Security=SSPI"
Else
If gbDevelopment Then
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgy"
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgyl"
Else
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgyl"
End If
And in most places when the code tries to connect to the database, it is
done in this format:

Dim cn As OleDbConnection = OpenDatabase(OL EDB_PROVIDER &
gsConnectionStr ing)

The error that I get is below, and I am not sure if the error is related
to
the attempt to open the data source, or if it is as plain as stated, that
the
box does not think that the Oracle Client is not installed... WHICH it is.
I
installed oracle 9i client

Server Error in '/gt' Application.
--------------------------------------------------------------------------------

Oracle client and networking components were not found. These components
are
supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or
later client software installation. Provider is unable to function until
these components are installed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: Oracle client and
networking components were not found. These components are supplied by
Oracle
Corporation and are part of the Oracle Version 7.3.3 or later client
software
installation. Provider is unable to function until these components are
installed.

Source Error:

An unhandled exception was generated during the execution of the current
web
request. Information regarding the origin and location of the exception
can
be identified using the exception stack trace below.

Stack Trace:
[OleDbException (0x80004005): Oracle client and networking components were
not found. These components are supplied by Oracle Corporation and are
part
of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.]
System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr) +20
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider() +57
System.Data.Ole Db.OleDbConnect ion.Open() +203
GT.StudentSearc h.Page_Load(Obj ect sender, EventArgs e) +224
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +750


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300;
ASP.NET
Version:1.1.432 2.2300

[BookerW]

I am downloading the odpnet stuff for oracle 9i ver 9.0201

"Cowboy (Gregory A. Beamer)" wrote:

Oracle is a pain. You need a good portion of the Oracle client software
installed to use .NET with the OracleClient namespace (or even ODP.NET for
that matter). It is more than the libraries necessary for the Oracle SQL
tools, like SQL*Plus.

Watch your connection string, as well. You are concatenating OLEDB_PROVIDER
twice. Once in your If ... Else and once in the OleDbConnection creation.

--
Gregory A. Beamer

*************** *************** *************** ****
Think Outside the Box!
*************** *************** *************** ****
"BookerW" <Bo*****@discus sions.microsoft .com> wrote in message
news:75******** *************** ***********@mic rosoft.com...

I am not sure which forum I should post this on, but here is the problem.
I
have a front end web application(VB) on asp,net 1.1 framework. Inside of
the
code, I have the following lines to connect to the database

If gbSQLServer Then
'sConnectionStr ing = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
Source=c:\w\vgy l\hy.mdb"
gsConnectionStr ing = "Provider=SQLOL EDB;Data Source=frt4;Ini tial
Catalog=SRMSM;I ntegrated Security=SSPI"
Else
If gbDevelopment Then
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgy"
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgyl"
Else
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgyl"
End If
And in most places when the code tries to connect to the database, it is
done in this format:

Dim cn As OleDbConnection = OpenDatabase(OL EDB_PROVIDER &
gsConnectionStr ing)

The error that I get is below, and I am not sure if the error is related
to
the attempt to open the data source, or if it is as plain as stated, that
the
box does not think that the Oracle Client is not installed... WHICH it is.
I
installed oracle 9i client

Server Error in '/gt' Application.
--------------------------------------------------------------------------------

Oracle client and networking components were not found. These components
are
supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or
later client software installation. Provider is unable to function until
these components are installed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: Oracle client and
networking components were not found. These components are supplied by
Oracle
Corporation and are part of the Oracle Version 7.3.3 or later client
software
installation. Provider is unable to function until these components are
installed.

Source Error:

An unhandled exception was generated during the execution of the current
web
request. Information regarding the origin and location of the exception
can
be identified using the exception stack trace below.

Stack Trace:
[OleDbException (0x80004005): Oracle client and networking components were
not found. These components are supplied by Oracle Corporation and are
part
of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.]
System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr) +20
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider() +57
System.Data.Ole Db.OleDbConnect ion.Open() +203
GT.StudentSearc h.Page_Load(Obj ect sender, EventArgs e) +224
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +750


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300;
ASP.NET
Version:1.1.432 2.2300

[BookerW]

Final solution that seemed to work:

Ok, the quick rundown

Fixed the ldap references In the code

Replaced the username and passwords for accounts in our domain (Remember
this code came from a separate company)

Installed Oracle Client software on Server

Installed Oracle OLE DB connectivity software (ODAC) from Oracle’s website.
This seemed to resolve the error I got in regards to the Oracle Client not
being found

Finally, the account used to access the database did not have the right to
view specific tables. It could see the list of tables, but not specific
tables.

My DBA had to create synonyms for the account used to access the database to
mimic the account that had ownership of the tables in the database.

At this point, I can now connect, perform queries on the tables, etc ,etc..

Wallah, thanks for the journey,

Thanks for all of your help

"BookerW" wrote:

I am downloading the odpnet stuff for oracle 9i ver 9.0201

"Cowboy (Gregory A. Beamer)" wrote:

Oracle is a pain. You need a good portion of the Oracle client software
installed to use .NET with the OracleClient namespace (or even ODP.NET for
that matter). It is more than the libraries necessary for the Oracle SQL
tools, like SQL*Plus.

Watch your connection string, as well. You are concatenating OLEDB_PROVIDER
twice. Once in your If ... Else and once in the OleDbConnection creation.

--
Gregory A. Beamer

*************** *************** *************** ****
Think Outside the Box!
*************** *************** *************** ****
"BookerW" <Bo*****@discus sions.microsoft .com> wrote in message
news:75******** *************** ***********@mic rosoft.com...

I am not sure which forum I should post this on, but here is the problem.
I
have a front end web application(VB) on asp,net 1.1 framework. Inside of
the
code, I have the following lines to connect to the database

If gbSQLServer Then
'sConnectionStr ing = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
Source=c:\w\vgy l\hy.mdb"
gsConnectionStr ing = "Provider=SQLOL EDB;Data Source=frt4;Ini tial
Catalog=SRMSM;I ntegrated Security=SSPI"
Else
If gbDevelopment Then
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgy"
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgyl"
Else
gsConnectionStr ing = OLEDB_PROVIDER & "User
ID=ght;Password =" & DB_PASSWORD & ";Data Source=vgyl"
End If
And in most places when the code tries to connect to the database, it is
done in this format:

Dim cn As OleDbConnection = OpenDatabase(OL EDB_PROVIDER &
gsConnectionStr ing)

The error that I get is below, and I am not sure if the error is related
to
the attempt to open the data source, or if it is as plain as stated, that
the
box does not think that the Oracle Client is not installed... WHICH it is.
I
installed oracle 9i client

Server Error in '/gt' Application.
--------------------------------------------------------------------------------

Oracle client and networking components were not found. These components
are
supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or
later client software installation. Provider is unable to function until
these components are installed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about
the error and where it originated in the code.

Exception Details: System.Data.Ole Db.OleDbExcepti on: Oracle client and
networking components were not found. These components are supplied by
Oracle
Corporation and are part of the Oracle Version 7.3.3 or later client
software
installation. Provider is unable to function until these components are
installed.

Source Error:

An unhandled exception was generated during the execution of the current
web
request. Information regarding the origin and location of the exception
can
be identified using the exception stack trace below.

Stack Trace:
[OleDbException (0x80004005): Oracle client and networking components were
not found. These components are supplied by Oracle Corporation and are
part
of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.]
System.Data.Ole Db.OleDbConnect ion.ProcessResu lts(Int32 hr) +20
System.Data.Ole Db.OleDbConnect ion.InitializeP rovider() +57
System.Data.Ole Db.OleDbConnect ion.Open() +203
GT.StudentSearc h.Page_Load(Obj ect sender, EventArgs e) +224
System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
System.Web.UI.C ontrol.LoadRecu rsive() +35
System.Web.UI.P age.ProcessRequ estMain() +750


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300;
ASP.NET
Version:1.1.432 2.2300