SQLitening Support Forum

SQLitening Support => You've got Questions? We've got Answers! => Topic started by: Paul Squires on April 20, 2008, 09:32:41 PM

Title: SQLite3 Client/Server (Version 0011) April 20, 2008
Post by: Paul Squires on April 20, 2008, 09:32:41 PM
Here is the download link to the latest version (0011): http://www.planetsquires.com/files/sql3_cs_0011.zip

Version 0011 (2008-04-20)
- Updated Sqlite3.dll to version 3.5.7
- Added error checking that will allow the client to be notified when the server unexpectantly shuts down before the client specifically requests to disconnect. An %ERR_DISCONNECTED error is returned.

- New format for the sql3server.ini file.

Example:

[config]
port        = default
ipaddress   = localhost
'ipaddress   = 192.168.0.100
'ipaddress   = www.planetsquires.com
busytimeout =
idletimeout =
 
[database]
databasename = sample.db3
security     = PSS234|sqlrocks
security     = paulsq|mypassword
security     = mark123|secret
 
[database]
databasename = \pharmacy\drugs.db3
security     = todd34|nfldpass
 
[database]
databasename = \accounting\gltrans.db3
security     = jennifer99|mypassword


During sql3_Connect, all usernames and passwords are checked regardless of what database it relates to. If a match occurs then the connection succeeds. During sql3_Use, the database to be used is matched against the related usernames and passwords for that database. If matched, then the use succeeds. Usernames and passwords are case sensitive. Database names are case insensitive.