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

49 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. This comment has been removed by a blog administrator.

    ReplyDelete
  3. 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
  4. Thanks on your marvelous posting! I really enjoyed reading it, you’re a great author.Please visit here:
    Packers And Movers Hyderabad

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

    ReplyDelete
  6. 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
  7. Nice post. Thank you for sharing this useful information. indian Vedic palmistry

    ReplyDelete
  8. 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
  9. The way of you expressing your ideas is really good.you gave more useful ideas for us and please update more ideas for the learners.
    Java classes in chennai
    core Java training in chennai
    java class
    Hadoop Training in Chennai
    Selenium Training in Chennai

    ReplyDelete


  10. بسم الله الرحمن الرحيم نحن فى شركة الكمال نقوم بجميع خدمات نقل العفش والاساس بافض الطرق تحت اشراف

    فريق كبير مدرب على اعلى مستوى من المستويات مع الفك والتركيب
    شركة نقل اثاث بالطائف
    شركة نقل اثاث بجازان
    شركة نقل اثاث بحائل
    شركة نقل اثاث ونقل عفش بحائل
    والسلامة عليكم ورحمة الله وبركاته



    ReplyDelete
  11. Looking for the best site for Vidmate Download ? Vidmate Official site is the right place for you!

    ReplyDelete
  12. Excellent Blog. I really want to admire the quality of this post. I like the way of your presentation of ideas, views and valuable content. No doubt you are doing great work. I’ll be waiting for your next post. Thanks .Keep it up! Are you interested to buy luxury boxes... then click here Wallet Box | Perfume Box Manufacturer
    Candle Packaging Boxes
    Luxury Leather Box | Luxury Clothes Box
    Luxury Cosmetics Box | Shoe Box Manufacturer | Luxury Watch Box

    ReplyDelete
  13. Wow, what an awesome spot to spend hours and hours! It's beautiful and I'm also surprised that you had it all to yourselves!
    Kindly visit us @ Best HIV Treatment in India | Top HIV Hospital in India
    HIV AIDS Treatment in Mumbai | HIV Specialist in Bangalore
    HIV Positive Treatment in India | Medicine for AIDS in India

    ReplyDelete
  14. TreasureBox is operated by a group of young, passionate, and ambitious people that are working diligently towards the same goal - make your every dollar count, as we believe you deserve something better.
    laptop table
    shoe storage nz
    outdoor furniture covers nz

    ReplyDelete
  15. Amazing blog. Thanks for your sharing.Get Likee for magical short video making and sharing. Join the big community, get to know more about the world and make new friends.

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

    ReplyDelete
  17. Thanks For Sharing The Information The Information Shared Is Very Valuable Please Keep Updating Us Time Just Went On Reading The article
    by cognex offers AWS Training in chennai

    ReplyDelete
  18. To be honest your article is informative and very helpful. Hp Laptop | Hp laptop online price

    ReplyDelete
  19. A debt of gratitude is in order for sharing the information, keep doing awesome... I truly delighted in investigating your site. great asset. Learn SEO

    ReplyDelete
  20. I’m excited to uncover this page. I need to to thank you for ones time for this particularly fantastic read!! I definitely really liked every part of it and i also have you saved to fav to look at new information in your site. f95zone

    ReplyDelete
  21. Hey! your content is completely awesome, i really appreciate your effort that you put on this.
    You can also check my link below:
    Important IPC Section

    ReplyDelete
  22. I like your post. It is good to see you verbalize from the heart and clarity on this important subject can be easily observed...
    pagalworld

    ReplyDelete
  23. Your post is very helpful and information is reliable. I am satisfied with your post. Thank you so much for sharing this wonderful post with us. Merchant Services Agent Program

    ReplyDelete
  24. In the smarter system, Besides getting help from technology, we are also benefited for the purpose of entertainment. With the IPTV reseller panel, you can know about different cultures worldwide. Get the best service from PANDAR IPTV providers.

    ReplyDelete
  25. Thanks for this information I really appreciate.

    taxparamarsh

    ReplyDelete
  26. I found some useful information from this article, thanks for sharing the useful information. Explore Ziyyara Edutech’s best online tutoring sites for Class 11, offering private tuition classes designed to help you excel in chemistry and other subjects.
    For more info Contact us: +91-9654271931, +971-505593798 or visit Online tutoring sites for class 11

    ReplyDelete