dotNetHell.it - Forum - Connessione Oracle

cnnmax Profilo | Junior Member

99 messaggi | Data Invio: lun 29 dic 2003 - 19:09

Ciao a tutti.
Ho un problema con Oracle.
Effettuo la connessione con OleDB in questo modo:
Provider=MSDAORA.1;Data Source=TNSName;User ID=system;password=manager

Quando apro la connessione mi viene restituito il seguente errore :

"Impossibile trovare il client e i componenti di rete Oracle. Tali componenti vengono forniti da Oracle Corporation e fanno parte dell'installazione del software client Oracle versione 7.3.3 o successive.
Se non si installano tali componenti, non sarà possibile utilizzare questo provider."

Io ho installato tutti i componenti client ma non funziona :-(
Potete aiutarmi?

Grazie a tutti

Brainkiller Profilo | Guru

7.999 messaggi | Data Invio: mar 30 dic 2003 - 11:38

Ma hai installato il Client di Oracle ?
Di solito questo errore compare quando manca.
Vai sul sito Oracle, sezione Downloads, scarica e installa il Client corrispondente alla versione del Database Server che stai usando, e poi riprova.
Se l'hai già installato evidentemente manca qualcosa.

ciao
david

bulibenz Profilo | Newbie

4 messaggi | Data Invio: ven 27 mag 2005 - 17:37

Se avete questo problema sistemate questo baco Oracle, io ho risolto cosi :

The issue below is a security issue that we have found that deals
> with Oracle9i, you may want to review it and see if it could be an
> issue.
>
>
> Problem Description
> -------------------
>
> When running an application using the Oracle9i Release 2 (9.2.0.1.0)
> install of client software and that attempts to connect to an Oracle
> database with the Authenticated User privilege (such as when you use
> Microsoft's Internet Information Server (IIS)) through any of the
> following programmatic interfaces
>
> 1. Oracle Provider for OLE DB
> 2. Microsoft OLE DB Provider for Oracle
> 3. Oracle ODBC Driver
> 4. Microsoft ODBC for Oracle
> 5. Oracle Objects for OLE (OO4O)
> 6. Microsoft .NET Framework Data Provider for Oracle
>
> you may receive one of the following errors:
>
> (1) Oracle Provider for OLE DB
>
> (a) Error Type: Microsoft OLE DB Service Components (0x80070005)
>
> Access is denied.
>
> (b) OraOLEDB.Oracle Provider is not registered on the local machine
>
> (2) Microsoft OLE DB Provider for Oracle
>
> (a) Error Type: Microsoft OLE DB Provider for Oracle (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.
>
> (b) Error Type: Microsoft OLE DB Provider for Oracle (0x80004005)
>
> Oracle error occurred, but error message could not be retrieved from
> Oracle.
>
> (3) Oracle ODBC Driver
>
> (a) Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>
> Specified driver could not be loaded due to system error 5 (Oracle in
> OraHome92).
>
> (4) Microsoft ODBC for Oracle
>
> (a) The Oracle(tm) client and networking components were not found.
> These components are supplied by Oracle Corporation and are part of the
> Oracle Version 7.3 (or greater) client software installation.
>
> You will be unable to use this driver until these components have been
> installed.
>
> (b) Error number: -2147467259
>
> Error Description: [Microsoft][ODBC Driver Manager] Driver's
> SQLAllocHandle on SQL_HANDLE_ENV failed
>
> (5) Oracle Objects for OLE
>
> (a) while using a GLOBAL.ASA file
>
> Error Type: Active Server Pages (0x0)
>
> An error occurred while creating object 'OraSession'.
>
> (b) not using a GLOBAL.ASA file
>
> Error Type: Microsoft VBScript runtime (0x800A0046)
>
> Permission denied: 'CreateObject'
>
> (6) Microsoft .NET Framework Data Provider for Oracle
>
> (a) System.DllNotFoundException: Unable to load DLL (oci.dll). at
> System.Data.OracleClient.DBObjectPool.GetObject(Boolean&
> isInTransaction)
> at System.Data.OracleClient.OracleConnectionPoolManager.
> GetPooledConnection(String encryptedConnectionString,
> OracleConnectionString options, Boolean& isInTransaction) at
> System.Data.OracleClient.OracleConnection.OpenInternal
> (OracleConnectionString parsedConnectionString, Object transact) at
> System.Data.OracleClient.OracleConnection.Open()
> at WCWSItemAvailability.ETAAvailability.SingleAvailability(String
> ItemNumber, String BusinessUnit, Int32 OrderQty, Int32& AvailableQty,
> Int32& OnHandQty, String& ETADate, Int32& Error) at
> WCWSItemAvailability.ETAAvailability.XMLAvailability(String
> XMLInput)
>
> (7) Other miscellaneous errors
>
> (a) The Specified Module Could Not Be Found
>
> (b) ORA-00604: error occurred at recursive SQL level 1
> ORA-12705: invalid or unknown NLS parameter value specified
>
> (c) Unable to load DLL (OraOps9.dll):
> ...
> [DllNotFoundException: Unable to load DLL (OraOps9.dll).]
>
> (d) System Error 998 trying to run ASP page
>
> Solution Description
> --------------------
>
> Or

bulibenz Profilo | Newbie

4 messaggi | Data Invio: ven 27 mag 2005 - 17:38

Se avete questo problema sistemate questo baco Oracle, io ho risolto cosi :

The issue below is a security issue that we have found that deals
> with Oracle9i, you may want to review it and see if it could be an
> issue.
>
>
> Problem Description
> -------------------
>
> When running an application using the Oracle9i Release 2 (9.2.0.1.0)
> install of client software and that attempts to connect to an Oracle
> database with the Authenticated User privilege (such as when you use
> Microsoft's Internet Information Server (IIS)) through any of the
> following programmatic interfaces
>
> 1. Oracle Provider for OLE DB
> 2. Microsoft OLE DB Provider for Oracle
> 3. Oracle ODBC Driver
> 4. Microsoft ODBC for Oracle
> 5. Oracle Objects for OLE (OO4O)
> 6. Microsoft .NET Framework Data Provider for Oracle
>
> you may receive one of the following errors:
>
> (1) Oracle Provider for OLE DB
>
> (a) Error Type: Microsoft OLE DB Service Components (0x80070005)
>
> Access is denied.
>
> (b) OraOLEDB.Oracle Provider is not registered on the local machine
>
> (2) Microsoft OLE DB Provider for Oracle
>
> (a) Error Type: Microsoft OLE DB Provider for Oracle (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.
>
> (b) Error Type: Microsoft OLE DB Provider for Oracle (0x80004005)
>
> Oracle error occurred, but error message could not be retrieved from
> Oracle.
>
> (3) Oracle ODBC Driver
>
> (a) Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
>
> Specified driver could not be loaded due to system error 5 (Oracle in
> OraHome92).
>
> (4) Microsoft ODBC for Oracle
>
> (a) The Oracle(tm) client and networking components were not found.
> These components are supplied by Oracle Corporation and are part of the
> Oracle Version 7.3 (or greater) client software installation.
>
> You will be unable to use this driver until these components have been
> installed.
>
> (b) Error number: -2147467259
>
> Error Description: [Microsoft][ODBC Driver Manager] Driver's
> SQLAllocHandle on SQL_HANDLE_ENV failed
>
> (5) Oracle Objects for OLE
>
> (a) while using a GLOBAL.ASA file
>
> Error Type: Active Server Pages (0x0)
>
> An error occurred while creating object 'OraSession'.
>
> (b) not using a GLOBAL.ASA file
>
> Error Type: Microsoft VBScript runtime (0x800A0046)
>
> Permission denied: 'CreateObject'
>
> (6) Microsoft .NET Framework Data Provider for Oracle
>
> (a) System.DllNotFoundException: Unable to load DLL (oci.dll). at
> System.Data.OracleClient.DBObjectPool.GetObject(Boolean&
> isInTransaction)
> at System.Data.OracleClient.OracleConnectionPoolManager.
> GetPooledConnection(String encryptedConnectionString,
> OracleConnectionString options, Boolean& isInTransaction) at
> System.Data.OracleClient.OracleConnection.OpenInternal
> (OracleConnectionString parsedConnectionString, Object transact) at
> System.Data.OracleClient.OracleConnection.Open()
> at WCWSItemAvailability.ETAAvailability.SingleAvailability(String
> ItemNumber, String BusinessUnit, Int32 OrderQty, Int32& AvailableQty,
> Int32& OnHandQty, String& ETADate, Int32& Error) at
> WCWSItemAvailability.ETAAvailability.XMLAvailability(String
> XMLInput)
>
> (7) Other miscellaneous errors
>
> (a) The Specified Module Could Not Be Found
>
> (b) ORA-00604: error occurred at recursive SQL level 1
> ORA-12705: invalid or unknown NLS parameter value specified
>
> (c) Unable to load DLL (OraOps9.dll):
> ...
> [DllNotFoundException: Unable to load DLL (OraOps9.dll).]
>
> (d) System Error 998 trying to run ASP page
>
> Solution Description
> --------------------
>
> Or

bulibenz Profilo | Newbie

4 messaggi | Data Invio: ven 27 mag 2005 - 17:47

Io ho risolto sistemando il baco oracle allegato nel file txt.

Ciao.

bulibenz Profilo | Newbie

4 messaggi | Data Invio: ven 27 mag 2005 - 17:47

vedi file