Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: HTTP tunnel in AnyDAC
HTTP tunnel in AnyDAC
Posted: 2007/10/03 11:51
 
In some software I found interesting option.
It is HTTP tunnel for connect to database.
I found it in

Navicat MySQL
http://www.navicat.com/win_manual/HTTP_Tunnel.html

EMS SQL Query
http://www.sqlmanager.net/en/products/postgresql/query/documentation/hs3255.html

You plan add HTTP tunnel in AnyDac ? It is interesting option.
Or Can you help me write new driver: Mysql over HTTP tunnel?




Post edited by: mariuszekpl, at: 2007/10/03 11:54
Re:HTTP tunnel in AnyDAC
Posted: 2007/10/03 12:06
 
Or Can you help me write new driver: Mysql over HTTP tunnel?
You does not need to write new driver. You should discover what is required to add to the "regular" MySQL client API code, to make it "tunneled". Then you / me can add this code to the code base.

Regards,
Dmitry
Re:HTTP tunnel in AnyDAC
Posted: 2007/11/21 01:49
 
Diman wrote:
Or Can you help me write new driver: Mysql over HTTP tunnel?
You does not need to write new driver. You should discover what is required to add to the "regular" MySQL client API code, to make it "tunneled". Then you / me can add this code to the code base.

Regards,
Dmitry


In AnyDac all queries are make with API from libmysql.dll
mysql_connect
...
mysql_next_result
...
mysql_num_fields
...
smysql_fetch_row
etc. ....

I want to replace all API code from libmysql.dll with use GET or POST to HTTP server.

example:

Connect to database:
GET /file.php?Function=mysql_connect&DB=name_db&USER=me&PASSWORD=secret&Encoding=UTF8
When your user/password is TRUE server answer 1 or 0.


Send Query to database:
GET /file.php?Function=query&SQL="select * from table"&DB=name_db&USER=me&PASSWORD=secret&Encoding=UTF8
Serwer answer:
Data columns and Data results

I my opinion better way is create new driver with this HTTP tunel
Have you got any example with simple create new driver for AnyDac ?
Maybe simple skeleton to create new driver for AnyDac ??
Re:HTTP tunnel in AnyDAC
Posted: 2007/11/21 06:30
 
Hello

What you are talking about, is the middle tier software. I would suggest to check RemObjects DataAbstract. It works as you need.

Regards,
Dmitry