Next>>

Database Server and ODBC Configuration

To setup the program on a network you must do two things. First, you must configure the Server startup options to establish the database server running on an NT Server or Windows 98/2000/ME. Secondly, you must configure an ODBC datasource on EACH computer accessing the data, including the server in a peer-to-peer network. Since the database server will run independently and look for TCP/IP, NetBEUI and SPX connections, you do not have to share the server computer's drive or map server directories on the network.
To startup the database server, execute the server program (dbsrv7.exe) from within the \program files\landmark data systems\sqlany70 directory. Configure the startup options as shown on the right. The database file is \program files\landmark data systems\application for payment\db\aa32.db.
To start this server automatically as a Windows service, put the following string in the RunServices registry key.
KEY: Hkey_Local_Machine\Software\Microsoft\Windows\CurrentVersion\RunServices
STRING: ASA70srvAA
VALUE: C:\Program Files\Landmark Data Systems\SQLAny70\DBsrv7.exe "c:\program files\landmark data systems\application for payment\db\aa32.db" -m -y -n AA_server
Click OK on the Server startup options screen to close that window. Next open the ODBC administrator in the Control Panel, click on the System DSN tab and add a data source named AIA32. When you click on the Add button, select the Adaptive Server Anywhere 7.0 driver and click Finish. If you have installed the program already as a single user product, the data source will already be there and you can simply configure the tabs according to the following instructions by clicking on Configure to access the ODBC settings.
Next>>