Source language: Translate to:

NeoSQLite 3 Client/Server Plugin Available

Questions about NeoBook PlugIns

Moderator: Neosoft Support

NeoSQLite 3 Client/Server Plugin Available

Postby David de Argentina » Thu May 08, 2008 11:12 am

Hi All,

If you need a Local / LAN / Internet Database, no install, no M$ royalties, no special hosting, no ODBC Drivers, this plugin is exactly for you.

All credits is for Paul Squires.

It can be downloaded at :

http://specialapps.software-zone.com/fi ... ion_11.zip

Instalation:

UnZip the package in any folder.
you will obtain 2 folders: Client & Server Folders

Server Folder: has this files:

SQL3Server.exe: The Server program. You must run this program.
SQL3Server.ini: The configuration File. you can edit this:
Sample.db3: Sample SQLite3 Database
SQLite3.dll, SLQ3Client.dll,zLib1.dll: DLL's used by SQL3Server.exe program. Please, keep this files within the same folder.

SQL3Server.ini: configuration: it has this aspect:

Code: Select all
[config]
port        = default
ipaddress   = localhost
'ipaddress   = 192.168.0.100
'ipaddress   = www.yoururl.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

You can edit and set some users and pass for each database.


Client Folder: has this files

NeoSQLiteClient.exe: The compiled program. This sample uses the HPWGrid Plugin.
SQLite_Client_plugin2.pub: The sample PUB
NeoSQLiteClient.nbp: The Client-side Plugin. It does not need be included when you create your own client package.
SQLite3.dll, SLQ3Client.dll,zLib1.dll: DLL's used by the plugin. Please, keep this files within the same folder.

Plugin has one function:

Usage:
AE_SQLite_Client "[sql]|[server]|[database]|[user]|[pass]|12069|[fd]|[rd]|[headers]|rset"

where:
[sql]: is any SQL Statement.
[server]: like xxx.xxx.xxx.xxx or www.mylocalmachine.com
[database]: the SQLite Database name. It must be placed on the Server component folder.
[User]: is the UserName. It must be declared at sql3server.ini file at server component.
[Pass]: is the Password. It must be declared at sql3server.ini file at server component.
[Port]: by default is 12069. It must be declared at sql3server.ini file at server component.
[fd]: is the Field Delimiter. Could be any character.
[rd]: is the Record Delimiter. Could be any character. *** Not in use yet ***
[headers]: Could be "Y" or "N". If "Y", program retrieves the column names.
rset: is the return variable. Don't put it between brackets [ ].

Returns:
[rset]: the variable you set.
Field Delimiter: the character you set at [fd] variable
Record Delimiter: the character [#13] in order to be compatible with the hpwGrid.

[AE_SQL3_Status]: Returns "Ok" or "Error (and the error explanation)"
[AE_SQL3_Rset_RowCount]: Return the number of records in the recordset.
[AE_SQL3_Rset_ColCount]: Return the number of Columns in the recordset.

Remarks:

* I had replaced any [#13][#10] with [#182] within field data, in order to prevent some irregular behaviour if your text data have some paragraphs. you could undo this action using StrReplace Action
* Updated Sqlite3.dll to version 3.5.7
* If your IP is like "192.168.x.xxx" you can use this services as Local or LAN services. You must use your "Real " IP in order to be useable as Internet service.
* I had restinged Server capabilities in order to generate up 500 rows recordset. I don't know what happend if you ask for a very big recordset. I think there are a good idea work with small recordset using the LIMIT clause in your SQL Statement. Your SQL Statement must look something like this:
SELECT * FROM Parts WHERE product LIKE '%paper%' LIMIT 20,30
Where 20, is the offset of the first record to retrieve, and 30, is the number of records to retrieve.
Using this technique, you can create "pages" of recordsets.


Plugin is free for private use.

Enjoy it !
David de Argentina
User avatar
David de Argentina
 
Posts: 1560
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina

Postby David de Argentina » Thu May 08, 2008 1:34 pm

I found a small bug in the first row of the recordset.

It doesn't retrieve Count(*), AVG(field), SUM(field), MAX(field), etc.

I updated the plugin.

Please, download it again at:

http://specialapps.software-zone.com/fi ... Client.zip

and overwrite the Client-side plugin

Thanks in advance,

David de Argentina
User avatar
David de Argentina
 
Posts: 1560
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina

Postby Jay-Bird » Thu May 08, 2008 8:04 pm

I will have to get around to trying this, your time and effort is appreciated very much...

:D

Jay
User avatar
Jay-Bird
 
Posts: 164
Joined: Fri Apr 01, 2005 7:01 am
Location: Louisiana , USA

Postby David de Argentina » Fri May 09, 2008 9:54 am

The complete package was updated with the patch of the plugin.
New users need download the complete package only at:

http://specialapps.software-zone.com/fi ... ion_11.zip

Thanks again,
David de Argentina
User avatar
David de Argentina
 
Posts: 1560
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina

Postby farhad2008 » Thu May 15, 2008 2:21 am

hello
i do create a host and upload server files to the site and run client
but it is not work and give me error 'unable to listen to
64.202.96.169 Err=57' please help me

tank you

best regards
farhad
The Words I Love You
farhad2008
 
Posts: 50
Joined: Tue Apr 01, 2008 1:15 am
Location: usa

Postby David de Argentina » Thu May 15, 2008 9:42 am

Hi Farhad,

This is a Client-Server application.

You need running Both parts, Client & Server.

Tipically, error 57 happens when Server component is not running.

You must start the SQL3Server.exe program at the Server Folder.
(a small dialog appairs on the screen)

This package (Client & Server) was made for run on a "Non Hosting" Server, using your local machine as Server.

I think your Hosting administrator don't be happy if you try to run Server component within the host machine.

My devaluated cent,
David de Argentina
User avatar
David de Argentina
 
Posts: 1560
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina


Return to PlugIn Discussions

Who is online

Users browsing this forum: dglojnar and 1 guest