Thursday, March 10, 2016

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: Unable to load driver manager

When trying to create “Remote source” to Microsoft SQL Server under Smart Data Access (SDA) using HANA received following error

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: Unable to load driver manager 

By looking the error it looks like the driver does not exists or not installed properly.  To find out the driver install or not run below command, if you receive an error then its not installed.

#isql --help
SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [unixODBC][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Login failed for user 'hanasdauser'. 

I have followed below steps to install the Drivers

1. Set the environment
# cd /hana/ms-odbc-driver/unixODBC-2.3.0
# export CPPFLAGS=”-DSIZEOF_LONG_INT=8”
# echo $CPPFLAGS
-DSIZEOF_LONG_INT=8

2. Configure
#./configure --prefix=/usr --libdir=/usr/lib64 --sysconfdir=/etc --enable-gui=no --enable-drivers=no --enable-iconv --with-iconv-char-enc=UTF8 --with-iconv-ucode-enc=UTF16LE

3. Run make utility
# make

4. Run make install
# make install

5. Test the driver is installed or not
# isql –help
unixODBC 2.3.0

After installing the driver I was able to create Remote Source in HANA under SDA.

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

59 comments:

  1. I appreciate this post and its seems looking so informative Thanks for sharing with us..
    http://packersmoversbangalore.in/
    http://blog.packersmoversbangalore.in/
    We Provide Best Packers And Movers Bangalore List for Get Free Best Quotes, Compare Charges, Save Money And Time, Household Shifting Services.

    ReplyDelete
  2. Thanks for sharing. I hope it will be helpful for too many people that are searching for this topic.
    Movers and Packers Delhi
    Movers and Packers Gurgaon
    Movers and Packers Mumbai

    ReplyDelete
  3. This comment has been removed by a blog administrator.

    ReplyDelete
  4. If you want to get in touch with dealkare packers and movers in Uttam Nagar, You must visit our website www.dealkare.com

    Packers and movers in uttam nagar

    ReplyDelete
  5. Thanks on your marvelous posting! I really enjoyed reading it, you’re a great author.Please visit here:
    Packers And Movers Hyderabad

    ReplyDelete
  6. Love Problem Solution Baba Ji. Ask Free Question Related To Love Problem Solution, Inter Caste Love Marriage, Love Problem Solution, Vashikaran Solutions, Business Problem, job problem etc. We Are The Love Problem Solution Baba Ji. We Will Be Happy To Answer You Free Of Cost. All Days We Are Available To Help You. For More Information Visit Our Website www.Lovevashikaranexpert.In
    Reach The Love Problem Solution Baba Ji +91 9915707766
    Are you in love with someone? Is your family not accepting the partner? love problem solution baba ji will help you here. He will give all the tips to get back your love. There are ways to make your family convinced as well. He understands your problem. Baba ji has solved many cases like this. All the clients of the love guru are very happy. They are staying happily with their loved one. Some of them are also married with the person whom they love. The love problem solution baba ji is the key for your solution.
    Background Of Love Problem Solution Baba Ji
    You must be eager to know about the background of Baba ji. This is properly mentioned in the website. Yes, the baba ji is having his official website. The history of love guru is mentioned there. He solved many cases just after his recognition as an astrologer. There are hardly any case where he has proved to fail. The love problem solution baba ji has maximum success rate. Just visit his website and you will know everything about him.
    Behavior Of Love Problem Solution Baba Ji
    Many people are afraid to visit the astrologers. Do you know why? It is just because the words of astrologers are harsh. They may say some negative facts about you. Even the behavior of some aged astrologers may not be up to the mark. But, you don’t have to worry when the person is love problem solution baba ji. He is totally different. He is not like any other conventional astrologers in the market. He will speak with you just like a friend. You will automatically speak about your problems to him. You will understand very well about his manner and behavior. For more information please visit our website : http://www.lovevashikaranexpert.in Call +91 9915707766

    ReplyDelete
  7. A useful knowledge for us. Thank you for sharing this post. keep post.astrologer in Delhi

    ReplyDelete
  8. I am looking for the such a grateful post. This post fulfills my requirement. Thanks for sharing. Also visit the site. Astrologer in Delhi

    ReplyDelete
  9. Nice post. Thank you for sharing this useful information. indian Vedic palmistry

    ReplyDelete
  10. The Hindu religion has three basic practices. They are puja or worship, the cremation of the dead, and the rules and regulations of the caste system. Hinduism is not a proselytizing religion since you cannot be converted: you’re either born a Hindu or you’re not. Significant differences exist within this Hindu majority, arising not only out of divisions of caste, but also out of differing religious beliefs. One great divide is between devotees of the god Vishnu and devotees of the god Shiva. There are also Hindus who are members of reform movements that began in the 19th century.
    The most significant of these is perhaps the Arya Samaj, which rejects divisions of caste and idol worship. Hindus may come together also as devotees of a guru, such as Sai Baba. Despite its differences, the Hindu community shares many things in common. Islam- there are more than 100 million Muslims in India (approximately 12% of the population), making it one of the largest Muslim nations on earth. Muslims are a more urban community than Hindus. There are many towns and cities in northern India where Muslims are one-third or more of the population. In addition to Jammu and Kashmir and the Lakshadweep islands, where more than two-thirds of the population is Muslim, major concentrations of Muslims live in Assam, West Bengal, Uttar Pradesh, and Kerala states. About one-quarter of all Muslims living in India live in the state of Uttar Pradesh. Muslim influence in India is particularly strong in the fields of architecture, art and food. Buddhism- Buddhism was founded in northern India in about 500 BC, spread rapidly when emperor Ashoka embraced it but was gradually reabsorbed into Hinduism. Today Hindus regard the Buddha as another incarnation of the Hindu god Vishnu. There are now only 6.6 million Buddhists in India, but important Buddhist sites in northern India, such as Bodhgaya, Sarnath (near Varanasi) and Kushinagar (near Gorakhpur) remain important sites of pilgrimage.
    Jain- The Jain religion also began life as an attempt to reform Brahmin cal Hinduism. It emerged at the same time as Buddhism, and for many of the same reasons. The Jains now number only about 4.5 million and are found predominantly in the west and southwest of India. The religion has never found adherents outside India. Jains believe that the universe is infinite and was not created by a deity. They also believe in reincarnation and eventual spiritual salvation by following the path of the Jain prophets. Sikhs- The Sikhs in India number 18 million and are predominantly located in the Punjab. The religion was originally intended to bring together the best of Hinduism and Islam. Its basic tenets are similar to those of Hinduism with the important modification that the Sikhs are opposed to caste distinctions. The holiest shrine of the Sikh religion is the Golden Temple in Amritsar. Other- approximately 3% of the population is Christian and there are also a few small Jewish communities in ex-colonial enclaves. India’s population is rich with diverse ethnic and cultural groups. Ethnic groups are those based on a sense of common ancestry, while cultural groups can be either made up of people of different ethnic origins who share a common language, or of ethnic groups with some customs and beliefs in common, such as castes of a particular locality. The diverse ethnic and cultural origins of the people of India are shared by the other peoples of the Indian subcontinent, including the inhabitants of Pakistan, Bangladesh, Nepal, Bhutan, and Sri Lanka. People of India – The overwhelming majority of India’s population shares essentially the same physical characteristics. There is no concrete scientific evidence of racial differences within this majority, although there are ethnic and cultural differences, such as language and religion. Tribal Groups. There are also groups of people in India that have been identified by the government as tribal, meaning they belong to one of the more than 300 officially designated “scheduled tribes”.

    ReplyDelete


  11. We also provide deep cleaning services for houses, villas, apartments and furnishings, and use of garden steam cleaners that clean and eliminate germs.
    You can see more of this link:
    شركة الاول للتنظيف و مكافحة الحشرات
    شركة مكافحة حشرات بالرياض شركة مكافحة حشرات بالرياض
    شركة رش مبيدات بالرياض شركة رش مبيدات بالرياض
    شركة رش مبيدات بالاحساء شركة رش مبيدات بالاحساء
    شركة تنظيف بالدمام

    شركة تنظيف بالدمام
    شركة تنظيف منازل بالاحساء شركة تنظيف منازل بالاحساء
    شركة تنظيف مجالس بالاحساء شركة تنظيف مجالس بالاحساء
    شركة مكافحة حشرات بالاحساء شركة مكافحة حشرات بالاحساء
    شركة مكافحة النمل الابيض بالرياض شركة مكافحة النمل الابيض بالرياض

    ReplyDelete
  12. Thanks a lot for sharing it, that’s truly has added a lot to our knowledge about this topic. Have a more successful day.
    Kulfi Kumar Bajewala Episode

    ReplyDelete
  13. Thanks a lot for sharing it, i got here huge knowledge i like you website and bookmarked in my PC
    Yeh Rishta Kya Kehlata Hai Episode

    ReplyDelete
  14. Thanks for this article. It contains the information i was searching for and you have also explained it well.
    Kasauti Zindagi Ki Episode

    ReplyDelete
  15. I am grateful to the owner of this site which really shares this wonderful work of this site.That is actually great and useful information.I'm satisfied with just sharing this useful information with us. Please keep it up to date like this.Thank you for sharing..
    website development company in patna
    packers and movers in patna
    cctv camera dealers in patna

    ReplyDelete