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.

Report message to a moderator

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

Report message to a moderator

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?

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: hi
Next Topic: Rebuild index Script and Move tables to a different tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:25:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.