Hi Markus
Thanks for quick reply.
connect means i can go online. i can see newlly created database in
my DBM list
(...)
but when i go to sql studio
and try to access same datebase(which i can see in DBM list) with valid user
name and password
it gives an following error
"ODBC -Error:[SAP AG][SQLOD32 DLL][SAP DB]Unable to connect
to
return-code;SQL_ERROR (-708)"
I
guess that the error number is -709 instead of -708.
One
can get this error during a connect with SQLStudio mainly for two reasons
:
1.
the database is 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' is 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
for answers to frequently asked questions.)
(you
wrote that you created an ODBC DSN to which I replied :)
>this should not be necessary for SQL
Studio,
>it installs and
registers its own ODBC drivers temporarily
>when started. (as
of V7.3 out there)
yeah thats true
but in help document of sql studio
(Logging On Using File � Connect --->2 Select a data source.
You can create this data source using the ODBC administrator. )
due to this i was wondering ,if is
there any need of dsn or not...
this is a documentation bug, thanks for
reporting it; there is definitely no need for a DSN at
all.
regards
Markus
