1. Home

Product groups

Support

Re: Syncing local and remote database - WeOnlyDo Discussion board

Re: Syncing local and remote database (General questions)

by wodDrazen, Friday, April 07, 2006, 21:38 (6803 days ago) @ Ketan

Hi Ketan,


There is a problem that wodSSHTunnel and your DB connection runs in the same thread. Since your DB blocks the thread while trying to connect, wodSSHTunnel cannot process windows messages (and socket-related messages) and everything hangs.

You can choose one of this four choices:
1. Setting Threading = True
2. Moving any of these 2 components in separate thread (DB if possible)
3. Setting DB to work in non-blocking (async) mode
4. Using wodSSHTunnel.EXE

Using wodSSHTunnel.EXEX it's same as COM object (just lives in separate process space).
You should also add reference to it (in VB6), initialize using 'new' keyword, and work just as it would be COM object.

Hope I helped.


Regards,
Drazen

locked
4739 views

Complete thread:

 

Not only wodSFTPdll is excellent, the service you have provided is outstanding and second to none!

Ian D. Mead, author of UltraEdit-32
IDM Computer Solutions

...not only that you provide these components at very reasonable cost, your responsiveness to emailed technical questions is simply outstanding...

Michael Thomas
ClownRed Media

Don't be fooled by the cost, it's value and quality far exceeds the price being charged!

Ian D. Mead, author of UltraEdit-32
IDM Computer Solutions

The people at WeOnlyDo are amazing! ... I always get a super fast response from customer service, and the products are great too. Thanks WeOnlyDo

Jeff Hall
Occupational Health Research

You made it so simple for us to integrate SFTP - a technology we had little experience with...

Zack Menendez
Mapframe Corporation

The wodCrypt product is great and we appreciate your effort to add support for UNIX Crypt.

William Ruf
Siemens Information and Communication Networks

The SFTP ocx is one of the finest pieces of programming I have seen. It worked out of the box...

Kenneth R. Robinette
InterSoft International

We have recently completed a large 1200+ location project where reliable Telnet and SSH connectivity was required. wodSSH worked flawlessly and allowed our staff to complete our project ontime and within budget.

James Sievers
Harbor Technologies

...with a minimum of effort as the DLL interface was written with such simplicity...

Zack Menendez
Mapframe Corporation

...with WOD's excellent support I was able to bypass Winsock and focus on the task at hand...

Sander Pool
Rhapsody Networks