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