Database Management and Programing Article

  Overview: The unit is used PowerBuild a software development, back-end database engine is the use of the Sybase SQL AnyWhere 5.5 version.    The default installation of single use only.    Through this paper the way for the software client software (Djpc.exe) and backers of the database engine were running on different computers, through the network to transfer data.    This database engine will be able to provide more computer services. 

  Key: proper ODBC set and with some command-line procedures were activated database engine and client. 

  The necessary conditions: whether the computer database engine is running, running the software client or other need to use the computer database engine, must first install the Sybase SQL AnyWhere 5.5 version. 

  (Note: The database engine and the software or use the engine to other applications in the same computer) 

  Sybase SQLAnywhere need to use the components (procedures): 

  1.Dbsrv50.exe This is the Sybase SQL Anywhere database engine; 

  2.DbClient.exe This is the Sybase SQL Anywhere client program, used to connect to the database engine; 

  These procedures in the installation folder of Sybase SQL Anywhere \ Win32 folder. 

  Need to use the operating system components: 

  ODBC Administrator (in Kongzhimianban management tools folder) 

  Important: Sybase SQL Anywhere in the various settings, including data source name, database name, are case-sensitive.    If the encounter but can not connect the correct order situation, please note the following name of the case. 

  First, set up and run database engine 

  The need to run on a computer database engine, open the ODBC Administrator panel, the conversion to the system DSN 

  Choose to add, drivers choose the type "Sybase SQL Anywhere" 

  Click on the "complete", will automatically appear Sybase SQL Anywhere ODBC configuration window: 

  Data source name is set to DJPC, user name and password are dba and sql, specify the database server name and the name of DJPC, then select the database files, finally, click Option: 

  Attention to the "Start Command" from "dbEng50.exe" was revised to "dbSrv50.exe" (The former is a single database engine, which is what we want network database engine), then write on the parameters "- x NetBios" (This means the designated database engine to use only NetBios order to declare the server. Tested, you can not use TCPIP, always will say that the server name already exists, I do not know why), and finally click OK, ODBC configuration part will come to completion. 

  In theory, this configuration of the Sybase SQL Anywhere database engine, when a database request, the engine should be able to start automatically, but in most cases need to manually pre-start the engine才行: cmd in the run: 

  The parameters "- c  40M   "Designated engine uses 40 megabytes of memory as a buffer zone (based on the need for adjustment, the bigger the buffer, the better the performance. If you do not specify the parameters, then the default buffer zone only 2 trillion, performance is very low). 

  Following is the database engine after the commencement of the screen: 

  Second, set up client 

  ODBC client is still set in ODBC Administrator completed, steps, and set up a similar database engine, only the parameters and the configuration used by Sybase SQL Anywhere the different components: 

  (Case sensitive) 

  Look at options: 

  Setup. 

  When a client of the ODBC request, the system will automatically run DbClient to connect the database engine. 

iLittleFAT

  November 23, 2004 

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.