I am able to connect to the HANA server with HANA Studio fine. version 28
However, when I try to connect to that same HANA server (HANA server instance) from Visual Intelligence I get an error “Unable to connect to the HANA server instance”.
VI is version 1.0.0 Build 313
Other co-workers in our intranet are able to successfully log in with VI with their laptops using the same userid and password.
Any ideas of what I might check on my laptop that could be causing VI to not connect successfully?
Hi Jim,
Build 313 should be correct at this point. Some questions which might help:
Do your colleagues have SAP HANA Studio installed as well? Maybe there is a driver conflict.
Have you checked the Java 64bit version is installed (not 32bit)? maybe update it?
Just to be sure the driver ngdbc.jar is installed in: C:\Program Files\SAP Visual Intelligence\Desktop\plugins\com.sap.hilo.common.hana_1.0.0.r313_v20120510\lib
Have you tried with a different Windows user (one of your colleagues logging into your laptop), maybe it is a file rights issue?
Kind Regards,
Denis
Hi Denis,
Thanks for your response.
I have both java’s installed on my laptop, 32 bit and 64
bit. After your email I uninstalled the 64 bit and downloaded the latest
and installed java 7.
My connection still doesn’t work. I didn’t reboot yet, but I will try to.
I checked the folder for ngdbc.jar and it is all there.
My colleagues have SAP HANA studio installed, the same version
28 as mine.
I also installed the SAP HANA client (I guess it just and install
for drivers). I wonder if there is a driver conflict between SAP HANA
Client and SAP HANA studio.
Let me know if you think this is possible. I’m not sure
how to “uninstall” the SAP HANA Client since it is just drivers, right?
How about registry entries? Is there anything that I
should check there?
Yes, I have had our HANA admin try to log into my machine (over
a web session) and he also got an error on my machine. He is able to
connect to HANA fine with VI on his machine.
So it doesn’t seem to be a rights issue.
Thanks, Jim Johnson
Hi Jim,
Can you enable traces before connecting and add the traces to the post please?
For example: java -jar "C:\Program Files\SAP Visual Intelligence\Desktop\plugins\com.sap.hilo.common.hana_1.0.0.r313_v20120510\lib\ngdbc.jar"
Thanks
Denis