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


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

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy