Internet Security Components - COM, ActiveX and .NET

ADO Blocking and wodsshtunneel.exe - WeOnlyDo Discussion board

Linear

I am attempting to create a small application which needs to go out and connect securely to a MySQL database on a web server. The connection initiates from a VB application running on a PC. I am able to create a tunnel and connect via a seperate mySQL client, but I am not able to connect via ADO within my application. This is exactly the behavior I need though.

From what I understand, the problem is that VB6 does not have threading, thus all processes run under one thread. When I call the ADO execute method, it blocks the thread and my application freezes up.

What is the best way to get around this threading limitation? Should I write the application with VB.Net instead? If I do write the app with VB.Net, will ADO.Net behave differently?

Any ideas/suggestions are greatly appreciated.

-Mark

locked

1746 views

Hi.

VB.NET would solve it, yes, since you can run there wodSSHTunnel or ADO client in separate thread.

You can also try to set Threads property to true. You can also try to use EXE version of wodSSHTunnel (out proc server), called wodTunnelServ.

I'm not sure if any of this would help, tho... It would be best if you could use CreateThread API, but I'm not sure how stable that would be. Search on google for

VB6 CreateThread

and you'll find some discussions about this, such as this one:

http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=14479&lngWId=1

Hope I helped.
Kreso

locked

1794 views

Thanks for the information. I have been researching some other code samples that make use of a pseudo out-of-process wrapper for VB6. You create an ActiveX.exe (similar to what you guys do with your ActiveX.exe) which implements this threading wrapper.

I'll post feedback here about it if I can get it all working. I am hoping to accomplish all of this without using VB.Net - mainly to keep my distribution and install simple.

Thanks again!

locked

1763 views

Mark,

if you can put wodSSHTunnel into separate process and execute it, then you have everything solved.

Kreso

locked

1761 views

Thank you so much for your hard work and commitment in producing well thought-out solutions. WeOnlyDo is very committed to customer satisfaction!

Mike McPherson

Nokia Inc.

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

William Ruf

Siemens Information and Communication Networks

Your customer service was excellent, and I will look at your products in the future for precisely that reason.

Charles Taylor

InterWeave, Inc.

Just thought you'd like to know that my gateway app with your SMTP Server component held the line against a DDOS attack today...

Chris Langsenkamp

Clever Technologies

...your service has been phenomenal. It's always quick and you are there when I need you.

James Newman

Castleberry Investments

...what I really like is that wodSSH and wodSFTP components work excellently and are constantly being improved...

Steven Jones

SABIEN project

Thanks! We love your software and your great support!

Sandy Fliderman

Primary Development Corporation

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

...your service has been phenomenal. It's always quick and you are there when I need you.

James Newman

Castleberry Investments

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

Zack Menendez

Mapframe Corporation

Product groups

Support

ADO Blocking and wodsshtunneel.exe (General questions)

Re: ADO Blocking and wodsshtunneel.exe

Re: ADO Blocking and wodsshtunneel.exe

Re: ADO Blocking and wodsshtunneel.exe

About

Contact