Hello Norman,
 
you wrote :
 
>Can you help I used your program SQL Studio when I try to make connection I enter server as 
>(local),Database as KING1,Username as username,password as password.
>when enter it gives me an error ODBC-Error:[SAP AG][SQLOD32.DLL]SAP DB]Unable to connect t return-c
>SQL_ERROR(-709) It doesn't matter what I try it always gives this error is this a programming bug or is it user fault help
 
 
One can get this error during a connect with SQLStudio mainly for two
reasons :

1. the database was offline.
this is indicated by a red colored spot in DB
Manager's database instance listing.
select the instance and press the _green_ traffic-light-like
button (not the red one as i mistyped before) to bring it to 'warm'
state.

2. the 'database manager operator' was used to connect to the db.
this account can never connect via SQL studio .
it is for administrative purposes (DB Manager) only.
use the 'database system administrator' to connect with
SQL Studio, then create
ordinary database users under this account.

(you may wish to full-text-search the mailing list archive at
http://sapdb.icf.net/cgi/talk-frame.html
for answers to frequently asked questions.)


regards,

Markus Stausberg
SAP Labs Berlin

Reply via email to