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

110 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
    Replies
    1. IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Projects for CSE It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

      JavaScript Online Training in India

      JavaScript Training in India

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  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. A useful knowledge for us. Thank you for sharing this post. keep post.astrologer in Delhi

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

    ReplyDelete
  9. 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


  10. 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
  11. 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
  12. 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
  13. 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

  14. Our line by line punjabi song lyrics generator is great for writing and fine-tuning songs and raps, especially when you want them to rhyme. Unlike our other song lyrics.

    ReplyDelete


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

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



    ReplyDelete
  16. I have read lots of articles but this article really provide great information. I thanks to author to provide such a informative pageVidMate app supports over 200 platforms to download movies and videos.

    ReplyDelete
  17. Interesting information and attractive.This blog is really rocking... Yes, the post is very interesting and I really like it.I never seen articles like this. I meant it's so knowledgeable, informative, and good looking site. I appreciate your hard work. Good job.
    Kindly visit us @
    Sathya Online Shopping
    Online AC Price | Air Conditioner Online | AC Offers Online | AC Online Shopping
    Inverter AC | Best Inverter AC | Inverter Split AC
    Buy Split AC Online | Best Split AC | Split AC Online
    LED TV Sale | Buy LED TV Online | Smart LED TV | LED TV Price
    Laptop Price | Laptops for Sale | Buy Laptop | Buy Laptop Online
    Full HD TV Price | LED HD TV Price
    Buy Ultra HD TV | Buy Ultra HD TV Online
    Buy Mobile Online | Buy Smartphone Online in India

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

    ReplyDelete
  19. 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
  20. 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
  21. I really loved reading your article. It was really good work. Thank you very much! By the way, you can download movie on Vidmate download for free.

    ReplyDelete
  22. 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
  23. 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
  24. This comment has been removed by a blog administrator.

    ReplyDelete
  25. Superb post, we enjoyed each and everything as per written in your post. Thank you for this informative article because it’s really helpful, I really like site.
    Please visit our website: Packers And Movers Mumbai

    ReplyDelete
  26. 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
  27. To be honest your article is informative and very helpful. Hp Laptop | Hp laptop online price

    ReplyDelete
  28. 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
  29. 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
  30. 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
  31. 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
  32. Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. how to start an online payment processing company

    ReplyDelete
  33. 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
  34. 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
  35. Thanks for this information I really appreciate.

    taxparamarsh

    ReplyDelete