DB Link to access SQL Server through Oracle Error

I am struggling to get an HS link to work to access an SQL Server db

I have:
configured tns and listener
hs.init file
configured and sucessfully tested odbc link

yet get error:
ORA-28545 error diagnosed by Net8...

Any pointers on how to solve?
55murphy55Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DavidSenior Oracle Database AdministratorCommented:
What is the Net8 NCRO error message?  You might provide the referenced files
0
OP_ZaharinCommented:
- what is you oracle version and os platform?
- also do you have oracle_home entry in the environment variables? to which path it refers to?
- have you bounce your listener after setting up the HS?

- can you also share the link to the doc/article that you refer to when preparing the HS?
0
tangchunfengCommented:

don't use HS
use this instead:
Oracle Database Gateway for SQL Server
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
OP_ZaharinCommented:
- the reason i ask for the OS platform is that, if its a 64bit OS, the asker need to use Oracle Gateway because HS is not supported on 64bit. if its a 32bit, HS is sufficient.
0
55murphy55Author Commented:
Many thanks - problem solved with gateway!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.