Server Error in '/CelxVitals' Application

Friends,

I can run locally my website that queries an external Oracle DB, but when I upload my website to discountasp, I get the following error:

Can anybody help me?

Thanks!
Eli

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

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
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.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

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:


[Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.]
System.Data.OracleClient.OCI.DetermineClientVersion() +563
System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) +45
System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) +135
System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +36
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +68
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +519
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +104
System.Data.OracleClient.OracleConnection.Open() +37
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +50
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Control.PreRenderRecursiveInternal() +170
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041

 

Hi,
Oracle is not supported.
It's a very expensive competitor of Microsoft SQL Server.
SQL Server, XML, Access are supported.

 

Thanks, but I don't need Oracle hosted, the company I'm developing the web for already has Oracle servers, I just want that my pages that are hosted in discountasp.net will be able to access that Oracle database in their servers.


Any idea?


Thanks,


Elias

 

Hi,
There is a way to do this on Shared servers...I have done this in the past.

Use SQL Server on your end with transactions to your remote DASP SQL Server.
Pull the data in any interval needed. Note, this is not a live connection.
Once you have the data on your end, preferably in a temp DB...
Handle it with SQL and Triggers, then pump it over to Oracle.
To get the data from Oracle to your live shared SQL Server have Oracle export CSV files.
Then use Import/SQL and triggers on your end to make conversions, finally pump any needed data on-line.

Some things in Oracle will need very strict conversions, i.e. the Oracle "number".
Salute,
Mark