469,270 Members | 1,796 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

ASP ORACLE Connectivty issues

2
Hi,
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={Microsoft ODBC for Oracle}; CONNECTSTRING=dbname; uid=userid;pwd=password;"

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

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.Createobject ("ADODB.connection")
DBH.Open strConnect
if DBH.state <> 1 then
response.write "daggone cannt connect!<BR>"
else
response.write "ok we gotta conection <BR>"
objCommand.CommandText = Query
objCommand.ActiveConnection = DBH
set objRS = objCommand.execute
if objRS.eof then

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

4 connects but gets a different errro on objCommand.execute
Error Type:
RDSServer.DataFactory (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.execute is loses connection
Microsoft ADO/RDS (0x800A1003)
Cannot connect to server.
4 Connects but at objCommand.execute
RDSServer.DataFactory (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 4742
Provider=MSDAORA.1;User ID=urdid;Password=urpwd;Data Source=urdatasource;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

Post your reply

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

Similar topics

3 posts views Thread by Jake McDermott | last post: by
133 posts views Thread by jonathan | last post: by
1 post views Thread by Cliff Cooley | last post: by
5 posts views Thread by NormaJean Sebastian via DBMonster.com | last post: by
13 posts views Thread by BigDaDDY | last post: by
4 posts views Thread by ljubo lecic via AccessMonster.com | last post: by
9 posts views Thread by Steve Kershaw | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.