Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

sqlcli=> * -10709: Connection failed (RTE:database not running: no request

I am getting this error at the following points:

First when I login into the demodb by giving command, i don't get any error.

$ sqlcli -u MONA,RED -d DEMODB

and then try giving the following select command.

sqlcli=> SELECT zip, name, state FROM hotel.city WHERE name = 'Seattle';

  • -10709: Connection failed (RTE:database not running: no request pipe) SQLSTATE:

Thinking that i have not connected to the database i give the foll command

sqlcli=> \c localhost -d DEMODB -u MONA,RED

then also i get the same error again.

But if i run the example program HelloWorld.cpp though SQLDBC which connects to DEMODB and show a simple 'Hello SAP DB' from DUAL table, i don't get any error which makes me assume database DEMODB is actually running.

Can someone help ?

I am from oracle background and new to MaxDB. In oracle when we use sqlplus username/pasword@ORACLE_SID and that goes through without any error, we know we can give SQL commands to the db. However while using sqlcli and it is not throwing any error at the time of logging in but throwing the error at the time of executing sql commands is confusing me.

Thanks in Advance for the help.

Regards

Raj

Former Member
replied

>

> First when I login into the demodb by giving command, i don't get any error.

>

> $ sqlcli -u MONA,RED -d DEMODB

>

> and then try giving the following select command.

>

> sqlcli=> SELECT zip, name, state FROM hotel.city WHERE name = 'Seattle';

> * -10709: Connection failed (RTE:database not running: no request pipe) SQLSTATE:

Yep - sqlcli does not immediately connect to the database.

After you get the "sqlcli =>" prompt you may press enter and sqlcli will actually perform the connect.

And yes, I find that odd as well.

> But if i run the example program HelloWorld.cpp though SQLDBC which connects to DEMODB and show a simple 'Hello SAP DB' from DUAL table, i don't get any error which makes me assume database DEMODB is actually running.

That's quite weired.

Please check if the xserver is running and perform a

db_state

in sqlcli.

> I am from oracle background and new to MaxDB.

So welcome aboard!

>In oracle when we use sqlplus username/pasword@ORACLE_SID and that goes through without any error, we know we can give SQL commands to the db. However while using sqlcli and it is not throwing any error at the time of logging in but throwing the error at the time of executing sql commands is confusing me.

As I wrote above the connect is only performed after the first "enter".

Anyhow, sqlcli is not comparable to SQL*Plus. It's just a very simple option to access data. It's not a reporting tool, it's not an administration tool. It's not the all-in-one-can-do-everything SQL*Plus.

But why don't you use the SQL Studio or even better the DB Studio? These tools are much more comfortable to use.

regards,

Lars

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question