This is a multi-part message in MIME format.

---=_forums-1-dub4d062c24
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

I have installed Sybase ASE 15.5 Developer Edition on
Windows XP (SP3), but the following Services are not getting
started automatically or manually.

 Sybase BCKServer _ <ServerName>_BS
 Sybase MONServer _ <ServerName>_MS
 Sybase SQLServer _ <ServerName>
 Sybase Unified Agent
 Sybase XPServer _ <ServerName>_XP

Attached is the log when I executed manually the
RUN_<ServerName>.bat which gets stuck on the last line of
the log.

I would appreciate if you could help me out on the above
Services getting started.

Thanks and regards,
MAK

---=_forums-1-dub4d062c24
Content-Type: application/zip; name="ServerName.zip"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="ServerName.zip"

UEsDBBQAAAAIAI9sij3OSGDY6RAAAAhdAAAOAAAAU2VydmVyTmFtZS5sb2fd
XOtv4kgS/3wr7f9Q0n0gIxHjJxjuITHA7OUmk2RDZvdWGmnkR0N8MTZrm2S4
v/6q2ja2wUkam8w9pN1JcEy9uh6/Kndblkcy/Sfv/lVlRe4pak+RQdFGynCk
y1J/AA8sCpgPMN/Ox59G8Dn2giX4nsOCmMWwiMLVCGajL/OtbcXsy5f5b3jb
ufpV/pLfg5fej+ezr/T/dCbh5T+9cj9xukw/zVn0yCL60o8/yEIiD/V9kSf3
zHlgLoSbJBccFmEEKpBIk+vbGZwhJU1SVE3prVm0sgIWJD15rHyA2cSQYaBo
JkyGsvZOaiDG3b0XwzoK3Y2TAP6ayeBCEo5IBJiyR+aHyBhmrpd4YQDn8AEF
zK6vUBiwAhfuWJzABqUPA3/bQJA6Q+QmECZn7sh9sDyfawF+uITknoGziSIS
dsXi2Foy8AJ++VcvcMOnGK7uADXCv+P9DfiNXWudeI8MUqeAWZCwaB15qMXZ
gQnfiTFQJE3ZMUh92wmDhbcEK2IWd29cOm9lRVtYWTEyBJc9ou0EHUGRdHlH
/1crCpBDHkQuW1gbP4EFmhE6RUz8OdXvylqxv0rOYtkBvN1hYGWibSKLOwn/
3pMVQxAmEK+Z4y085kow579u6+8PkGq+Lrefr+az219mt+mfcCGtx9DDFSWH
zdZQWE9juGdHhd+bknZZ7ETeOgmjWJhgXxVY+Z5iSEZv9v4DKKZiDGD+6QZm
8+kf1d5ND93t7OIfZv9dL3dAVZa1HprYihTD6KmGovc09dz2kt71zV3vV3Tm
8WYJqgGyMdIUdD8gwRoIPCHDu+jqnuVT6KNjJlsIF5AucRcuAqeJISbheht5
y/sElKE56DYVrywFWtf3gRONIWIxWdhtItvnYL2xfS++RzPukYNN4OKyfZbm
EvpkroJvPTXyhgZf4Sk4DhfJE4Y1hUVieUGcxke+TJRhk8hyGcTMiRim6gCr
xCqNnWLpGnBPzYxhgSYHd7PG3JtRxWzixY4fxhsUC3lQVO7EJIHc0NlQ/k/v
twWzfoU70UxNDz+FGD0BrydUiCDe2P9kWJQo9GmxkshziBHaCvVH7ZN7yhVW
Xi0acLeWEWMpR5slT4wFmURlWUjTnVNm5kLbQIh34o+nyEsSFrTjnibILWWm
fQE6ce6waAeqrwfLYAVNLG+t+VLbmAA/jG8pDzx6MZm3y/EH+2at1j5qTH80
VElVB+fKsElEVOL5OmDZBZhGmDS7MKW4DLowGcNQN/pmFz7Px8JsCvyQ5vWi
UAHWHjJVJ0V4HWDBoxeF6aI+WpFHqpOuG/LkTUTfjhMrSjZrcS332V9P5ueK
8VXeY/4Vr38fAZBZrQDfwQIEFu0wTAjDBXAfIhzslNFCB6JNQBBjB7n+cQP2
xvNdUPtYi+lWjGS4sZwH0CTxTLpvgxfRCvl2FXmUMmkTtS/D5TKzfA5LYspL
+8ApX5kvmNsTy/ersiHo7DThfhF4VB+8f5EIn+bTuwmV94DxTClGz6jWIgxM
JHKNoCA1zzRxfmLJXWQFscWpfrIC1DGawCKF2E8eJmIWRdQT4DezZUyBn/WI
9/AccyZ/M2VZd2XFFkS/FblS1XbaZpiRC9CA2o1vJbTocDe5gQAzfxg9YL1Z
r7GoYHVhqxgubh71c2plBFfFeCYUuHWQzder6+nscvwbBiHZQxTEIFmjyKQ/
X+YgE+EjZmw0M/qaS+VS/mbYekuiBNd5AkC5eXPBQXocEpLnIStMf1CiP79E
e29ieDQkLCOEXzDVIOBcYc/po5/4IcIaF83vkDqLjX+EzUt8rrJl5MCEd0Ek
fBYJiBFWHu9vh0PEpk3o05qew3SLPYrnkEbLJXfsSbhah9SSo3ci8F9YyBj5
IHTi6yzKaUiW4asAV5uVjT8Rcdl+6DyghdiCAx6+5HDP0F5RPIL+sC8La1Ki
f1NQwYy1CrF7xHwUIuzDZVA0vHPNkxiHAZZzD9S5sgCzHJoUPwsiLaPcHlfy
FFahZIOgNlsmuVvOk66VWF/SblbC3ztpBLnxNnCgEy4Wommywv6XPY47N9/w
imER9XssjSH66RlnOL24nU3uLq7fgdcLBVn2JVnfWfkydeu8j/4ceL5nk0vi
XwlnwT16qi/awvZpAXNtfkU/RxZ39xEuImT5mJyOUm6WX/jqEVzEUoSuK86m
yGIzjyNcPjtJxw5rK8JqRXOGDpHehXKc5fwOCUHoHKEqripKQFHjhlk1yDMs
nxItEGIipQBXpUgJzEGreDHm3zBIO/11lqolXprm+Z1Y5JIo9OHS2lLi8rBL
JA426Zt5Gk0brsKXufAv4pcyyYTTsikpxUQB1zXe2p69Wv2OGSJDtxfvP8Gn
n1GaLCe83SxAN0aqekSzbUpqMfURnAXUt/YinXrTxvvHH07aFp+0yz1p03rS
HjQnJuoJmlbCsTxfscCJtmuuKm8JaYUm84tzVepL6iflPEg0s3/OaclKTzVB
UUYapVu4md+dYxw4sfcV3SiIY/8cUWRA9V+WhpLpg4Hx+Ei+LdpHVgR8z7AC
5aiHsjaaeMkCwqkMbudjvHG7trxImLZeGj6H1OxSQXgb+rMaq3pVMMvxD3PT
7imrtqLlvcIr/y7mX0yfiA77MkJTGsvjZWF6gwKOhEDA/5FRpDls4VvL+JCM
Ukum9IgGs2S4CjwFU2QVMi2zRiNvHEZZUe5kmXTie3jr+aVnR1a0TfPozTlm
Ukykmk5JFP7Y791MODG/9/7zxeUUs6Z8LssmT5efkPjfNz52mZh7R7pMzkrC
doS1GO6MMce6kmcJ/WMOn9Zh6I/AVLBGf7RFqQ60HVWKE97ApUP8KUIgrrok
1ThAPbWhUUEeWUfaiXcAJKbKG0bkeZRNsATiahI3TExiTIaSXBjiljmUn/ij
glzcTgrb6hBaPT2lgEvzDJBhyvQofyPdKGWx5U9wbJpSWJGX4dIWPAvPnu4T
6aJZmPOwDrFs/+VMMxUMIlV/18VmPoqrV3wru6B0MQXWPXp7lX2RdL6n0rmh
x1fjy9/mF3MEdXFr8sMapd6IwWW4LMAA9i34YbWi8seRQD6kiBFcJJ4POTH0
XBULVX+kGgR/KtJkzYaoLPj1fVvezqbXL6nJsWsSJohYgl1zRwtMqx25fLS7
a+dj0FRxYfqliHTDVAgkvnOjeyvOSaOgeslalAVksGyOeyu2a8K9WPfXjCFK
3FB2xO+8FYaItVrXkySbncnfiFQX0p+Lvs3Eg9LQSlbMDIdGPGTE+wWMyRCr
t5NpDAHKxh81r+FYA5YY5760W7kiFbU1pF6zSm/Apn+gywLNRUltgagU4jUf
jSBAb8uoLtu8Dau+cqCT4zOLF+vNmqOAvL4Sk3Q8cjqehXpvznVQZDW+E4N4
7VrnkDc14m49LDzuoMamc4qnDI+KkywqGE+mRbriiTTbNPBcxFJD3ruGOENv
OsI0Mc6GLCnFemQ/020K8d7jDWF6hXHGhKvTuo9N6AN04m1MyTp22WOHBOUC
I5jt6yZ8fC8ucgG7Xxq8KYeDt1wA4dHbqwLsjd6U9qO3Z1k+a9aErdauXTWq
rOqyfIxRVVXIqOqhUXfsW1q1JMGeVdW3sqqqvuisqNmeXfsKtqKnt6pW56o2
SuDab2ZU7T9jVHu1XCUVmw765pGu2hcyql5rVM6+tVWfnb3rb2XVEsypbU5T
f+EeK66HcYIOtRljs6aElilVe9WhjBGiDopWtbiQdqr55yYCtGhU2+ou0q22
5SHWsrbl0qRvVXo0s5JHBtJTD/rWkkRtTPtcv1ZR+MgOVhEXqA7MC4kkyqGE
bJ/rI8t0a5pJRXOOCJwSv/pmssLtpB1llbt4R9nWrse0lW15HddbNuOm1mj2
lvwOpwBH93ttGbdoNduyfh+GCfLHxDcCRRElYJZkb9ewIrFhKUeIdJc1Idym
xSxtzrhlMX+6CVehix7mjmBo6YamD9yFzqwGBEs7t7DkYK72AisJS4+fah96
v0q2HpQ0ae6J7qCkf91zBbSFL+5bw8Np9/ET9sYsp3s0qkDNHJpd0LQCqBUX
UqCWf27Cus0ThdYmfnHe35i64POExvQbwjIdfx3p5kg26Bln9XECydLGkM8O
0FMl3wiKKZJcV9BfEUaYdpGtnx3mc4q18EtWRcOhwumZWX7K57TAq8L3iFH+
kVZsOMlvzOXIQf4JtHkbToePJo4fqDdm2WaK35xpS0ykSEoJQwhN3Mtx1RwN
VRjv19JG+OJAFRTfc2i/G21zLW3oyO5BHk3llcHdYGLDgpIe9KTtFwlaHdfe
SviWcMC6XLML51XKE3QdjopomBzSTpiS6dMBs6ifqOXIey4bZyRbpmO1/IhY
yItyvm3dqMJ5WqfW0X6k0m60F3HqDgrzZyji66Ed1o7mk7Zjedc9q9sjtrcv
RlX7enXaWL6U7YzZXWkiySkmjs3tcNTQsTmbI+eOzRm1HT0akvHc6DF9WNjC
xq+O+jK13wj1okx1vYaoVGJMtEo//toMMiV9mHj1geI6otGkVWcKL44hM4an
BcQoQBNA3NjAdZOs78Ku4TzyFPp9N5btp5KnUPc/wr0ljNYluXjictxosRKW
zYFQRYJnK/xrgEip2SaOpJXi4Xl+jJJvjilvjOkWh2D4qcouWK4bUZ7WNck0
pT6S0ZUuJNs15hv/KYidhy7wg0KGTNkP3Zz2KV9dXx2+CEZRa+QypEHxAPze
dr4GNOwc0U72OHQeWBKXDqaSy/zt/aQB5Rk/aZWh+nxrPCh9XeVvK8mO1GEW
+n3jRei/yKXgn6DBvqUtgdg6mnQYsexJT1Z8D+X2Rf8I9maxwL/TfnTyrDQo
auKEdoXadNSETkItWXbcU+lrfXQskn5okothN5O+eSW7L/fWMlfiJeiKqMLB
BvJ0h2qyCajKlEh3NPVjZ6dI51CHDglms4AtvKTI9Gt0NDoAFDgshQxh5C09
itvqoe/84Bcd0QmjtD0j9ixwy9tn30Ix/f9LL4GFsrep/1Ae9dD5OxQZfrrz
A0EbW7DEuU+P6HYyT5TJCqb836brq2v3v6fqXTH44FwyWruKRCfXIs+qP5Vd
T908gJ4HbXK6yUi0JFdItumQj2Zb91inoFPtiweqonah9GgnvaDueuL0syI8
Panwb9cSt1BcsBtuwUG4EW7Bo9WxkQEdG8GY2e+Bs61yLYz6QqOZK3ts5yva
+prlp94ih0eUEx4eqXIXaryPW/whvY9DoOfOqNbMOe2FeKQO6Y0ar7bbOa/T
dtoV3kd12kdb1KhZsbfmdHR/fTSvup2A34Nbm676JEp+b8Yte+nhPmwR6aWr
Mde8jR5KZnEOpA4LNHqkUKFaAZ07pEcaPVr+Jm0eXoSTuFYCaJyjzo4p80aj
M519GH++vBNf0FML/CqkbitvzRz0QN4d7OaesWdIqnWviikuz8E29S3kReAY
IvkU4hbbeN+LE/6iCLQ4vSfrroxo8ngXpl08NxtXTpBvAs+hTWmlk+R0CMpG
w0XbIwzwHP0K3VEDcn8gWb46a9NAZzm7mMJfwJBr3jb2KiF6+QzWYarfmWyV
4/LNZKvIdQSyKBHJ3g+QnaQgXx1BX4YVW1r2NmExf+WOJg9UeXfUgz/jluBs
XLlCC6fKugn8a9KhjZB7nSxDo/5gyd9DG+YYBvRGrwjurPjhdYoqXaYtCwXF
mF6MhyFZJRez3zcscBi9uA/d7zF7f5IsqQM4B/wnCR9YcPhOilqOiqQVb+45
FJsOpyTUEPN3GGUvLOymR1Yc2qJa92SplhF/2vUCo+zlZCx7Rdx4yeM3SAef
+lCW4ccf/g1QSwECFAAUAAAACACPbIo9zkhg2OkQAAAIXQAADgAAAAAAAAAB
ACAAAAAAAAAAU2VydmVyTmFtZS5sb2dQSwUGAAAAAAEAAQA8AAAAFREAAAAA

---=_forums-1-dub4d062c24--

On 13-Dec-2010 15:22, MAK wrote:
> Hi,
>
> I have installed Sybase ASE 15.5 Developer Edition on
> Windows XP (SP3), but the following Services are not getting
> started automatically or manually.
>
>   Sybase BCKServer _<ServerName>_BS
>   Sybase MONServer _<ServerName>_MS
>   Sybase SQLServer _<ServerName>
>   Sybase Unified Agent
>   Sybase XPServer _<ServerName>_XP
>
> Attached is the log when I executed manually the
> RUN_<ServerName>.bat which gets stuck on the last line of
> the log.
>
> I would appreciate if you could help me out on the above
> Services getting started.
>
> Thanks and regards,
> MAK

You cannot tell from the ASE errorlog (when you started ASE manually) 
why ASE won't start as a Windows service.
If the service doesn't start, you should check the Windows event log for 
messages.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks&  Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl  | Twitter: @rob_verschoor
Sypron B.V., The Netherlands  |  Chamber of Commerce 27138666
-----------------------------------------------------------------

hmm.  this was posted in the "general" newsgroup (twice) as well.  You 
should only post your question once in one newsgroup in case others want to 
follow the discussion.  Starting 3 discussions makes that harder to do.

<MAK> wrote in message news:4d062c24.701c.1681692777@sybase.com...
> Hi,
>
> I have installed Sybase ASE 15.5 Developer Edition on
> Windows XP (SP3), but the following Services are not getting
> started automatically or manually.
>
> Sybase BCKServer _ <ServerName>_BS
> Sybase MONServer _ <ServerName>_MS
> Sybase SQLServer _ <ServerName>
> Sybase Unified Agent
> Sybase XPServer _ <ServerName>_XP
>
> Attached is the log when I executed manually the
> RUN_<ServerName>.bat which gets stuck on the last line of
> the log.
>
> I would appreciate if you could help me out on the above
> Services getting started.
>
> Thanks and regards,
> MAK
> 

Hi Rob,
Thanks for your reply.
I checked the Event Viewer (Application) log but couldn't
find anything that says regarding the non-starting of Sybase
Services. I don't seem to understand why the Services are
not starting whether manually or automatically through the
Services.msc viewer of Windows even though the ASE software
got installed correctly. Please help me out in resolving
this issue.
Thanks,
MAK

> On 13-Dec-2010 15:22, MAK wrote:
> > Hi,
> >
> > I have installed Sybase ASE 15.5 Developer Edition on
> > Windows XP (SP3), but the following Services are not
> > getting started automatically or manually.
> >
> >   Sybase BCKServer _<ServerName>_BS
> >   Sybase MONServer _<ServerName>_MS
> >   Sybase SQLServer _<ServerName>
> >   Sybase Unified Agent
> >   Sybase XPServer _<ServerName>_XP
> >
> > Attached is the log when I executed manually the
> > RUN_<ServerName>.bat which gets stuck on the last line
> > of the log.
> >
> > I would appreciate if you could help me out on the above
> > Services getting started.
> >
> > Thanks and regards,
> > MAK
>
> You cannot tell from the ASE errorlog (when you started
> ASE manually)  why ASE won't start as a Windows service.
> If the service doesn't start, you should check the Windows
> event log for  messages.
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Sybase Professional DBA for ASE
> 15.0/12.5/12.0/11.5/11.0 and Replication Server
> 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks&  Recipes for Sybase
> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
> Reference Guide" "The Complete Sybase Replication Server
> Quick Reference Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl  | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands  |  Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------
>

hi kevin, i apologize for the inconvenience. the reason for
posting the same query over here was that i thought probably
i might have posted my query in the wrong newsgroup, i.e.
general, hence once again i posted my query in
"administration" newsgroup. but from now onwards i'll
continue in this newsgroup only at least for this query. so
please help me out with the solution for my below service
related problem. thanks, mak

> hmm.  this was posted in the "general" newsgroup (twice)
> as well.  You  should only post your question once in one
> newsgroup in case others want to  follow the discussion.
> Starting 3 discussions makes that harder to do.
>
> <MAK> wrote in message
> > news:4d062c24.701c.1681692777@sybase.com... Hi,
> >
> > I have installed Sybase ASE 15.5 Developer Edition on
> > Windows XP (SP3), but the following Services are not
> > getting started automatically or manually.
> >
> > Sybase BCKServer _ <ServerName>_BS
> > Sybase MONServer _ <ServerName>_MS
> > Sybase SQLServer _ <ServerName>
> > Sybase Unified Agent
> > Sybase XPServer _ <ServerName>_XP
> >
> > Attached is the log when I executed manually the
> > RUN_<ServerName>.bat which gets stuck on the last line
> > of the log.
> >
> > I would appreciate if you could help me out on the above
> > Services getting started.
> >
> > Thanks and regards,
> > MAK
> >
>
>

If the service doesn't start then either there is an error, in which 
case there must be something in the event log. Try starting the service 
form the command line, i.e. "net start sybsql_xyz" if 'xyz' is the name 
of your ASE server. Run this from a DOS box, and see if there's an 
error, then check the event log for details.
If not, then perhaps the service is not properly defined at all. Since 
*all* your ASE services aren't starting, I'm guessing it is something in 
this area. Check the path to the executables; use syconfig.exe to see if 
you can moify the startup parameters, or look directly in the registry 
to see the command line that is kicked off when starting the service. 
You'll need to dig into this -- it may be a Windows issue ather than a 
specific Sybase issue.

HTH,

Rob V.


On 13-Dec-2010 16:13, MAK wrote:
> Hi Rob,
> Thanks for your reply.
> I checked the Event Viewer (Application) log but couldn't
> find anything that says regarding the non-starting of Sybase
> Services. I don't seem to understand why the Services are
> not starting whether manually or automatically through the
> Services.msc viewer of Windows even though the ASE software
> got installed correctly. Please help me out in resolving
> this issue.
> Thanks,
> MAK
>
>> On 13-Dec-2010 15:22, MAK wrote:
>>> Hi,
>>>
>>> I have installed Sybase ASE 15.5 Developer Edition on
>>> Windows XP (SP3), but the following Services are not
>>> getting started automatically or manually.
>>>
>>>    Sybase BCKServer _<ServerName>_BS
>>>    Sybase MONServer _<ServerName>_MS
>>>    Sybase SQLServer _<ServerName>
>>>    Sybase Unified Agent
>>>    Sybase XPServer _<ServerName>_XP
>>>
>>> Attached is the log when I executed manually the
>>> RUN_<ServerName>.bat which gets stuck on the last line
>>> of the log.
>>>
>>> I would appreciate if you could help me out on the above
>>> Services getting started.
>>>
>>> Thanks and regards,
>>> MAK
>> You cannot tell from the ASE errorlog (when you started
>> ASE manually)  why ASE won't start as a Windows service.
>> If the service doesn't start, you should check the Windows
>> event log for  messages.
>>
>> HTH,
>>
>> Rob V.
>> ----------------------------------------------------------
>> ------- Rob Verschoor
>>
>> Certified Sybase Professional DBA for ASE
>> 15.0/12.5/12.0/11.5/11.0 and Replication Server
>> 15.0.1/12.5 // TeamSybase
>>
>> Author of Sybase books (order online at
>> www.sypron.nl/shop): "Tips, Tricks&   Recipes for Sybase
>> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
>> Reference Guide" "The Complete Sybase Replication Server
>> Quick Reference Guide"
>>
>> rob@NO.SPAM.sypron.nl | www.sypron.nl  | Twitter:
>> @rob_verschoor Sypron B.V., The Netherlands  |  Chamber of
>> Commerce 27138666
>> ----------------------------------------------------------
>> -------
>>


-- 
Dear Sybase user,

I am currently unable to respond to the specific question(s) which you have sent me. Due to the ever increasing number of questions I am receiving, I currently simply don't have the time to answer detailed individual questions.
Please post your question to one of the ASE-related newsgroups so that the ASE community can participate/benefit.
These newsgoups are comp.databases.sybase (Usenet), as well as various newsgroups on Sybase's own news server (forums.sybase.com).
Also, please provide sufficient technical details (error messages, actual queries, query plans, etc.) about your problem.
Try the Sybase FAQ at http://www.isug.com/Sybase_FAQ/, which contains answers to many questions about ASE.

Kind regards,

Rob Verschoor

If you don't want to use X Windows, you could try "sybinit4ever", a free tool which uses only an ASCII interface to create a new ASE server. It can be downloaded from http://www.sypron.nl/si4evr.html

See the
ASE reference manual / System Administration Guide / Transact-SQL user's guide
This / These books can be viewed or downloaded as PDF files from the Sybase website http://www.sybase.com/support/manuals/ . For more details how to get there, see http://www.sypron.nl/sybbooks.html .

For more information on the background of this problem, as well as a solution, see http://www.sypron.nl/idgaps.html .

.... syntax and description are in the ASE Quick Reference Supplement, which you can download from http://www.sypron.nl/ase_qref.html (for a better version, see my book -- www.sypron.nl/qr).


To use dynamic SQL, you need at least ASE version 12.0, which has the "execute immediate" feature for this. In earlier versions of ASE you can simulate some types of dynamic SQL though; for more information, see http://www.sypron.nl/dynsql.html and http://www.sypron.nl/dynsqlcis.html .

For more information about Sybase Certification Exams, see http://www.sypron.nl/certtips.html .

The ASE Performance and Tuning Guide contains a lot fo info about this topic. You can download this manual from http://sybooks.sybase.com/as.html .

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks&  Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl  | Twitter: @rob_verschoor
Sypron B.V., The Netherlands  |  Chamber of Commerce 27138666
-----------------------------------------------------------------

Hi Rob,
Thanks for the solution. I could start the all the services
using "net start" except the xp server which gives the error
"System error 1067 has occurred". But all these services has
to be started via DOS box manually. Is it possible to
automate this task?
Also these services do not start when I use the gui based
Services.msc to start manually or try to automate. Could you
please let me know why this happens? Is it the problem is
with Win XP?
Thanks

> If the service doesn't start then either there is an error
> , in which  case there must be something in the event log.
> Try starting the service  form the command line, i.e. "net
> start sybsql_xyz" if 'xyz' is the name  of your ASE
> server. Run this from a DOS box, and see if there's an
> error, then check the event log for details. If not, then
> perhaps the service is not properly defined at all. Since
> *all* your ASE services aren't starting, I'm guessing it
> is something in  this area. Check the path to the
> executables; use syconfig.exe to see if  you can moify the
> startup parameters, or look directly in the registry  to
> see the command line that is kicked off when starting the
> service.  You'll need to dig into this -- it may be a
> Windows issue ather than a  specific Sybase issue.
>
> HTH,
>
> Rob V.
>
>
> On 13-Dec-2010 16:13, MAK wrote:
> > Hi Rob,
> > Thanks for your reply.
> > I checked the Event Viewer (Application) log but
> > couldn't find anything that says regarding the
> > non-starting of Sybase Services. I don't seem to
> > understand why the Services are not starting whether
> > manually or automatically through the Services.msc
> > viewer of Windows even though the ASE software got
> > installed correctly. Please help me out in resolving
> > this issue. Thanks,
> > MAK
> >
> >> On 13-Dec-2010 15:22, MAK wrote:
> >>> Hi,
> >>>
> >>> I have installed Sybase ASE 15.5 Developer Edition on
> >>> Windows XP (SP3), but the following Services are not
> >>> getting started automatically or manually.
> >>>
> >>>    Sybase BCKServer _<ServerName>_BS
> >>>    Sybase MONServer _<ServerName>_MS
> >>>    Sybase SQLServer _<ServerName>
> >>>    Sybase Unified Agent
> >>>    Sybase XPServer _<ServerName>_XP
> >>>
> >>> Attached is the log when I executed manually the
> >>> RUN_<ServerName>.bat which gets stuck on the last line
> >>> of the log.
> >>>
> >>> I would appreciate if you could help me out on the
> above >>> Services getting started.
> >>>
> >>> Thanks and regards,
> >>> MAK
> >> You cannot tell from the ASE errorlog (when you started
> >> ASE manually)  why ASE won't start as a Windows
> service. >> If the service doesn't start, you should check
> the Windows >> event log for  messages.
> >>
> >> HTH,
> >>
> >> Rob V.
> >>
> ----------------------------------------------------------
> >> ------- Rob Verschoor >>
> >> Certified Sybase Professional DBA for ASE
> >> 15.0/12.5/12.0/11.5/11.0 and Replication Server
> >> 15.0.1/12.5 // TeamSybase
> >>
> >> Author of Sybase books (order online at
> >> www.sypron.nl/shop): "Tips, Tricks&   Recipes for
> Sybase >> ASE" (ASE 15 edition) "The Complete Sybase ASE
> Quick >> Reference Guide" "The Complete Sybase Replication
> Server >> Quick Reference Guide"
> >>
> >> rob@NO.SPAM.sypron.nl | www.sypron.nl  | Twitter:
> >> @rob_verschoor Sypron B.V., The Netherlands  |  Chamber
> of >> Commerce 27138666
> >>
> ----------------------------------------------------------
> >> ------- >>
>
>
> --
> Dear Sybase user,
>
> I am currently unable to respond to the specific
> question(s) which you have sent me. Due to the ever
> increasing number of questions I am receiving, I currently
> simply don't have the time to answer detailed individual
> questions. Please post your question to one of the
> ASE-related newsgroups so that the ASE community can
> participate/benefit. These newsgoups are
> comp.databases.sybase (Usenet), as well as various
> newsgroups on Sybase's own news server
> (forums.sybase.com). Also, please provide sufficient
> technical details (error messages, actual queries, query
> plans, etc.) about your problem. Try the Sybase FAQ at
> http://www.isug.com/Sybase_FAQ/, which contains answers to
> many questions about ASE.
>
> Kind regards,
>
> Rob Verschoor
>
> If you don't want to use X Windows, you could try
> "sybinit4ever", a free tool which uses only an ASCII
> interface to create a new ASE server. It can be downloaded
> from http://www.sypron.nl/si4evr.html
>
> See the
> ASE reference manual / System Administration Guide /
> Transact-SQL user's guide This / These books can be viewed
> or downloaded as PDF files from the Sybase website
> http://www.sybase.com/support/manuals/ . For more details
> how to get there, see http://www.sypron.nl/sybbooks.html .
>
> For more information on the background of this problem, as
> well as a solution, see http://www.sypron.nl/idgaps.html .
>
> ... syntax and description are in the ASE Quick Reference
> Supplement, which you can download from
> http://www.sypron.nl/ase_qref.html (for a better version,
> see my book -- www.sypron.nl/qr).
>
>
> To use dynamic SQL, you need at least ASE version 12.0,
> which has the "execute immediate" feature for this. In
> earlier versions of ASE you can simulate some types of
> dynamic SQL though; for more information, see
> http://www.sypron.nl/dynsql.html and
> http://www.sypron.nl/dynsqlcis.html .
>
> For more information about Sybase Certification Exams, see
> http://www.sypron.nl/certtips.html .
>
> The ASE Performance and Tuning Guide contains a lot fo
> info about this topic. You can download this manual from
> http://sybooks.sybase.com/as.html .
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Sybase Professional DBA for ASE
> 15.0/12.5/12.0/11.5/11.0 and Replication Server
> 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks&  Recipes for Sybase
> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
> Reference Guide" "The Complete Sybase Replication Server
> Quick Reference Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl  | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands  |  Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------
>

Dunno, if the service start manually but not through the Control Panel, 
that's really a Windows problem.

Rob V.



On 14-Dec-2010 17:37, MAK wrote:
> Hi Rob,
> Thanks for the solution. I could start the all the services
> using "net start" except the xp server which gives the error
> "System error 1067 has occurred". But all these services has
> to be started via DOS box manually. Is it possible to
> automate this task?
> Also these services do not start when I use the gui based
> Services.msc to start manually or try to automate. Could you
> please let me know why this happens? Is it the problem is
> with Win XP?
> Thanks
>
>> If the service doesn't start then either there is an error
>> , in which  case there must be something in the event log.
>> Try starting the service  form the command line, i.e. "net
>> start sybsql_xyz" if 'xyz' is the name  of your ASE
>> server. Run this from a DOS box, and see if there's an
>> error, then check the event log for details. If not, then
>> perhaps the service is not properly defined at all. Since
>> *all* your ASE services aren't starting, I'm guessing it
>> is something in  this area. Check the path to the
>> executables; use syconfig.exe to see if  you can moify the
>> startup parameters, or look directly in the registry  to
>> see the command line that is kicked off when starting the
>> service.  You'll need to dig into this -- it may be a
>> Windows issue ather than a  specific Sybase issue.
>>
>> HTH,
>>
>> Rob V.
>>
>>
>> On 13-Dec-2010 16:13, MAK wrote:
>>> Hi Rob,
>>> Thanks for your reply.
>>> I checked the Event Viewer (Application) log but
>>> couldn't find anything that says regarding the
>>> non-starting of Sybase Services. I don't seem to
>>> understand why the Services are not starting whether
>>> manually or automatically through the Services.msc
>>> viewer of Windows even though the ASE software got
>>> installed correctly. Please help me out in resolving
>>> this issue. Thanks,
>>> MAK
>>>
>>>> On 13-Dec-2010 15:22, MAK wrote:
>>>>> Hi,
>>>>>
>>>>> I have installed Sybase ASE 15.5 Developer Edition on
>>>>> Windows XP (SP3), but the following Services are not
>>>>> getting started automatically or manually.
>>>>>
>>>>>     Sybase BCKServer _<ServerName>_BS
>>>>>     Sybase MONServer _<ServerName>_MS
>>>>>     Sybase SQLServer _<ServerName>
>>>>>     Sybase Unified Agent
>>>>>     Sybase XPServer _<ServerName>_XP
>>>>>
>>>>> Attached is the log when I executed manually the
>>>>> RUN_<ServerName>.bat which gets stuck on the last line
>>>>> of the log.
>>>>>
>>>>> I would appreciate if you could help me out on the
>> above>>>  Services getting started.
>>>>> Thanks and regards,
>>>>> MAK
>>>> You cannot tell from the ASE errorlog (when you started
>>>> ASE manually)  why ASE won't start as a Windows
>> service.>>  If the service doesn't start, you should check
>> the Windows>>  event log for  messages.
>>>> HTH,
>>>>
>>>> Rob V.
>>>>
>> ----------------------------------------------------------
>>>> ------- Rob Verschoor>>
>>>> Certified Sybase Professional DBA for ASE
>>>> 15.0/12.5/12.0/11.5/11.0 and Replication Server
>>>> 15.0.1/12.5 // TeamSybase
>>>>
>>>> Author of Sybase books (order online at
>>>> www.sypron.nl/shop): "Tips, Tricks&    Recipes for
>> Sybase>>  ASE" (ASE 15 edition) "The Complete Sybase ASE
>> Quick>>  Reference Guide" "The Complete Sybase Replication
>> Server>>  Quick Reference Guide"
>>>> rob@NO.SPAM.sypron.nl | www.sypron.nl  | Twitter:
>>>> @rob_verschoor Sypron B.V., The Netherlands  |  Chamber
>> of>>  Commerce 27138666
>> ----------------------------------------------------------
>>>> ------->>
>>
>> --
>> Dear Sybase user,
>>
>> I am currently unable to respond to the specific
>> question(s) which you have sent me. Due to the ever
>> increasing number of questions I am receiving, I currently
>> simply don't have the time to answer detailed individual
>> questions. Please post your question to one of the
>> ASE-related newsgroups so that the ASE community can
>> participate/benefit. These newsgoups are
>> comp.databases.sybase (Usenet), as well as various
>> newsgroups on Sybase's own news server
>> (forums.sybase.com). Also, please provide sufficient
>> technical details (error messages, actual queries, query
>> plans, etc.) about your problem. Try the Sybase FAQ at
>> http://www.isug.com/Sybase_FAQ/, which contains answers to
>> many questions about ASE.
>>
>> Kind regards,
>>
>> Rob Verschoor
>>
>> If you don't want to use X Windows, you could try
>> "sybinit4ever", a free tool which uses only an ASCII
>> interface to create a new ASE server. It can be downloaded
>> from http://www.sypron.nl/si4evr.html
>>
>> See the
>> ASE reference manual / System Administration Guide /
>> Transact-SQL user's guide This / These books can be viewed
>> or downloaded as PDF files from the Sybase website
>> http://www.sybase.com/support/manuals/ . For more details
>> how to get there, see http://www.sypron.nl/sybbooks.html .
>>
>> For more information on the background of this problem, as
>> well as a solution, see http://www.sypron.nl/idgaps.html .
>>
>> ... syntax and description are in the ASE Quick Reference
>> Supplement, which you can download from
>> http://www.sypron.nl/ase_qref.html (for a better version,
>> see my book -- www.sypron.nl/qr).
>>
>>
>> To use dynamic SQL, you need at least ASE version 12.0,
>> which has the "execute immediate" feature for this. In
>> earlier versions of ASE you can simulate some types of
>> dynamic SQL though; for more information, see
>> http://www.sypron.nl/dynsql.html and
>> http://www.sypron.nl/dynsqlcis.html .
>>
>> For more information about Sybase Certification Exams, see
>> http://www.sypron.nl/certtips.html .
>>
>> The ASE Performance and Tuning Guide contains a lot fo
>> info about this topic. You can download this manual from
>> http://sybooks.sybase.com/as.html .
>>
>> HTH,
>>
>> Rob V.
>> ----------------------------------------------------------
>> ------- Rob Verschoor
>>
>> Certified Sybase Professional DBA for ASE
>> 15.0/12.5/12.0/11.5/11.0 and Replication Server
>> 15.0.1/12.5 // TeamSybase
>>
>> Author of Sybase books (order online at
>> www.sypron.nl/shop): "Tips, Tricks&   Recipes for Sybase
>> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
>> Reference Guide" "The Complete Sybase Replication Server
>> Quick Reference Guide"
>>
>> rob@NO.SPAM.sypron.nl | www.sypron.nl  | Twitter:
>> @rob_verschoor Sypron B.V., The Netherlands  |  Chamber of
>> Commerce 27138666
>> ----------------------------------------------------------
>> -------
>>


-- 
Dear Sybase user,

I am currently unable to respond to the specific question(s) which you have sent me. Due to the ever increasing number of questions I am receiving, I currently simply don't have the time to answer detailed individual questions.
Please post your question to one of the ASE-related newsgroups so that the ASE community can participate/benefit.
These newsgoups are comp.databases.sybase (Usenet), as well as various newsgroups on Sybase's own news server (forums.sybase.com).
Also, please provide sufficient technical details (error messages, actual queries, query plans, etc.) about your problem.
Try the Sybase FAQ at http://www.isug.com/Sybase_FAQ/, which contains answers to many questions about ASE.

Kind regards,

Rob Verschoor

If you don't want to use X Windows, you could try "sybinit4ever", a free tool which uses only an ASCII interface to create a new ASE server. It can be downloaded from http://www.sypron.nl/si4evr.html

See the
ASE reference manual / System Administration Guide / Transact-SQL user's guide
This / These books can be viewed or downloaded as PDF files from the Sybase website http://www.sybase.com/support/manuals/ . For more details how to get there, see http://www.sypron.nl/sybbooks.html .

For more information on the background of this problem, as well as a solution, see http://www.sypron.nl/idgaps.html .

.... syntax and description are in the ASE Quick Reference Supplement, which you can download from http://www.sypron.nl/ase_qref.html (for a better version, see my book -- www.sypron.nl/qr).


To use dynamic SQL, you need at least ASE version 12.0, which has the "execute immediate" feature for this. In earlier versions of ASE you can simulate some types of dynamic SQL though; for more information, see http://www.sypron.nl/dynsql.html and http://www.sypron.nl/dynsqlcis.html .

For more information about Sybase Certification Exams, see http://www.sypron.nl/certtips.html .

The ASE Performance and Tuning Guide contains a lot fo info about this topic. You can download this manual from http://sybooks.sybase.com/as.html .

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks&  Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl  | Twitter: @rob_verschoor
Sypron B.V., The Netherlands  |  Chamber of Commerce 27138666
-----------------------------------------------------------------