Can SQL express be accessed by Oracle Transparent Gateway ?

Hot Topic

Restoring .cab file
Security consideration for Pull Subscription
Can SQL Server 2005 Express coexist with SQL Server 2005 developer edition?
How to reference different databases on different servers in one query
how do i backup my users + passwords?
Textboxes causing empty columns and rows in Excel export
Shortcut to hide the results pane in Query editor
Trying to deploy reports accessing Oracle server
Trimming characters
Column Graph

SQL Server

New SQL-NS 2005 Book
Setup failed - no package <sqlncli.msi>
Beginner Q: Pocket PC access to SQL Server 2005
Database Diagrams - SQL Server 2005 Express
Select Distinct
a connection could not be made to the data source
Names of the collumns
Log Folder Creation
Calculations on members and aggregation
Display report parameter in report

Can SQL express be accessed by Oracle Transparent Gateway ?

Able to access SQL express remotely using SQL mgt Studio after certain configuration.

But notice that I must use IP address/SQLEXPRESS for server name in order for connection to work. What is this "/SQLEXPRESS" Is it a standard surfix for SQL Express

I have installed the Oracle Transparent Gateway on the machine with SQL Express and setup the tnsname for SQL Express. For the tnsname, have used IP address/SQLEXPRESS as the host name but it gave this error :

ORA-28545: NCRO Failed to make RSLV connection

Tried with just the IP address and it gives the same error.

Any idea Help !



Answer this question

Can SQL express be accessed by Oracle Transparent Gateway ?

  • Hiran55681

    I check the SQL Server configuration manager and it shows that the instance name is MSSQL.1. So which one is the instance name

  • holstad

    Hi,

    What is this "/SQLEXPRESS"

    That si the instance name, as you can deploy several instances (liek in Oracle on one machine, with the difference that one instance can have more than one database :-) ), the instances are bound to a port, if it is not the default port (1433), you have to specify it, either within the connectionstring are in your Gui.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • Can SQL express be accessed by Oracle Transparent Gateway ?
Answer this question