I am trying to use generic connectivity through heterogeneous services to use ODBC to access data from a Sybase database via Oracle. I find the Oracle documentation to be somewhat unclear and I have not been able to get databases to connect.
I have set up the ODBC drivers for Sybase on the Oracle server. I have configured the initHS_SID.ora file for ODBC.
My questions come deal with the listner.ora file and the database link. In listener.ora for an HS agent, I assumed the application hsodbc is the correct parameter for PROGRAM. Is this so, or is the agent some other piece of software.
Next, for the database link the example does not specify a Connect to username identified by password clause. Is it necessary, and if it is, can Oracle be forced to recognize lower case login ids? Any help you provide would be greatly appreciated.
I've never set up Heterogenous Services myself. But I can answer the database link question. A username and password are not required for a database link. But you can provide them. If you do not provide a userid/password, then Oracle assumes your current session's userid/password. You can for lower case logins to be recognized by placing them in double quotes.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.