OraFAQ Forum: Networking and Gateways » Domain Connectivity Issue

Home » RDBMS Server » Networking and Gateways » Domain Connectivity Issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Domain Connectivity Issue [message #280484]

Tue, 13 November 2007 18:05

grahambo
Messages: 9
Registered: November 2006

Junior Member

Hi All

Im having an issue accessing a Database.

I am running an oracle 9i database on a windows 2000 server Machine which is a member of a domain.

I wish to access that database on this machine using a web application (hosted on IIS) which is running from a Windows XP professional Machine that is not part of the domain.

I keep getting an error saying cannot connect to database.

Strange part is I have installed the oracle 9i client and can access the database using the "test login" option.

I know if I add the XP mahine to the Domain it will be able to access the Database fine, so I'm assuming this has something to do with permissions. can you explain to me exactly what to do to get around this?

Cheers

Graham

Report message to a moderator

Re: Domain Connectivity Issue [message #280485 is a reply to message #280484]

Tue, 13 November 2007 18:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I know if I add the XP mahine to the Domain it will be able to access the Database fine
Have you actually added this system to the domain & verified that the web application successfully access the Oracle DB?

See, I have serious doubts you claim reflects reality.
In some/many/most cases, an "Application Server" sits between the web server (Apache, IIS, etc) & Oracle RDBMS.

Based upon what you've posted, I wonder exactly how IIS is supposed to inter-operate with the Oracle DB.

Report message to a moderator

Re: Domain Connectivity Issue [message #280603 is a reply to message #280485]

Wed, 14 November 2007 03:44

grahambo
Messages: 9
Registered: November 2006

Junior Member

ok IIS has been installed on the XP machine and the website is running on it.

so I go http://localhost/mysite to access the web site which is being hosted on the XP machine

I should have made it clearer sorry, I am using this machine for testing purposes.

So to sum up the IIS webserver is not on our domain but the database is. My web application cannot access it. however I can test the connection in net manager on the which is hosting the wesite and it works ok with correct user name and password.

[Updated on: Wed, 14 November 2007 04:01]

Report message to a moderator

Re: Domain Connectivity Issue [message #280604 is a reply to message #280603]

Wed, 14 November 2007 04:00

grahambo
Messages: 9
Registered: November 2006

Junior Member

Solution

in the sqlnet.ora file I commented out

Names.Default_Domain = mydomain

the web app was then able to connect to the DB. dont ask me why this worked, I have no idea. prehaps someone could enlighten me. my earlier post of an in correct connection string turned out to be incorrect.

Graham

[Updated on: Wed, 14 November 2007 09:23]

Report message to a moderator

Previous Topic:	the advantage of tnsnames.ora
Next Topic:	not able to access thro db link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 14:49:13 CDT 2025