Hello,
i request support for HTTP tunnel for SEDCS. With this feature it is possible to connect SEDCS to a mysql database on a webhoster of your choice.
This solves the 10060 connection error!
I tested it with Navicat and with the "ntunnel_mysql.php" which has to be uploaded on the webspace where the database is. Its working with no problems!
Maybe its possible without much work, if not, we will find another solution!
Thank you very much!
Cheers
Phil
Request: "Use HTTP Tunnel" in SEDCS
Moderator: SEOW Developers
-
- Posts: 2211
- Joined: Mon 08 Jan 2007 11:10 pm
- Location: Perth, Western Australia
-
- Posts: 2211
- Joined: Mon 08 Jan 2007 11:10 pm
- Location: Perth, Western Australia
Well, getting the ntunnel_mysql.php script installed on the web site and operating with Navicat was absolutely trivial. However, I am not sure how to do it with the DCS. I can't see a way to get a HTTP tunnel going in VB .NET with the ADODB and ODBC connectors the DCS uses.
The option is to use something like dotConnect from devart, but that costs a little bit of money and would require a complete DB/SQL engine rewrite in the DCS.
Any neat ideas? HTTP tunnel documentation was very hard to find for Visual Studio.
Cheers,
4S
The option is to use something like dotConnect from devart, but that costs a little bit of money and would require a complete DB/SQL engine rewrite in the DCS.
Any neat ideas? HTTP tunnel documentation was very hard to find for Visual Studio.
Cheers,
4S
IV/JG7_4Shades
SEOW Developer
SEOW Developer
-
- Posts: 2211
- Joined: Mon 08 Jan 2007 11:10 pm
- Location: Perth, Western Australia
I have added the Navicat "ntunnel_mysql.php" script to the MP4public code set now. This provides a very fast and easy way for Navicat clients to connect to MySQL servers co-located with MP4public installs, thereby bypassing the need for remote access "whitelisting" etc.
Thanks PhilHL for alerting me to this.
Cheers,
4Shades
Thanks PhilHL for alerting me to this.
Cheers,
4Shades
IV/JG7_4Shades
SEOW Developer
SEOW Developer