dbTalk Databases Forums  

how to ensure that users can connect to the database

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


Discuss how to ensure that users can connect to the database in the sybase.public.sqlanywhere.general forum.



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

Default how to ensure that users can connect to the database - 11-16-2009 , 07:29 AM






How can I ensure that users can connect to the rebuilt
database that has the same name as that of the old database.

Reply With Quote
  #2  
Old   
Josh Savill [Sybase]
 
Posts: n/a

Default Re: how to ensure that users can connect to the database - 11-16-2009 , 08:35 AM






If both databases are running, connect to the rebuilt database using the HOST, PORT, ENG, and
DoBroadcast protocol options.

dbisql -c "HOST=xxx.xx.xx.xxx;PORT=2638;ENG=engine_name;DBN= database_name;DOBROAD=NONE"

--
Joshua Savill
Sybase Inc. - Product Manager


Deepali wrote:
Quote:
How can I ensure that users can connect to the rebuilt
database that has the same name as that of the old database.

Reply With Quote
  #3  
Old   
Graeme Perrow [Sybase iAnywhere]
 
Posts: n/a

Default Re: how to ensure that users can connect to the database - 11-16-2009 , 09:03 AM



Correction: some of these are connection parameters, others are TCP
protocol options:

dbisql -c
"ENG=engine_name;DBN=database_name;LINKS=tcpip(DoB road=NONE;HOST=xxx.xxx.xxx.xxx;PORT=2638)"

PORT=2638 can be omitted since that's the default value.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Josh Savill [Sybase] wrote:
Quote:
If both databases are running, connect to the rebuilt database using the
HOST, PORT, ENG, and DoBroadcast protocol options.

dbisql -c
"HOST=xxx.xx.xx.xxx;PORT=2638;ENG=engine_name;DBN= database_name;DOBROAD=NONE"


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

Default Re: how to ensure that users can connect to the database - 11-16-2009 , 11:02 AM



Thank You for replying Josh, Graeme..

The application connects through ODBC and after starting the
database service , if the test connection in ODBC is
successful, does that mean users' connectivity is restored
to the rebuilt database.

Reply With Quote
  #5  
Old   
Josh Savill [Sybase]
 
Posts: n/a

Default Re: how to ensure that users can connect to the database - 11-16-2009 , 12:26 PM



Yes.

--
Joshua Savill
Sybase Inc. - Product Manager


Deepali wrote:
Quote:
Thank You for replying Josh, Graeme..

The application connects through ODBC and after starting the
database service , if the test connection in ODBC is
successful, does that mean users' connectivity is restored
to the rebuilt database.

Reply With Quote
  #6  
Old   
Josh Savill [Sybase]
 
Posts: n/a

Default Re: how to ensure that users can connect to the database - 11-16-2009 , 02:57 PM



New rule for my posts: No connection string information until my second coffee in the morning.
Apparently I'm not awake until then!

--
Joshua Savill
Sybase Inc. - Product Manager


Graeme Perrow [Sybase iAnywhere] wrote:
Quote:
Correction: some of these are connection parameters, others are TCP
protocol options:

dbisql -c
"ENG=engine_name;DBN=database_name;LINKS=tcpip(DoB road=NONE;HOST=xxx.xxx.xxx.xxx;PORT=2638)"


PORT=2638 can be omitted since that's the default value.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Josh Savill [Sybase] wrote:
If both databases are running, connect to the rebuilt database using
the HOST, PORT, ENG, and DoBroadcast protocol options.

dbisql -c
"HOST=xxx.xx.xx.xxx;PORT=2638;ENG=engine_name;DBN= database_name;DOBROAD=NONE"


Reply With Quote
  #7  
Old   
Deepali
 
Posts: n/a

Default Re: how to ensure that users can connect to the database - 11-17-2009 , 03:36 AM



Thanks for replying Josh..

regards, deepali

Quote:
New rule for my posts: No connection string information
until my second coffee in the morning. Apparently I'm not
awake until then!

--
Joshua Savill
Sybase Inc. - Product Manager


Graeme Perrow [Sybase iAnywhere] wrote:
Correction: some of these are connection parameters,
others are TCP protocol options:

dbisql -c
"ENG=engine_name;DBN=database_name
;LINKS=tcpip(DoBroad=NONE;HOST=xxx.xxx.xxx.xxx;POR T=2638)"


PORT=2638 can be omitted since that's the default value.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community


http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


Josh Savill [Sybase] wrote:
If both databases are running, connect to the rebuilt
database using >> the HOST, PORT, ENG, and DoBroadcast
protocol options.
dbisql -c
"HOST=xxx.xx.xx.xxx;PORT=2638;ENG=engine_name
;DBN=database_name;DOBROAD=NONE"

Reply With Quote
  #8  
Old   
Breck Carter [TeamSybase]
 
Posts: n/a

Default Re: how to ensure that users can connect to the database - 11-17-2009 , 05:01 AM



On 16 Nov 2009 12:57:28 -0800, "Josh Savill [Sybase]"
<no_spam_jsavill_no_spam (AT) sybase (DOT) com> wrote:

Quote:
New rule for my posts: No connection string information until my second coffee in the morning.
Apparently I'm not awake until then!
Too bad you can't edit your own answers... here.

Breck Grinning Running And Ducking

Legal Notice: No part of this message constitutes an announcement of
anything, certainly not an alternative to NNTP-based forums.


--
Breck Carter - Blog: http://sqlanywhere.blogspot.com/

SQLA questions and answers: http://sqla.stackexchange.com

RisingRoad helps SQL Anywhere developers make better databases
http://www.risingroad.com/
Breck.Carter at gmail

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.