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

45 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