SQL Anywhere database - Dbeng9 "database server not found" error

Author

Dbeng9 "database server not found" error

Igor Vodov

2005-05-27, 8:23 pm

I have started dbsrv9 successfully.
When I try to use dbeng9 from the workstation machine to connect to that
server,
I get error "Database server not found". If I start the dbeng on the same
machine where
the server is started, it works fine. What could be the problem?

Thanks

Greg Fenton

2005-05-27, 8:23 pm

Igor Vodov wrote:
> I have started dbsrv9 successfully.
> When I try to use dbeng9 from the workstation machine to connect to that
> server,
> I get error "Database server not found". If I start the dbeng on the same
> machine where
> the server is started, it works fine. What could be the problem?
>

I'm confused. You are using "dbeng9" to connect to a running "dbsrv9" ?
This makes no sense as both are database engines (dbeng9 is the
"personal server" and dbsrv9 is the "network server").

You should be trying to connect using a database *client* application
such as DBISQL, dbping, Sybase Central or your own application that uses
the SQLAnywhere client libraries.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Igor Vodov

2005-05-27, 8:23 pm

Actually, dbping and dbisql cannot connect to the running server either.
I just thought that I would take it a step further and try to use dbeng9.

Igor.

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:42978535$1@foru
ms-2-dub...
> Igor Vodov wrote:
>
> I'm confused. You are using "dbeng9" to connect to a running "dbsrv9" ?
> This makes no sense as both are database engines (dbeng9 is the "personal
> server" and dbsrv9 is the "network server").
>
> You should be trying to connect using a database *client* application such
> as DBISQL, dbping, Sybase Central or your own application that uses the
> SQLAnywhere client libraries.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Breck Carter

2005-05-27, 8:23 pm

Show us how you start dbsrv9 and dbisql.

For example, if you start dbsrv9 like this:

" %ASANY9%\win32\dbsrv
9.exe" -x tcpip ddd.db

....the "SQL Anywhere server name" (ENG) and "SQL Anywhere
database name" (DBN) will both default to ddd, and you can
start dbisql like this:

" %ASANY9%\win32\dbisq
l.exe" -c
" ENG=ddd;DBN=ddd;UID=
dba;PWD=sql"

If necessary, you can specify the server machine IP address:

" %ASANY9%\win32\dbisq
l.exe" -c
" ENG=ddd;DBN=ddd;UID=
dba;PWD=sql;LINKS=TC
PIP(HOST=123.123.123.123)"

Breck

> Actually, dbping and dbisql cannot connect to the running
> server either. I just thought that I would take it a step
> further and try to use dbeng9.
>
> Igor.
>
> "Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in
> message news:42978535$1@foru
ms-2-dub...
> to connect to that >> server,
> the dbeng on the >> same machine where
> the problem? >>
> dbsrv9 is the "network server"). >
> SQLAnywhere client libraries. >
>
>

Greg Fenton

2005-05-30, 9:23 am

Igor Vodov wrote:
> Actually, dbping and dbisql cannot connect to the running server either.
> I just thought that I would take it a step further and try to use dbeng9.

Along with Breck's answer, try using dbping and specify the LOG
connection parameter options as well:

dbping -d -c " dsn=MY_DSN;LOG=C:\db
ping_log.txt"

After a failed attempt, take a look at the log file (C:\dbping_log.txt)
and see what is indicated in there. If you are unsure, post that file
along with your response to Breck's questions.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links