I think this should be a basic task of a database, so it should be very answer to answer, but I found no way how to do it:
I had no chance to set up a database on computer1 so that user1 on computer2 can access this database. To test this I tried with Sybase Central to set up a database on computer1 and then to access this database with Sybase Central on computer2, but I didn't manage to get it work. I know MYSQL. There I specify a port and bind-adress. And for the user I specify the allowed hosts -> done. I expected that it is similar on sql anywhere, but I found no corresponding options. Also I found no step by step tutorial in the web and also the manual didn't help me. This is really strange, because for MYSQL the web is full of explanations. So please: Can someone here help me with this very basic task?
How do I set up a database for remote access in Sybase Central 6.1.0 step by step?
Thank you! Granni
For the record, older versions of Sybase Central used a separate version numbering scheme. In this case Sybase Central 6.1.0 means "the Sybase Central that comes with SQL Anywhere 12".
What you want is a network connection, which has nothing to do with the topics "remote data access" or "sql remote"... those are different animals (they're cool, and you might have enjoyed reading about them if you weren't on a quest to get some actual work done).
Here goes; if this doesn't help, just ask more questions...
Step 1: Start your database on computer 1 using the Network Server (dbsrv12.exe) rather than the Personal Server (dbeng12.exe)... the two are functionally identical except dbsrv12.exe supports network connections (and some other minor differences).
Sadly, Sybase Central doesn't give you an explicit "start database" menu option. It only starts databases implicitly, via the "connect" process, and by default it uses the Personal Server.
Here's how to use the Sybase Central "connect" process to start the database with the network server...
Connections - Connect with SQL Anywhere 12, then fill in the dialog box as follows...
...and click on Connect.
Two things will happen: the database will be started with the Network Server, and Sybase Central will connect to the database. To confirm, click right mouse - Properties on the "ddd" server icon in the left frame to see "Network server" instead of "Personal server"...
Step 2: Over on computer 2, use Sybase Central to connect as follows...
The server and database names both default to "ddd" because explicit overrides were not provided when the database was started. The host and port MIGHT be required if the network configuration is "interesting". The host is the ip or machine name running the server, and the port defaults to 2638, but will be different if multiple servers are started on the same computer.
IF SOMEONE WOULD BE KIND ENOUGH TO PROVIDE A LINUX TRANSLITERATION, WORLD PEACE WILL SURELY FOLLOW!
For the record, here is a set of Windows commands to create a database (dbinit), start it using the network server (dbsrv12 via dbspawn), and make two connections (dbisql). The first dbisql works locally, or from a nearby computer on the network. The second dbisql explicitly specifies the TCPIP parameters (the host happens to be localhost in this demonstration, and the weird port is the result of the dbsrv12 being the 3rd instance on the same computer). It also used DOBROADCAST=NONE to stop dbisql from hunting around for the server on other computers, if the HOST settings don't work.
"%SQLANY12%\bin32\dbinit.exe"^ ddd12.db "%SQLANY12%\bin32\dbspawn.exe"^ -f "%SQLANY12%\bin32\dbsrv12.exe"^ -o dbsrv12_log_ddd12.txt^ -x tcpip^ ddd12.db "%SQLANY12%\bin32\dbisql.com"^ -c "ENG=ddd12;DBN=ddd12;UID=dba;PWD=sql;CON=LocalConn;" "%SQLANY12%\bin32\dbisql.com"^ -c "ENG=ddd12;DBN=ddd12;UID=dba;PWD=sql;CON=NetworkConn;LINKS=TCPIP(HOST=localhost:49160;DOBROADCAST=NONE)" PAUSE
answered 06 Aug '13, 09:03
Use the Services Tab on the right side in Sybase Central and create a Windows Service for your database server check the options of dbsrv... (easiest is to start it with -?)
check out the manual, a good starting point is here