大侠,救命啊,已经2周了,就这个问题,我始终没法连接到Suse Hana Server上:主机:win7
Hana Server: SUSE Linux Enterprise 11 64-bit HANA SP4
(1)可能是刚开始不会弄,我发现ODBC里面有3个hdbodbc,不知道是不是有影响?
List of installed drivers
1. SQL Server; %WINDIR%system32SQLSRV32.dll
2. Oracle in OraDb11g_home1; D:appbabyproduct11.2.0dbhome_2BIN
SQORA32.DLL
3. SQL Server Native Client 10.0; C:Windowssystem32sqlncli10.dll
4. HDBODBC; C:Program FilessaphdbclientlibodbcHDB.dll
5. HDBODBC_002; D:BaiduYunDownloadhana.client.studioSAP_HANA_CLIENTl
ibodbcHDB.dll
6. HDBODBC_003; C:Program FilessaphdbclientlibodbcHDB.dll
(2)我Hana的服务器名为hanadb(192.168.0.30),从主机cmd中能ping到IP,但是开始ping不到hostname,后来我看有人说在etc/hostc里面添加192.168.0.30 hanadb,然后我添加了,现在也能ping到hanadb了,可是我用studio连接,却一直连接不上。。错误如下:
com.sap.ndb.studio.jdbc.JDBCConnectionStatus: Database connection is not available. See error log for more details.
at com.sap.ndb.studio.jdbc.JDBCPlugin.createConnection(JDBCPlugin.java:330)
at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.executeTryJDBC(SAPSystemObjectUpdate.java:258)
at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.execute(SAPSystemObjectUpdate.java:86)
at com.sap.ndb.studio.navigator.operations.UpdateSAPSystemOperation.execute(UpdateSAPSystemOperation.java:72)
at com.sap.ndb.studio.datamodel.controler.DataModelOperationJob.run(DataModelOperationJob.java:70)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://hanadb:30015 [Cannot connect to host hanadb:30015 [Connection refused: connect], -813.].
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:219)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:203)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:186)
at com.sap.db.jdbc.Driver.connect(Driver.java:238)
at com.sap.ndb.studio.jdbc.JDBCPlugin$3.run(JDBCPlugin.java:642)
我使用的用户名为system,密码是HANAabc123(我不确定密码是不是正确,但是下载Suse Hana server的帖子里面说是这个密码)。
先谢谢了!!
收起