Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Environment:
- Oracle 10g database over a windows 32bit 2003 server - SQL 2005 database over a windows 32 bit 2003 server.

I am trying to connect the above databases through heterogeneous services. I have updated the following files: TNSNames.ora, Listener.ora and hs.ora. When performing a test connection from SQL developer, I get the following error - ORA 28500 - indicating that the login for SA user is incorrect.

I also tried using another authenticated user that has rights to the database.

I can successfully connect with SQL 2000.

Has anyone experienced such a problem before?

share|improve this question

1 Answer 1

We have an Oracle 10g database that is connected to a SQL Server 2005 instance (similar set up - 32bit on Windows 2003). We are using the Oracle 10g Transparent Gateway for SQL Server without issue.

Unfortunately I can't speak to Heterogeneous services. But if you can make the change in your environment, you may want to look into Gateways, I believe it's a free download on OTN.

Documentation: http://download.oracle.com/docs/cd/B19306_01/gateways.102/b14270/toc.htm

share|improve this answer
2  
Just because you can download it for free doesn't mean you can use it for free. The MS SQL Server Transparent Gateway from Oracle is quite expensive. oracle.com/us/corporate/pricing/… –  REW Oct 28 '10 at 4:35
    
Thanks for clarifying. –  SQL3D Oct 28 '10 at 15:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.