OraFAQ Forum: Networking and Gateways » connecting Oracle to SQL server

Home » RDBMS Server » Networking and Gateways » connecting Oracle to SQL server (Oracle 8.0.4, Windows NT)

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

connecting Oracle to SQL server [message #533668]

Thu, 01 December 2011 01:35

Arbee
Messages: 3
Registered: November 2011

Junior Member

I'm trying to make a connection to sql server from an ORACLE 8.0.4 (I know, it's ancient) but can't seem to get it to work.
I've read a lot of articles on the internet regarding the Heterogeneous Services but just can't get it to work on my system. Therefor I tried an example on connecting to an Excel workbook I found on another forum (hxxp://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4406709207206#18830681837358) but that gives me the same problem as with connecting to sql server.

Here is what I've got:
initFRUIT.ora

HS_FDS_CONNECT_INFO = SPONGE
HS_FDS_TRACE_LEVEL = OFF

LISTENER.ORA

STARTUP_WAIT_TIME_LISTENER = 0

LISTENER =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(Host = cbs_server)(Port = 1521))
    (ADDRESS = (PROTOCOL = TCP)(Host = 32.14.137.200)(Port = 1521))
    (ADDRESS = (PROTOCOL = TCP)(Host = cbs_server)(Port = 1526))
    (ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
    (ADDRESS = (PROTOCOL = TCP)(Host = cbs_server)(Port = 1433))
    (ADDRESS = (PROTOCOL=IPC)(KEY=TEST))
  )

CONNECT_TIMEOUT_LISTENER = 10

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = FRUIT)
      (ORACLE_HOME=d:\orant80)
      (PROGRAM=hsodbc)
    )
  )

TRACE_LEVEL_LISTENER = 0

TNSNAMES.ORA

JELLY.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(Host = localhost)(Port = 1521))
    (CONNECT_DATA = (SID = FRUIT))
    (HS = OK)
  )

These are results of some tests:

TNSLSNR80 status: FRUIT has 1 service handler(s)
TNSPING80 jelly: OK
When I test the Service Name Connectivity I get this: 'The test did not succeed.
ORA-12500: TNS:listener failed to start a dedicated server process'

Here's an extract from my listener.log

30-NOV-11 13:21:37 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
30-NOV-11 13:24:55 * (CONNECT_DATA=(SID=FRUIT)) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.10.0.8)(PORT=4045)) * establish * FRUIT * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12560: TNS:protocol adapter error
  TNS-00530: Protocol adapter error

One thing I noticed is that I do not have an hsodbc.exe file in my \bin, should it be there?
(I also tried Tgmsql80 in stead of hsodbc as program in Listener, resulting in an extended time of testing the connectivity but with the same result)

Is there any way I can test parts of the connection to limit the location of the problem? (e.g. does the listener get to the TNS)

Report message to a moderator

Re: connecting Oracle to SQL server [message #533672 is a reply to message #533668]

Thu, 01 December 2011 01:55

Littlefoot
Messages: 16924
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Check this topic, especially this Maaher's walkthrough.

Report message to a moderator

Re: connecting Oracle to SQL server [message #533781 is a reply to message #533672]

Thu, 01 December 2011 05:10

Arbee
Messages: 3
Registered: November 2011

Junior Member

I've read through the whole topic and links but I can only conclude that I did all the things mentioned the same way. I just can't seem to find what's different/wrong. Problem is that most topics deal with Oracle 9 and up, while there are some differences in syntax between 8, 8i and 9.
Maybe there is something missing on my oracle-server, but have no clue what it may be...

Report message to a moderator

Re: connecting Oracle to SQL server [message #533794 is a reply to message #533781]

Thu, 01 December 2011 05:41

Littlefoot
Messages: 16924
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Someone was trying to connect Oracle 8 and SQL Server earlier this year here; perhaps you could contact that person and discuss it?

Report message to a moderator

Re: connecting Oracle to SQL server [message #533806 is a reply to message #533794]

Thu, 01 December 2011 06:24

Arbee
Messages: 3
Registered: November 2011

Junior Member

Thanks for the info, I'll contact him but I doubt that's gonna help me since that topic deals with connecting an SQL server with the Oracle system.
We've got that working here too, it's the other way around that gives me a headache (connecting oracle to sql server).
I need to be able to send all changes in a table on Oracle to the SQL server and it should be online. (e.g. letting SQL server check every hour isn't sufficient)

Report message to a moderator

Previous Topic:	Temporary Error ORA-12505/ORA-12521
Next Topic:	How to Increase Oracle SQL*Net Performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 08:50:16 CDT 2013

Total time taken to generate the page: 0.12562 seconds