[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
6.2

Oracle Database with ASP/VB

Asked by srimanth in Btrieve 4GL Database

Tags: oracle, asp

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;UID=MyUserID;PWD=MyPassword;"
2. ConnectionString = "Driver={Microsoft ODBC for Oracle};Server=MyOracleData;UID=MyUserID;PWD=MyPassword;"
3. ConnectionString = "Driver={Microsoft OLE DB for Oracle};Data Source=MyOracleData;UID=MyUserID;PWD=MyPassword;"
4. ConnectionString = "DRIVER={Oracle ODBC Driver};DSN=MyOracleData;User ID=MyUserID;Password=MyPassword;"
5. ConnectionString = "Provider=msdaora;Data Source=MyOracleData.ode.state.oh.us;User ID=MyUserID;Password=MyPassword;"
6. ConnectionString = "Provider=MSDAORA;Data Source=MyOracleData;User ID=MyUserID;Password=MyPassword;"
7. ConnectionString = "Provider=MSDASQL;DSN=MyOracleData;UID=MyUserID;PWD=MyPassword;"
8. ConnectionString = "Provider=MSDASQL;DSN=MyOracleData;User ID=MyUserID;Password=MyPassword;"
9 .ConnectionString = "Provider=OraOLEDB.Oracle;Data Source=MyOracleData;User ID=MyUserID;Password=MyPassword;PLSQLSet=1"
10.ConnectionString = "Provider=Provider=MSDAORA.1;Data Source=MyOracleData;UID=MyUserID;PWD=MyPassword;"

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!!!
[+][-]04/17/03 02:42 PM, ID: 8351230Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04/22/03 08:03 AM, ID: 8373818Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04/22/03 01:13 PM, ID: 8375988Accepted Solution

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

About this solution

Zone: Btrieve 4GL Database
Tags: oracle, asp
Sign Up Now!
Solution Provided By: bhess1
Participating Experts: 2
Solution Grade: C
 
[+][-]04/23/03 04:13 AM, ID: 8379097Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04/23/03 04:19 PM, ID: 8384248Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091021-EE-VQP-81