connect to sql server using toad for oracle

Gave it a try.it isnt working but I may be missing something very basic You know have a DB Link to the SQL Server and can run queries on it.Tom, I know DBLINKs can be created like that but never tried from sqlplus (until I read this) SQL> create database link mysqlserverdsn connect to sa identified by using 'MYSQLSERVERDSN' Create a Database Link within your Oracle Database to the SQL Serer database. $ORACLE_HOME/network/admin/tnsnames.ora altered file: (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)) $ORACLE_HOME/network/admin/listener.ora altered file: # This is a sample agent init file that contains the HS parameters that are needed for an ODBC Agent. $ORACLE_HOME/hs/admin/initMYSQLSERVERDSN.ora altered file: Create your own initialization file, pointing to the SQL Server DSN. Oracle provides a sample initialization file in the following directory:Ģ. Create a Heterogeneous Services Initialization Fileġ.

Configure your database settings and click next until wizard is complete.ī. Give the connection a name (MYSQLSERVERDSN), description, and server information. Click Start | Control Panel | Administrative Tools | Data Sources (ODBC )Ģ. Create a DSN (Data Source Name) for the SQL Server connection.ġ. Once it is established, you will be able to query the SQL Server database through Toad for Oracle.Ī. The following is a guideline in doing so. Please have your DBA or network admin configure the settings to create the DB Link. Storage Performance and Utilization ManagementĬreating a DB Link from an Oracle Database to a SQL Server database is not a Toad for Oracle issue.Information Archiving & Storage Management.Hybrid Active Directory Security and Governance.

Starling Identity Analytics & Risk Intelligence.

One Identity Safeguard for Privileged Passwords.

Connect to sql server using toad for oracle