OraFAQ Forum: Client Tools » Accessing data in sqlserver 2000

Home » Other » Client Tools » Accessing data in sqlserver 2000

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

Accessing data in sqlserver 2000 [message #245684]

Mon, 18 June 2007 08:21

harp
Messages: 6
Registered: February 2005

Junior Member

Hi
I'm using oralce (toad) and would like to access data in a table of sql server from oracle
I used
select * from servername.databasename.dbo.tablename (tablename is in the sql server 2000)
but could not succeed.
Does any one know how I can do this?

Thanks in anticipation

Report message to a moderator

Re: Accessing data in sqlserver 2000 [message #245686 is a reply to message #245684]

Mon, 18 June 2007 08:25

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Does TOAD knows how to connect to SQL Server?
Is this an Oracle question?
I don't see where Oracle is in what you posted.

Regards
Michel

Report message to a moderator

Re: Accessing data in sqlserver 2000 [message #245730 is a reply to message #245686]

Mon, 18 June 2007 12:22

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

select * from servername.databasename.dbo.tablename (tablename is in the sql server 2000)

I guess he trying to view this query result in oracle sqplus is it???

Report message to a moderator

Re: Accessing data in sqlserver 2000 [message #245798 is a reply to message #245730]

Mon, 18 June 2007 17:07

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Toad for Oracle can only access Oracle. In Oracle you can create a DB link to SQL server via ODBC. You need ODBC drivers for your Oracle host - if it's Windows then you already have them. Search for "Oracle hetrogeneous services". Once your DB link to SQL server is created - you can query the SQL server tables via Oracle over the link.

TOAD is also available for SQL Server
http://www.quest.com/toad-for-sql-server/

The easiest way may be to download the latest Oracle migration workbench tool (free)
http://www.oracle.com/technology/tech/migration/workbench/index.html

Report message to a moderator

Previous Topic:	sql plus report format problem
Next Topic:	How to upgrade customers DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 10:05:24 CDT 2025