Hi,
I've been searching various sites and have come upon various solutions to connect to Oracle from ASP. But, unfortunately none of them work and all i am left behind is frustration. I have provided all the versions of drivers used, various connection strings used, and the various steps taken to connect.
Environment: Windows 2000/IIS5
Oracle 9i Client: 9.2.0.1.0
Oracle 9i ODBC Driver: 9.2.0.4.0
Oracle Provider for OLE DB: 9.2.0.2.0
Microsoft ODBC for Oracle (MSORCL32.DLL): 2.573.9001.0
MDAC: 2.7
1. Changed system environment variables to "C:\Winnt\Temp" and have given full rights access to IUSR_M/C and IWAM_M/C.
2. Given full access rights to to the users IUSR & IWAM to the Oracle Directory.
3. Path for Oracle Bin directory exists.
4. Created a DNS by the name "MyOracleData" in ODBC Data Sources.
5. Created an entry in TNS "MyOracleData".
6. Changing the ODBC DSN Name and TNS name didn't make a difference. So, kept them same for easier testing.
7. Created a Database project from Visual Interdev using the DSN created. I am able to see all the tables, SPs and all data.
Following are the list of connection strings used:
1. ConnectionString = "Driver={Microsoft ODBC for Oracle};DSN=MyOracleData;U
2. ConnectionString = "Driver={Microsoft ODBC for Oracle};Server=MyOracleDat
3. ConnectionString = "Driver={Microsoft OLE DB for Oracle};Data Source=MyOracleData;UID=My
4. ConnectionString = "DRIVER={Oracle ODBC Driver};DSN=MyOracleData;U
5. ConnectionString = "Provider=msdaora;Data Source=MyOracleData.ode.st
6. ConnectionString = "Provider=MSDAORA;Data Source=MyOracleData;User ID=MyUserID;Password=MyPas
7. ConnectionString = "Provider=MSDASQL;DSN=MyOr
8. ConnectionString = "Provider=MSDASQL;DSN=MyOr
9 .ConnectionString = "Provider=OraOLEDB.Oracle;
10.ConnectionString = "Provider=Provider=MSDAORA
Following are the different errors i get:
1. [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
2. Specified driver could not be loaded due to system error 5 (Oracle in OraHome92)
3. [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
4. Provider cannot be found. It may not be properly installed
5. 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.
The following was the error matchup:
1 - 1, 2 - 1, 3 - 2, 4 - 3, 5 - 5, 6 - 5, 7 - 2, 8 - 2, 9 - 4, 10 - 4.
I have worked extensively on ASP/VB/SQL Server. But, i am completely new to Oracle. I am just unable to connect to the server via IIS. I have a DLL which contains all the database access and Business Logic. All my VB applications work perfect on the same machine on which the Web Server is running. But somehow goofs up when using with IIS5. Please Help!!!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
A couple of possibilities. See:
http://support.microsoft.c
and this citation from Google
"...we had the same problem on one installation. The SQL plus was not installed on that machine, so we installed it to check the connection with it. There were no problem, and when we ran our application again it worked ok, the problem was gone!!"
And this entire thread from google:
http://groups.google.com/g
One person used the info in this article to fix the issue:
http://support.microsoft.c
Hi, srimanth
Since this is your first E-E question, you probably don't know the protocol. Once you have an answer to your question, you should 'accept comment as answer' on the comment that provided you with your final answer. This will close your question, making it available as a PAQ (previously asked question) for others to research, and will award the expert providing the answer with his 'expert points'.
General guidelines on grades can be found here:
https://secure.experts-exc
Hope that you like E-E, and enjoy your stay.
bhess1
Business Accounts
Answer for Membership
by: bhess1Posted on 2003-04-17 at 14:42:42ID: 8351230
If you are using the MS ole-db provider, then connect string is
ConnectionString = "Provider=MSDAORA;User ID=scott;password=tiger;Da
It may be good idea to use Oracle Ole-db provider instead to get full features of the Oracle database.
ConnectionString = "Provider=OraOLEDB.Oracle;
Source=<tnsname>;"
It is recommended that you not use a DSN, as this frequently leads to your error #1.
Also... From your ASP page, the the default user account does not have access permissions to the files/folders in the ORACLE_HOME directory. Check the permissions on the folder and see if the IUSR_XXX account is listed and has at least read/write/execute permissions.
Finally, check this article at MS on ASP--Oracle connectivity problems:
http://support.microsoft.c