Add new connection and configuration

Select "File - New Connect", then enter "Database connection property dialog boxˇ±, then enter the correlation information of connect database.

Name

You can make a significative name of this database, but the name must be only one in this machine.

WebDB URL

The URL to connect server script (webdb.asp) in website, if there are no script file in this website, then you can use "Web DB server script upload guide" to release.

Driver

Select corresponding DB driver, it is configure in WebDBConn.ini , the connection can use or not depends on configuration on website.

Detail Connection Information

Fill out the detail parameter of connect database services which select from ODBC driver, these parameter base on services between website and database.

To the database base on files, such as Access, VFP ,parameter always be "dbq". You can use absolute path or relative path .The absolute path is the local path on website server, relative path is path which the file on website server relative to webdb.asp. Our advice is use relative path, so you will not modify the setting of parameter dbq when the main path on website has been changed. But if your script in main directory of server, but the database file in dummy directory, you must use absolute path.

Remark

You can write explain of this connection.

Always Prompt Login

If you would not save the password which connect database in local machine, you can choose enter user and password every times when you cerate connection.

Option

Select setting for advanced function

 

Max rows once command

Default max rows return by executive SQL query between website and local when you create connection

One Page command times

The communication times between website and local when you generate one page query

Max rows display in message box

Set the max rows show in message box, the rows over these will be deleting.

Connect timeout

Connect database timeout, the unit is second.

Command timeout

Connect SQL query timeout ,the unit is second.

Max rows once command

The max rows pick-up from execution of SQL query between website and local

Delete space after

Advice to select it, so you can reduce the number of data translate from client to website

Display System Object

Select this option, then the system database and system table will be show when you browse the database

Show other Databases

If this option not been selected, when you browse the database, just the default database or database set in the connecting parameter will be show. Our advice is this option is not selected if you are the user of virtual server, for there are hundreds of database in this database server.

Connect Mode

You can select three ways: Default, Proxy, and Direct connect. If the Proxy has been selected, you must enter Proxy server, Port, User Password.