by Dan » Tue, 13 Jan 1998 04:00:00
We have some developers working on our intranet right now. They are using
asp for a frontend app to do query on our NT oracle database. Right now we
cannot get asp to connect to the oracle database. I receive a
authentication not initialized error. If anyone can help me with this I
would greatly appreciate it. I am beginning to get frustrated with this
problem.
Thank you
1. IMPOSSIBLE TASK: Connect to Oracle 8 database using Active Server Pages
I am finding it utterly impossible to connect to an Oracle 8 database using
Active Server Pages. I've read every piece of literature I can find on this
subject, am familiar with all the known bugs, have followed all suggestions,
input supposedly-working example code verbatim, an it still will not work.
Would appreciate any info, email preferred, will post followup with fixes if
there is indeed a fix.
Mark Alsip
Contractor to KY Dept of Insurance
-----*** My environment:
Windows NT V4/SP3.
Oracle 8.0.5 server & ODBC driver (with 8.0.51b patch applied to ODBC).
Also have Microsoft MDAC V2 with their ODBC driver for Oracle.
IIS V3 with Active Server Pages.
All above run on the same system.
32-bit DSN's defined for both Oracle and Microsoft ODBC connections to
target database.
-----*** Tests:
Oracle ODBC test against both DSN's works perfectly.
Database can be accessed flawlessly via Visual Basic and either ODBC
driver installed on a client
machine across the network.
Database can be accessed locally and across the network using SQL
Worksheet or SQL Plus
-----*** My ASP code snippet using Microsoft ODBC driver for Oracle:
Set db = Server.CreateObject("ADODB.Connection")
db.open "DSN=KYDOI_MS;UID=DOI;PWD=blahblah;"
This code fails with:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV
failed
-----*** My ASP code snippet using Oracle driver:
Set db = Server.CreateObject("ADODB.Connection")
db.open "DSN=KYDOI;UID=DOI;PWD=blahblah;"
This code fails with:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5 (Oracle ODBC
Driver).
2. Run time error 3170 Couldn't find installable ISAM
3. SQL Server Authentication via Active Server Pages
4. Batch Job on Clinet Side, Performance Monitor and Tools for S
5. Weird Error connecting to SQL Server from Active Server Pages
6. 15256-TX-DALLAS-ORACLE-SQL-res
7. VB5 and Access via Active Server Pages
8. SQL 7.0 Client Utilities - Install Only
9. Informix via Active Server Pages
10. Java Server Pages/Servelets vs Active Server Pages
11. LU62 CONNECTION TO IBM DB2 VIA SQLNET ORACLE NT SERVER 7.3.3
12. Problems with SQL-Server 2000 Active/Active Cluster accessing via DNS name
13. Help regarding sqlnet 2.3 applications vs Oracle 8.0