![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
How can I ensure that users can connect to the rebuilt database that has the same name as that of the old database. |
#3
| |||
| |||
|
|
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" |
#4
| |||
| |||
|
#5
| |||
| |||
|
|
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. |
#6
| |||
| |||
|
|
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" |
#7
| |||
| |||
|
|
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" |
#8
| |||
| |||
|
|
New rule for my posts: No connection string information until my second coffee in the morning. Apparently I'm not awake until then! |
![]() |
| Thread Tools | |
| Display Modes | |
| |