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.

- 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
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


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