dbTalk Databases Forums  

Problems with Sybase SQL Anywhere Network Server Version 5.5.05 Build #2817

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Problems with Sybase SQL Anywhere Network Server Version 5.5.05 Build #2817 in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
laxmi
 
Posts: n/a

Default Problems with Sybase SQL Anywhere Network Server Version 5.5.05 Build #2817 - 12-11-2003 , 10:10 AM






I have a 3rd party software that uses Sybase SQL Anywhere
Network Server Version 5.5.05 Build #2817 as database.
I need to deploy it to a webserver and use that software
from a terminal server .
This works fine with single user logged in to the terminal
server.Incase more thatn one user logs in to the software,
the previous user is unable to continue further.
I want to know if this is a problem with Sybase SQL Anywhere
Network Server Version 5.5.05 Build #2817 or with terminal
server setup or with the 3rd party software.
Webserver OS: windows 2000
Thanks,
Laxmi

Reply With Quote
  #2  
Old   
Chris Keating \(iAnywhere Solutions\)
 
Posts: n/a

Default Re: Problems with Sybase SQL Anywhere Network Server Version 5.5.05 Build #2817 - 12-11-2003 , 10:43 AM






It is probably a configuration problem. Can you
1) Confirm specifically the behaviour you see including any errors or
warnings?
2) What specifically is your configuration for connectivity in the IIS
environment and the 3rd party software?


--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** **************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** **************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

************************************************** **************************
*

<laxmi> wrote

Quote:
I have a 3rd party software that uses Sybase SQL Anywhere
Network Server Version 5.5.05 Build #2817 as database.
I need to deploy it to a webserver and use that software
from a terminal server .
This works fine with single user logged in to the terminal
server.Incase more thatn one user logs in to the software,
the previous user is unable to continue further.
I want to know if this is a problem with Sybase SQL Anywhere
Network Server Version 5.5.05 Build #2817 or with terminal
server setup or with the 3rd party software.
Webserver OS: windows 2000
Thanks,
Laxmi



Reply With Quote
  #3  
Old   
Stephen Rice
 
Posts: n/a

Default Re: Problems with Sybase SQL Anywhere Network Server Version 5.5.05 Build #2817 - 12-11-2003 , 10:44 AM



laxmi wrote in news:3fd896e5.292e.846930886 (AT) sybase (DOT) com:

Quote:
I have a 3rd party software that uses Sybase SQL Anywhere
Network Server Version 5.5.05 Build #2817 as database.
I need to deploy it to a webserver and use that software
from a terminal server .
This works fine with single user logged in to the terminal
server.Incase more thatn one user logs in to the software,
the previous user is unable to continue further.
I want to know if this is a problem with Sybase SQL Anywhere
Network Server Version 5.5.05 Build #2817 or with terminal
server setup or with the 3rd party software.
Webserver OS: windows 2000
Thanks,
Laxmi

We need a more detailed explaination of "whom is doing what to whom"
here. I know of no issues with dbclient.exe connecting to dbsrv5.exe
with win2k or with a properly configured MSTerminal Server.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer



Reply With Quote
  #4  
Old   
laxmi
 
Posts: n/a

Default Re: Problems with Sybase SQL Anywhere Network Server Version 5.5.05 Build #2817 - 12-12-2003 , 06:12 AM



Quote:
1) Confirm specifically the behaviour you see including
any errors or warnings?
2 error messages I can see
#1
SERVER CONNECTION FAILURE

Could not connect to server.
Make sure network server is running, and retry.

---------------------------------------------------------------------------------------------------
System Error Message:

General SQL error.
[Sybase][ODBC Driver]Unable to connect to database server:
unable to start specified database
Alias: <ALiasName>

#2
LOGIN DISCONNECTED

Due to an unknown reason, this workstation has been
disconnected from the network server.
The server is running, but you'll have to login again.
If you were saving data, you'll have to reenter it.

If closing this message box produces more errors ("illegal
operation" or "Access Violation" messages),
you may have to restart your computer.

As a precaution, please save and exit all other open
applications before clicking the Close button here.

General SQL error.
[Sybase][ODBC Driver]Connection not open: not connected to
SQL database



Quote:
2) What specifically is your configuration for
connectivity in the IIS environment and the 3rd party
software?
I have just installed the 3rd party software in the IIS as a
normal installation.I did not do any special connection for
this software and IIS.


Quote:

Reply With Quote
  #5  
Old   
Laxmi
 
Posts: n/a

Default Re: Problems with Sybase SQL Anywhere Network Server Version 5.5.05 Build #2817 - 12-12-2003 , 06:35 AM



The 3rd party software uses sqlanywhere as backend.
So when 2 users simultaneously access the software, is the
database locking it up?
Is this anything to do with terminal server?
Also is there any specific configuration for running
sqlanywhere on terminal servers?
THanks,
Laxmi

Reply With Quote
  #6  
Old   
Stephen Rice
 
Posts: n/a

Default Re: Problems with Sybase SQL Anywhere Network Server Version 5.5.05 Build #2817 - 12-12-2003 , 08:25 AM



Laxmi wrote in news:3fd9b61e.3567.846930886 (AT) sybase (DOT) com:

Quote:
The 3rd party software uses sqlanywhere as backend.
So when 2 users simultaneously access the software, is the
database locking it up?
Is this anything to do with terminal server?
Also is there any specific configuration for running
sqlanywhere on terminal servers?
THanks,
Laxmi
There is no "special" configuration for Terminal Server. It just looks
like many computers on a network and your database server and clients
need to be configured that way.

Have you talked to your vendor? If not you should since they know what
they did and how their software can be configured.

For us to proceed from here we need executable start lines, connection
strings, etc to figure out what software is attempting to connect to
what using what mechanism.

This may be a situation where you are better off dealing directly with
Technical Support so they can spend the time to lead you through
figuring out what you have and then what, if anything, you can do.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.