Connecting to an Oracle Database using ASP

11 New Member

Hi Oracle Gurus!!

Before I proceed, as per the moderators request, I would like to mention that I have already taken a look at the other threads pertaining to a similar issue which I am having and have not found a feasible answer. I would like to apologize if there is an answer out there (I've looked at quite a few threads).

So here is the situation:

Currently, I have been using Oracle Toad from Quest Software to connect to the production database to run all my sql queries without a problem. My objective now is that I would like to query all the sql via an ASP page instead of Oracle Toad.

After creating my asp page in C:\Inetpub\wwwr oot with the following code:

<html>
<head>
<title> Time Check </title>
</head>
<body>
<%
Dim objConn
Set objConn = Server.CreateOb ject("ADODB.Con nection") ' This line creates the ActiveX Database Object

objConn.Connect ionString = "Data Source=GTMSP;Us er Id=PLATEAU;Pass word=abcde;Inte grated Security=no"

objConn.Open 'This commands the database to open

%>
</body>
</html>

I receive the following error when I run my page from http://localhost/asptestpa.asp -

------------------------------------------------------------------------------------------------------------------
Error Type:
Microsoft OLE DB Service Components (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/asptestpa.asp, line 20

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Guidant; .NET CLR 1.0.3705; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727)

Page:
GET /asptestpa.asp

----------------------------------------------------------------------------------------------------------------

Here are the configurations I have made on my machine:

(1) I went to the Microsoft ODBC Administrator and added a DSN with the following attributes under the User DSN and System DSN tab :

DataSource Name: GTMSP
Description: GTMS Production
Username: PLATEAU
Server: GTMSP.world

(2) Under the file DSN tab in Microsoft ODBC Adminstrator, I included GTMSP.dsn

(3) I know I have Ora9 components because I am able to successfully connect via Oracle Toad (thats how I do all my queries ex. Select * from pa_student...) using the following properties in Oracle Toad:

Database: GTMSP.WORLD
User/Schema: PAGGARWA
PASSWORD: *******
Connect Using Ora9

Note: I am also able to successfully connect using SQL* Plus

Note2: Initially I had the windows components error message (Oracle 0x80004005) but after speaking to the developers on our team, they mentioned that I already have the windows components.

Note3: I did install IIS on my machine and our developers told me that you can easily connect using .asp pages to the database from my machine. I do not need to have access on the production database to connect (which makes sense)

Final note: From one of the other threads, I took a look at http://www.connections trings.com for assistance for which my asp code is coded/constructed the way it is.

Any assistance is GREATLY appreciated. I have a report for senior management to turn in very shortly and without being able to connect to the database I can't query!!

I look forward to hearing from you soon. I'll be checking this site often for responses. Thank you

Aug 9 '07 #1

Subscribe Reply

2710

Similar topics

1751

difficulty connecting to networked oracle database

by: yahibble | last post by:

Now, I am no Python expert but I have dabbled and I have spent a couple of days with another engineer unsuccessfully installing oracle drivers for MS ODBC on the win XP machine. It looked to me like ODBC was the best way to get a (free) python module to upload data to an oracle database table. Aside from installing oracle clients to ODBC being a pain, I would like to consider other ways to connect. Has anyone had experiences with...

Python

3666

connecting oracle DB using ODBC

by: Mahesh.V | last post by:

Hi All I get the following error while connecting to the oracle database using ODBC. in my VB.NET application. Can any one help me out solving this problem server message (if any): "ORA-12154:TNS:could not resolve service name Thank in Advance Mahesh.V

Visual Basic .NET

3452

error rising while connecting oracle 9i

by: python_eager | last post by:

Hi i am connecting my database oracle 9i. While connecting i am getting the following error connection = cx_Oracle.connect("myusername", "mypassword", "python") RuntimeError: Unable to acquire Oracle environment handle please send the solution

Python

1626

Hard time connecting to Oracle database from Visual Web Developer 2005

by: antonyliu2002 | last post by:

I am having a hard time connecting to an oracle database from within Visual Web Developer (VWD) 2005 Express Edition. Check out the screen snap shot here: http://static.flickr.com/97/241874792_aebbadac2b_o.gif Here is the situation: 1. The oracle database runs on Machine A.

ASP.NET

5528

Connecting a GridView to an Oracle table

by: rcc.gamer | last post by:

Hello All, I am trying to connect a GridView to an Oracle table using the standard SqlDataSource. The process is fairly simple and there are detailed instructions from Microsoft ... http://msdn2.microsoft.com/en-us/library/ms178304(vs.80).aspx The problem is not accessing or displaying data from an Oracle table .... that all works great!

ASP.NET

6818

Error connecting to Oracle using PERL DBI

by: hakiran | last post by:

Hello all, I have been using Perl DBI the last 6months or so. I use it extensively with MySQL. But recently i tried to access Oracle DB with it and was having trouble. Any help would be appreciated. Here is the code and the error i get. I know the table/view do exist. Thanks all Kiran ----------

Perl

1991

When Connecting To A Remote Oracle DataBase: Socket Exception: No connection could be

by: cyberbilly1 | last post by:

Hi All! I'm trying to connect to a remote oracle database using the OracleConnection within VB.net . Whenever I try connecting I get a SocketException:No connection could be made because the target machine actively refused it. error. Currently my connectionstring is as follows: OracleConnection1.ConnectionString =...

.NET Framework

3144

C# Web Service in IIS Stops Connecting to Oracle (via ADO.NET) Over Time

by: Temporary | last post by:

C# Web Service in IIS Stops Connecting to Oracle (via ADO.NET) Over Time I have a Web Service, written in C#, published on a Windows XT Web Server under IIS, which repeatedly connects to an Oracle 9x database via ADO, processes, disconnects from the database, and exits. The Web Service is triggered by our Tibco messaging system; in our test environment, it is

Oracle Database

1801

VB connecting to oracle

by: kinnu | last post by:

hi, could any one help me with the steps of connecting the vb form with the oracle database/table. I could connect vb to access. as my collage project requires connecting of vb with oracle database/table please help me with the steps. Thanks.

Visual Basic 4 / 5 / 6

8269

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8203

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8711

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8642

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8368

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8512

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5576

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4206

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1515

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General