G
Guest
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
'sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\w\vgyl\hy.mdb"
gsConnectionString = "Provider=SQLOLEDB;Data Source=frt4;Initial
Catalog=SRMSM;Integrated Security=SSPI"
Else
If gbDevelopment Then
gsConnectionString = OLEDB_PROVIDER & "User
ID=ght;Password=" & DB_PASSWORD & ";Data Source=vgy"
gsConnectionString = OLEDB_PROVIDER & "User
ID=ght;Password=" & DB_PASSWORD & ";Data Source=vgyl"
Else
gsConnectionString = 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(OLEDB_PROVIDER &
gsConnectionString)
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.OleDb.OleDbException: 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.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
GT.StudentSearch.Page_Load(Object sender, EventArgs e) +224
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
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
'sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=c:\w\vgyl\hy.mdb"
gsConnectionString = "Provider=SQLOLEDB;Data Source=frt4;Initial
Catalog=SRMSM;Integrated Security=SSPI"
Else
If gbDevelopment Then
gsConnectionString = OLEDB_PROVIDER & "User
ID=ght;Password=" & DB_PASSWORD & ";Data Source=vgy"
gsConnectionString = OLEDB_PROVIDER & "User
ID=ght;Password=" & DB_PASSWORD & ";Data Source=vgyl"
Else
gsConnectionString = 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(OLEDB_PROVIDER &
gsConnectionString)
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.OleDb.OleDbException: 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.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
GT.StudentSearch.Page_Load(Object sender, EventArgs e) +224
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750