ADO Blocking and wodsshtunneel.exe (General questions)

by Mark Sauer, Saturday, March 18, 2006, 00:18 (6829 days ago)

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

1750 views

Complete thread:

ADO Blocking and wodsshtunneel.exe - Mark Sauer, 2006-03-18, 00:18
- Re: ADO Blocking and wodsshtunneel.exe - wodSupport, 2006-03-18, 01:56
  - Re: ADO Blocking and wodsshtunneel.exe - Mark Sauer, 2006-03-18, 02:02
    - Re: ADO Blocking and wodsshtunneel.exe - wodSupport, 2006-03-18, 02:04