473,599 Members | 3,316 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ASP ORACLE Connectivty issues

2 New Member
I was devloping on a remote corporate web server(MS XP) building webapps using simple asp. I then moved the code to my desktop(MS 2000) which also has a webserver and encountered connectivity errors. This is connecting to Oracle (9.2 on a solaris sparc 5.8) using MSDAORA. As far as I can tell both the remote webserver and the desktop use the same tnsnames file (on the lan). The databases being accessed are remote to both webservers.

Initially I tried these connection strings on the remote server
1. strConnect = "Driver={Micros oft ODBC for Oracle}; CONNECTSTRING=d bname; uid=userid;pwd= password;"

2. strConnect = "Provider= MSDAORA; Data Source=dbname; User id=Userid; password=passwo rd"

3. strConnect = "Provider= MS REMOTE; Remote_Provider =MSDAORA Data Source=dbname; remote server= IP; User id= userid; password= password"

4. strConnect = "Provider= MS REMOTE; Remote_Provider =MSDAORA Data Source= dbname; User id= userid; password= password"

I use the following code to connect and execute a query:
''on error resume next
set DBH = Server.Createob ject ("ADODB.connect ion")
DBH.Open strConnect
if DBH.state <> 1 then
response.write "daggone cannt connect!<BR>"
response.write "ok we gotta conection <BR>"
objCommand.Comm andText = Query
objCommand.Acti veConnection = DBH
set objRS = objCommand.exec ute
if objRS.eof then

1 and 2 work on the remote server
3 connects but gets the following error on objCommand.exec ute:
Error Type:
Microsoft ADO/RDS (0x800A1003)
Cannot connect to server.

4 connects but gets a different errro on objCommand.exec ute
Error Type:
RDSServer.DataF actory (0x80070005)
RDS Server Error: The server has denied access to the default RDS Handler used to access this page. See the Server Administrator for more information about server security settings.

On theDesktop none of them work:
1 cannot connect
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve service name
2 cannot connect
Microsoft OLE DB Provider for Oracle (0x80004005)
ORA-12154: TNS:could not resolve service name
3 DOES COnnect but at objCommand.exec ute is loses connection
Microsoft ADO/RDS (0x800A1003)
Cannot connect to server.
4 Connects but at objCommand.exec ute
RDSServer.DataF actory (0x80070005)
RDS Server Error: The server has denied access to the default RDS Handler used to access this page. See the Server Administrator for more information about server security settings.

Any suggestions would be appreciated
Sep 28 '06 #1
1 4915
1 New Member
Provider=MSDAOR A.1;User ID=urdid;Passwo rd=urpwd;Data Source=urdataso urce;Persist Security Info=False

Tha above connection string works fine windows 2003 server when the sqlnet.ora removed from the oracle folder and service pack 2 of win2k3 is installed on that machine. install service pack2 and restart the machine
Sep 12 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Jake McDermott | last post by:
We have a few developers that use Oracle 9i ( on their personal workstations for testing purposes. Recently, weve made the decision to upgrade them to WinXP so that they are able to use some other functionalities of the OS, but we are running into a totally odd problem with Oracle. It seems that, Installing Oracle runs just fine, and our ant scripts to build the database work well...but when we reboot the computer, the database...
by: RAK | last post by:
A client is testing a system on Oracle 9i and Win 2000 (why not 10g and 2003 etc? dont ask, long story). Performance was poor. Among other issues, we discovered that the Oracle datafiles are badly fragmented. This is fragmentation in the Windows sense of the physical file being all over the disk, not the Oracles internal file fragmentation. Each Oracle DB file is typically in several thousand fragments (I have no idea how it got that...
by: jonathan | last post by:
hey all, I realize that this question might pop up from time to time, but I haven't seen it a while and things might of changed, so - Right now (July 2004) how does mysql stand up in comparison to oracle? We are seriously considering migrating our multi-processor oracle system to mysql to save on licensing costs, and would need several features that mysql may or may not have:
by: Cliff Cooley | last post by:
Can anybody suggest what may be causing the following problem ? I have an ASP script that opens a connection to an Oracle database using a DSN connection string, such as : Set dbConn= Server.CreateObject("ADODB.Connection") dbConn.Open "DSN=somedsn; UID=someuser; PWD=somepassword" With the ASP running on an IIS 5 server, using the Oracle 8 driver to connect to an Oracle 9 database, there are no connection problems, and
by: NormaJean Sebastian via DBMonster.com | last post by:
Hi, I almost read all of the "DB2 vs Oracle" thread... The summary I got from that was all databases essentially do the same things, the decision of which one you use primarily depends on available skillsets, software vendor support, and customer/tech support. I will be facing a decision on migrating our SAP Informix database to either Oracle, DB2UDB, or Sqlserver. I don't think we are going to SqlServer. I have some Oracle...
by: BigDaDDY | last post by:
Um yeah....In case you haven't figured it out, Microsoft sucks. I'm going to be kicked back in my chair eating popcorn and watching football 10 years from now, while all you clowns are scrambling to rewrite all your code because Microsoft upgraded all their crap and nothing you wrote 10 years earlier works. It doesn't take a rocket scientist to figure out that Microsoft is unreliable. Try opening an Excel 95 spreadsheet you wrote in...
by: ljubo lecic via AccessMonster.com | last post by:
I am an experienced ORACLE software developer who met ACCESS few months ago and I must say that ,so far, I am delighted. I rapidly developed a few aplications and everything is working extremly good. Now, I am offered to develop something more complex. And It must be done in ACCESS.I feel so comfortable in ACCESS programming that I am about to accept the offer.But before my final response I URGENTLY need some advices and opinions from...
by: AnandaSim | last post by:
Hi All, I've had Access 97, 2000 connections to the corporate Oracle database for a few years now - but seldom use it. When I did use it years ago, performance was not fast but the features were good enough. Now, the version of Access is 2003 with Office SP1 applied, Windows XP against Oracle 9.2. And attached tables are real slow - 5 mins to get to datasheet view and data is incorrect - the same row is repeated several times even in...
by: Steve Kershaw | last post by:
I need your help! I'm working at a company that is considering changing from Oracle to SQL Server 2005. The debate goes on and on and on.... I need some arguments that will help me convince those who are on the fence to go to SQL Server 2005 for all new development projects. Can anybody help me with this? Steve
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...
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,...
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...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.