| Connecting Oracle 9i database from ASP, VbScript [message #100327] |
Tue, 15 October 2002 08:53  |
Serge Stameschkine
Messages: 1
Registered: October 2002
|
Junior Member |
|
|
Here's my BIG Problem:
(ASP, trying to connect Oracle 9i)
I'm testing ORACLE 9i on a Windows 2000 Server.
The Oracle Client run also under Windows 2000.
The remote Oracle database is reached correctly by the Oracle Client, using as well SQL Plus, as Visual BASIC or by linking Tables into MS/Access via ODBC.
BUT THE ROBLEM IS: My Web page is written in ASP (DreamWeaver/Macromedia).
Under ASP (Vbscript), the Tables and the data fields are viewed completely, but at development time only.
When executing the ASP code (F12), the program leaves in error, (IMPOSSIBLE TO DISPLAY the PAGE), and this whatever the method used: "Microsoft ODBC for Oracle" or "Oracle in OraHome90" drivers, or Provider OLEDBOracle.
Type of error: "Microsoft OLE dB Provider for ODBC Drivers (0x80004005)" [[ Microsoft]][[Gestionnaire of pilots ODBC ]] "SQLAllocHandle Failure of the pilot on Standard SQL_HANDLE_ENV"
Type of error: "ADODB.Recordset (0x800A0E7A)" Impossible to find the provider.
He is perhaps badly installed.
Would somebody have a solution? Thank you in advance
For the French speaking readers :
Problème: ASP, connexion à Oracle 9i
J'ai installé en test un database server ORACLE 9i sur plateforme Windows 2000.
Le Client Oracle est également sous Windows 2000.
La database Oracle est parfaitement accédée par le Client, aussi bien en SQL Plus, qu'en Visual Basic ou
encore dans MS/Access par ODBC (link Table).
Voici mon PROBLEME :
Ma page WEB est écrite en ASP (DreamWeaver de Macromedia).
Sous ASP (Vbscript), les Tables et les champs de données sont parfaitement visualisés,
mais seulement en phase de développement.
Au moment de l'exécution, le programme sort en erreur, (IMPOSSIBLE d'AFFICHER LA PAGE),
et ceci quelle que soit la méthode utilisée : pilote "Microsoft ODBC for Oracle", pilote "Oracle dans OraHome90", ou encore le Provider OLEDBOracle.
Impossible d'afficher la page
Type d'erreur :
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[[Microsoft]][[Gestionnaire de pilotes ODBC]]
Échec SQLAllocHandle du pilote sur SQL_HANDLE_ENV
Type d'erreur :
ADODB.Recordset (0x800A0E7A)
Impossible de trouver le fournisseur. Il est peut-être mal installé.
Quelqu'un aurait-il une solution ? Merci d'avance
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Connecting Oracle 9i database from ASP, VbScript [message #100865 is a reply to message #100551] |
Mon, 26 January 2004 11:15  |
Dhaneht
Messages: 1
Registered: January 2004
|
Junior Member |
|
|
I've the same problem. I'm doing my own research and found out the suggested solutions:
1. Install MDAC (now 2.8 is the latest)
2. Set DSN correctly
3. Register DLL (MSDASQL.DLL, and some oracle DLL)
4. Change permission of folder that install the oracle to everyone to have full control.
5. Install JetEngin (now 4.0 is the latest)
And the result is..... it doesn't work.!!!!!!
Help me
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
