Home > Archive > SQL Anywhere database > May 2005 > Setting up a iAnywhere DB service in Windows









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Setting up a iAnywhere DB service in Windows
Justin Houk

2005-05-27, 1:23 pm

Hi everyone!

My team has inherited some IP from another company that used
iAnywhere as its platform, and I'm doing some due diligence
to see if it makes sense for my company (Comcast) to try to
continue to use iAnywhere or move to a different solution.

To start, we're trying to recreate the steps the old team
left for us to build the system, but we're breaking down
when we try to set up a SQLAnywhere Windows service. Here's
the command I'm trying to run:

C:\>dbsvc -as -s auto -t network -y -w [server name]
"C:\Program Files\Sybase\SQL Anywhere 9\win32\dbsrv9.exe" -c
20m -n [server name] -x tcpip(PORT=2638) [DB file from
dbinit]

This command does add an Adaptive Server Anywhere instance
to the Services list in Windows, but when I try to start the
service, it fails with no errors.

I'm a complete newbie to iAnywhere, so I apologize if I'm
missing something obvious here. Any help you can give me
would be great. Thanks, and have a great holiday!

--Justin
Greg Fenton

2005-05-27, 1:23 pm

Justin Houk wrote:
> C:\>dbsvc -as -s auto -t network -y -w [server name]
> "C:\Program Files\Sybase\SQL Anywhere 9\win32\dbsrv9.exe" -c
> 20m -n [server name] -x tcpip(PORT=2638) [DB file from
> dbinit]
>
> This command does add an Adaptive Server Anywhere instance
> to the Services list in Windows, but when I try to start the
> service, it fails with no errors.
>


Two things to try:

1. Check the Event Log to see if there are any messages in there
2. Add "-o C:\some\path\asa_con
sole.txt -os 10MB" to the list of
parameters (after the "dbsrv9" but before the list of db files) so as to
capture the server's console log to asa_console.txt; then check
asa_console.txt after the startup failure

Post whatever error messages you find if you aren't sure how to resolve
them.

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

2005-05-31, 9:23 am

> Justin Houk wrote:
>
> 1. Check the Event Log to see if there are any messages in
> there
>
> greg.fenton


Good thinking, Greg! This plus some googling got me what I
needed to figure it out. Turns out a space got put into the
-x TCPIP parameter (not reflected in the statement above)
that was confusing dbsrv9.exe. Thanks!

--Justin
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com