Home » RDBMS Server » Server Administration » Connecting to oracle
Connecting to oracle [message #193691] Tue, 19 September 2006 00:30 Go to next message
uxair
Messages: 3
Registered: September 2006
Location: Karachi
Junior Member
I want to connect to oracle that is located to another computer on intranet from Visual Studio 2005 can anyone help me out in this, any help wud be really appericiatable Thanks.
Re: Connecting to oracle [message #193696 is a reply to message #193691] Tue, 19 September 2006 00:51 Go to previous messageGo to next message
uxair
Messages: 3
Registered: September 2006
Location: Karachi
Junior Member
and I'm using Oracle9i
Re: Connecting to oracle [message #193738 is a reply to message #193696] Tue, 19 September 2006 03:47 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Can you connect to this oracle database from SQL*Plus from your local client?
Re: Connecting to oracle [message #193804 is a reply to message #193691] Tue, 19 September 2006 08:37 Go to previous messageGo to next message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Hi,

In client system you have to install the Oracle client and create the tnsnames.ora then connect to your oracle database.


Thanks,

Mohan Reddy G
Re: Connecting to oracle [message #193823 is a reply to message #193738] Tue, 19 September 2006 10:08 Go to previous message
uxair
Messages: 3
Registered: September 2006
Location: Karachi
Junior Member
JRowbottom wrote on Tue, 19 September 2006 03:47

Can you connect to this oracle database from SQL*Plus from your local client?




no, It didn't, Infact the problem is now solved by a person he uses a dll file which provides an interface for connecting vs2005 to oracle.
Previous Topic: hi
Next Topic: Rebuild index Script and Move tables to a different tablespace
Goto Forum:
  


Current Time: Wed Dec 07 02:57:30 CST 2016

Total time taken to generate the page: 0.11812 seconds