Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Please Help - Trying a simple query against Oracle


Message #1 by dag@i... on Mon, 11 Jun 2001 22:24:18
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--

  Return to Index