How to make application log into the SQLAnywhere server on the server

Hello,

SQL Anywhere server runs on the server machine along with
the application.
The ODBC handle is configured such that it calls dbeng50.exe.

Most of the time, my application connects to the server.
But, sometimes, for unknown reason, it runs a standalone
SQLAnywhere and connects to it.
(Both the server and applications are usually started together.)
When that happens, dbserver does not seem to accept connections
from other clients running on other PCs either.

Please advise what I can do to insure that the application
connects to the server, not to the standalone engine.

Thanks.

/yunki


0
Yunki
3/2/1999 12:27:52 AM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

11 Replies
691 Views

Similar Articles

[PageSpeed] 37

Try getting rid of the reference to dbeng50.exe. That is the name of
the standalone engine, and if you don't ever want to start it then it
shouldn't appear in the ODBC configuration.

Applications that connect to a server on the same machine do not need
any protocol specified (tcpip, etc), they connect directly. Therefore,
the ODBC connection parameters are quite simple. You just need to name
the server. By default, the server name is the same name as the file
name portion of the .DB file specified when you run DBSRV50.EXE.

Breck

"Yunki Paik" <paik1@llnl.gov> wrote:

>Hello,
>
>SQL Anywhere server runs on the server machine along with
>the application.
>The ODBC handle is configured such that it calls dbeng50.exe.
>
>Most of the time, my application connects to the server.
>But, sometimes, for unknown reason, it runs a standalone
>SQLAnywhere and connects to it.
>(Both the server and applications are usually started together.)
>When that happens, dbserver does not seem to accept connections
>from other clients running on other PCs either.
>
>Please advise what I can do to insure that the application
>connects to the server, not to the standalone engine.
>
>Thanks.
>
>/yunki
>
>

0
bcarter
3/2/1999 1:38:33 PM
>Applications that connect to a server on the same machine do not need
>any protocol specified (tcpip, etc), they connect directly. Therefore,
>the ODBC connection parameters are quite simple. You just need to name
>the server. By default, the server name is the same name as the file
>name portion of the .DB file specified when you run DBSRV50.EXE.
>
Thanks for the advice. One follow up question, though.

Will it then start the server also if the server happens to be not running
at
that time?
If so, can I pass the command line flags in the ODBC configuration?
Thanks.

/yunki



0
Yunki
3/2/1999 5:59:52 PM
>Will it then start the server also if the server happens to be not running
>at
>that time?
>If so, can I pass the command line flags in the ODBC configuration?

Yes, but it's a bit trickier when you start the server via ODBC
configuration parameters.

In the ODBC Administrator, edit the DSN and go to the Database tab.

Blank out the "Server name".

Fill in the "Start line"; e.g., 

"E:\Program Files\Sybase\Adaptive Server Anywhere
6.0\win32\dbsrv6.exe" -x tcpip{ServerPort=2638} -c 16m -gp 4096

Fill in the "Database file"; e.g.,

c:\amisc\ASAJava\ASAJava.db

Check "Automatically start the database if it isn't running."

Uncheck "Automatically shut down the database after the last
disconnect."

That will let your application connect to the server if it is already
running, and start the server and the database if it isn't.

The examples above are using ASA 6 but it's pretty much the same for
SQL Anywhere 5.5 except for the program and directory names.

Breck
0
bcarter
3/2/1999 6:50:01 PM
But you wouldn't be able to start a db server on another machine.  I 
wouldn't even do it on the local machine.  The server comes up and starts 
answering requests from other network clients.  You log off of the PC and 
the db server goes down too.
-- 
Jim Egan [TeamPS]
Dynamic Data Solutions, Inc. http://www.dyn-data.com
Houston, TX

                ***********************************************************
                          Enterprise Applications in Your Future?
                      JumpStart '99 Enterprise Solutions Conference
                                http://www.JumpStart99.com
                ***********************************************************

0
jegan
3/3/1999 3:50:12 AM
jegan@dyn-data.com (Jim Egan) wrote:

>But you wouldn't be able to start a db server on another machine.  

True, it only works to automatically start a server/engine in *this*
machine.

>I wouldn't even do it on the local machine.  

Normally I would agree, and perhaps I should have included the usual
disclaimer, "This is unusual practice." However, it's hard to
second-guess what people really need to do, in an absence of a
complete description of their situation... sometimes unreasonable
requests turn out to be completely sensible.

>The server comes up and starts 
>answering requests from other network clients. 

Well, I guess that's why it's called a "server" :)

> You log off of the PC and 
>the db server goes down too.

Not if you uncheck "Automatically shut down the database after the
last disconnect."

Breck
0
bcarter
3/3/1999 12:37:43 PM
>> Not if you uncheck "Automatically shut down the database after the
last disconnect."<<

Sorry, but when you start the db server using the command line and then 
log off of NT the db server goes down too.  Maybe we weren't talking 
about the same thing though.  If you start it as a service then you can 
log off without the db server going down.
-- 
Jim Egan [TeamPS]
Dynamic Data Solutions, Inc. http://www.dyn-data.com
Houston, TX

                ***********************************************************
                          Enterprise Applications in Your Future?
                      JumpStart '99 Enterprise Solutions Conference
                                http://www.JumpStart99.com
                ***********************************************************

0
jegan
3/4/1999 3:49:25 AM
>Sorry, but when you start the db server using the command line and then 
>log off of NT the db server goes down too.  

You're right... when you click on "Close all programs and logon as a
different user" it does just that. I also neglected the fact that the
database goes down if I crush the computer under the wheels of my
truck :)

Breck The Annoying
0
bcarter
3/4/1999 4:29:29 PM
>>  I also neglected the fact that the
database goes down if I crush the computer under the wheels of my
truck :)
<<

Well, that's one test that I don't think I'll try.  I've got no truck! 
<g>
-- 
Jim Egan [TeamPS]
Dynamic Data Solutions, Inc. http://www.dyn-data.com
Houston, TX

                ***********************************************************
                          Enterprise Applications in Your Future?
                      JumpStart '99 Enterprise Solutions Conference
                                http://www.JumpStart99.com
                ***********************************************************

0
jegan
3/4/1999 5:21:13 PM
>>  I also neglected the fact that the database goes down 
>> if I crush the computer under the wheels of my truck :)

A brilliant new method for data compression!
0
Mike
3/5/1999 7:35:18 PM
Mike Packard <mpackard@adnc.com> wrote:

>>>  I also neglected the fact that the database goes down 
>>> if I crush the computer under the wheels of my truck :)
>
>A brilliant new method for data compression!

Actually, it does a better job of encryption than compression :)

Breck The Suburban

0
bcarter
3/5/1999 10:33:56 PM
True, it does both, but I woudn't go as far as calling it "loss-less". :-) 

Breck Carter wrote:
> 
> Mike Packard <mpackard@adnc.com> wrote:
> 
> >>>  I also neglected the fact that the database goes down
> >>> if I crush the computer under the wheels of my truck :)
> >
> >A brilliant new method for data compression!
> 
> Actually, it does a better job of encryption than compression :)
> 
> Breck The Suburban
0
Mike
3/6/1999 7:49:19 PM
Reply:

Similar Artilces:

sqlanywhere and sqlanywhere server
Currently i am using sqlanywhere and powerbuilder tool as my system development. And i am developing a standalone system. Let say, if i want to migrate my standalone system to client-server system, how do i do that? I heard that i need to have sqlanywhere(server engine) to deploy my system as client-server system. If so, do i need to install sqlanywhere(server engine) into window NT or just normal pc(treat as server). For client-server system, do i need to install sqlanywhere server at server and sqlanywhere client as normal pc where my program is installed? Could someone tell me where...

How to start SQLAnywhere server w/o logging into server
SQLAnywhere 5.5.05 Windows 2000 Server I thought that maybe I could get Service Manager to do that, but it doesn't seem to work. The DB comes up fine if I'm in it. I also noticed that after it makes the service, the parameters get wiped out. The service will start up with switches that I didn't enter, and leaves out the switches that I did enter. Anybody gotten this to work? Thanks, Jack T. See the Help dbeng50w.hlp... ===== SQL Anywhere User's Guide PART 3. Using SQL Anywhere CHAPTER 29. Running Programs as Services Adding and removing SQL...

Access local server(LAN Server) from Web Server(Web Application Server)
Hello All I have a local server for my LAN and a Web server(at remote location).Is it possible to access my Local Server from my Web Server ? Thanks MS  ...

Shutdown SQLAnywhere Server from application?
Is it possible to shutdown SQLAnywhere server from within a Powerbuilder application? I would like the server shutdown when the last instance of conneciton from client is bronken. Any advice would be appreciated. ...

Starting the server application and stopping the server application from the client application
Hi , How do I do it ? I want to start the server application from my client app. After all my jobs are over , when I disconnect from the server, I want to close the server application. Both the client and server applications will be running on the desktop under NT or win95 environment. If the client app is abc.exe and the server app is pqr.exe when the user starts the client app from his desktop, the client should start pqr.exe . Now after finishing all the process when the user closes the client, I want to disconnect from server and close the server pqr then close abc...

Server to Server, both Servers in same Tree
Hi, where could be problem when some time connection is not established after server restart, but some time it is OK. (I waited whole day) Filters are opened for all IP from and to both servers in VPN. Both servers are BM3.7 SP2, NDS Version 10350.19 March 18, 2003 Slave server contain RW replica of the container where the server resides. (I tried also Master replica) here are also licenses for NW6 and BM3.7 Master server is in different replica which is not on slave server. Both servers are on same subnet. Packet capture shows only IP 57 communication from Master to ...

Starting up replication after Server Application log fills up on Rep server.
The Server application log filled up on the rep server and now no records are being replicated although all connections seem to be active. I emptied the application log and am wondering what I need to to do to start replicating data again. Any help would be greatly appreciated. Thanks Rohan ...

server or no server
i have been looking in to slipstreaming windows up dates over the net work ..i have also been thinking (bad thing to do ) installing the os over the net (image).i know you can do this over win2k server using rras server but could i do this in novell 5.1 with out bulding and paying for a server lience. our network is spread across 6 sites one server to each site a gig backbone on each site but connect by 100 mb line .not knowing novell to well but they seem not to be use the OS and Server to well .any help or info would be useful Nigel, > i have been looking in to...

Upgrade SqlAnywhere Server 5.0 auf SqlAnywhere 7.0
Hello, We want to upgrade our SqlAnywhere database server from 5.0 to 7.0. How does this work? Please help me. Many thanks, Gerhard You can either unload/reload or upgrade the database. The documentation discusses this. BTW ASA7 is currently in limited support. Current versions are ASA8 and ASA9 so it would be wise to consider going to a later version. <Gerhard> wrote in message news:41e3a189.7488.1681692777@sybase.com... > Hello, > We want to upgrade our SqlAnywhere database server from 5.0 > to 7.0. How does this work? Please help me. > > Many th...

can sqlanywhere 7.0 server run on windows 2003 server ?
Dear sir, I am using sqlanywhere 7.0 server running on a Window NT server. I will upgrade the server to windows 2003 server in a few weeks. Are there any problem for the sqlanywhere 7.0 server running on that platform? Please advise. Thankyou Kelvin. See http://www.ianywhere.com/products/supported_platforms.html 7.04 is supported. -- Chris Keating Sybase Adaptive Server Anywhere Professional Version 8 **************************************************************************** * Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition and ...

Can log in with developer server but cannot log in with actual server
Dear all,I tried to create the login process and it worked. However, when I tried to use the webpage login.aspx without using the developer server, only the "login.aspx" would work. I typed in my name and pw, and when the page suppose to be redirected to a login page, it shows that this page cannot be found.Could some one help me on this?...

Can DotNetNuke run on two web servers, an application server and a sql server?
The catch is that the webservers can only connect to the application server which in turn is the only server allowed to acess the sql server!! I read the documentation on Web farm support which suggests that in DotNetNuke 3.1 the two webservers should be supported. However nothing in the installation documents leads me to believe that an application server is supported but can this be done? The Dotnetnuke site I am thinking of creating has content will not be huge (but will be updated often I believe) so I was thinking of going down the DotNetNuke 2.12 road with an Access database...

connecting to sqlanywhere 5.0 server from client pb application.
Hello, I am using SQL Anywhere 5.0.01 build #451, with power builder 5.0.02. I have setup the server on an Windows NT Server 4.0 and am connecting using sql anywhere client on Windows 95. My problem is that trying to connect to the server from the client succeeds when i use sql central but fails when i connect using my pb application. I am using ODBC to connect from PB application. I have specified the servername correctly which is what i think the client requires to find the server ( it does not seem to require the hostname of the server). Further i find two EXEs for running th...

Server Application Unavailable, but no application event log!
Hello,During development of an ASP.NET 2.0 website on IIS (Windows XP) I get the "Server Application Unavailable" error which mentions that there is an event log, but there isn't. So I don't have an error code.I can get the website to work by giving the ASPNET user standard permissions to the root folder of the website, BUT... I really want to know the exact problem. This was never necessary in the past, but it is now. So something must have changed, and I'd rather find the root of the problem than 'patching' it.So if anyone can help me find out why exactly I get the error that'd be great.Th...

Web resources about - How to make application log into the SQLAnywhere server on the server - sybase.sqlanywhere.general

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Pre-Christmas job application rush hits Australian public service
Speed required for pre-Christmas job window opening for public servants. Check out who is hiring.

Second visa application 'likely' to be approved
The family of a terminally ill Pakistani student can 'hopefully come to Australia sooner rather than later' says Immigration Minister Peter Dutton. ...

Cloud application adoption increases 71 percent in 2015
The adoption of cloud applications is soaring, up by 71 percent in the last year according to the results of a new survey. The latest Cloud ...

Tashfeen Malik's visa application under scrutiny - Business Insider Deutschland
The US government has released the visa application for Tashfeen Malik, who along with her husband killed 14 people in an attack in San Bernardino, ...

MBA: Mortgage Applications Increase in Latest MBA Weekly Survey, Purchase Applications up 37% YoY
From the MBA: Refinance, Purchase Applications Both Up in Latest MBA Weekly Survey Mortgage applications increased 7.3 percent from one week ...

Lawmaker: Immigration Officials Didn’t Fully Vet Tashfeen Malik’s Visa Application
"It’s unacceptable that U.S. Citizenship and Immigration Services did not fully vet Malik’s application and instead sloppily approved her visa," ...

German-Based Spirea Promotes Decentralized PV Applications In Uruguay
... Its technical operations specialist, Laurie Lawrence, pointed out that Uruguay [&hellip German-Based Spirea Promotes Decentralized PV Applications ...

Visa application of San Bernardino shooter released
CNN Visa application of San Bernardino shooter released CNN (CNN) The visa application of one of the San Bernardino shooters was released ...

NTU research team discovers optoelectronic application for molybdenum disulfide
A research team under the National Taiwan University (NTU) has discovered an optoelectronic application for molybdenum disulfide (MoS2), a 2-dimensional ...

Resources last updated: 12/28/2015 11:25:14 AM