I have PWS and SQL Server 2000 installed on my local machine. I have
created as asp that returns a recordset successfuly from SQL Server using
a dsn with a SQL driver. I have an Oracle db on a remote NT box that I
would like to query. I have created a couple of dsn entries for this
instance, but the asp bombs. I have tried using the Microsoft ODBC for
Oracle and Oracle73(NT) drivers. The error I receive when using the Oracle
driver is:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 126
Oracle73 (NT)).
The error with the MS for Oracle driver is:
The Oracle client and networking components were not found.....
I can use these dsn entries fine with Access 2000 and Developer 2000 ODBC
Test program. For the asp to work with SQL Server, I had to create a user
called iusr_(localpc). Do I need to create a userid in the Oracle db?
Sorry for the long message, but any help will be appreciated.
--doug--