Home » Other » Client Tools » Accessing data in sqlserver 2000
Accessing data in sqlserver 2000 [message #245684] Mon, 18 June 2007 08:21 Go to next message
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


Re: Accessing data in sqlserver 2000 [message #245686 is a reply to message #245684] Mon, 18 June 2007 08:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Accessing data in sqlserver 2000 [message #245730 is a reply to message #245686] Mon, 18 June 2007 12:22 Go to previous messageGo to next message
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???
Re: Accessing data in sqlserver 2000 [message #245798 is a reply to message #245730] Mon, 18 June 2007 17:07 Go to previous message
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

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


Current Time: Thu Mar 28 03:48:11 CDT 2024