1. Home

Product groups

Support

DSN Connection - WeOnlyDo Discussion board

DSN Connection (General questions)

by jasnew1969, Monday, January 09, 2012, 16:41 (4700 days ago)

Ok, I'm stumped. I've coded in the tunnel and it starts and works fine. If I stop once the tunnel is started I can connect to my MySQL server no problem using another program. If I start the tunnel using your sample and forward the connection in, I can open my program and it will use the tunnel to forward the connection. Problem happens when I use the tunnel and the sql connection in the same program it locks up. If I start a tunnel, and then issue the ncsqltest.open it locks up. If I start the tunnel with the sample, skip the code I wrote to start the tunnel and issue the same open command, works. I'm stumped.

locked
  2371 views

Re: DSN Connection

by woddrazen, Monday, January 09, 2012, 16:56 (4700 days ago) @ jasnew1969

Hi,


Problem you are receiving is with many dababase clients because they block the thread when you use them. wodSSHTunnel lives is same thread where database client is and cannot process windows messages. So everything freeze.

Here are suggestions you can try to solve this issue:
- move database client to separate thread
- or you can use EXE version of wodSSHTunnel (wodTunnel.EXE) wodSSHTunnel.exe is out of process COM object that can work in separate process
- or set Threads Property to True. Please make sure that your programming environment supports multithreading

Let us know how it goes.


Regards,
Drazen

locked
  2350 views

Re: DSN Connection

by jasnew1969, Monday, January 09, 2012, 19:17 (4700 days ago) @ woddrazen

That explains a lot. Was getting a little frustrated with it all. Is there code showing how to use the EXE versions?

locked
  2408 views

Re: DSN Connection

by woddrazen, Monday, January 09, 2012, 19:27 (4700 days ago) @ jasnew1969

Hi,


You need to import wodSSHTunnel EXE inside your programming environment. Code is same as using ActiveX or COM version of wodSSHTunnel.

Let us know if you need more help.


Drazen

locked
  2370 views

Re: DSN Connection

by jasnew1969, Monday, January 09, 2012, 21:04 (4700 days ago) @ woddrazen

well, that didn't work. It still locks up even after loading wodtunnel.exe. Just have to shell a seperate program to start and stop the channels I guess.

locked
  2390 views

Re: DSN Connection

by jasnew1969, Monday, January 09, 2012, 21:43 (4700 days ago) @ jasnew1969

If I send you the test project I have, do you have a way of testing to see if something I'm doing? It's just a simple 1 form project just to test this out.

locked
  2427 views

Re: DSN Connection

by woddrazen, Monday, January 09, 2012, 22:22 (4700 days ago) @ jasnew1969

Hi,


Yes, you can send us sample to techsupport@weonlydo.com


Drazen

locked
  2391 views

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

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

I can only hope I will have the pleasure to work with other products by "We Only Do" in the future.

Tomer Spivak
Verint Systems Ltd

I really like these products - they are consistently first rate!

David Witten
WWR Development, Inc.

Your component works really great. With minor effort I have been able to convert my delphi application...

Gilles Hache
Cisco Systems Inc.

WeOnlyDo!COM will be the first stop I make should I require any further off-the-shelf components.

Dean Keigan
RBC Capital Markets

This has been, by far, the best experience I have ever had dealing with a support entity in my long career in the technical arena

Frank Kloskowski
GlobalCare Inc.

We are having great success with your component ... email server that has over 750 000 mailboxes back ended by a SQL server...

Conrad Leigh
Leaf Wireless

Thank you very much for the rapid responses. I was a little nervous about dealing with a company that is on a different continent from me. You have proven my concerns to be unfounded.

Robert Pacheco
Surebridge, Inc.

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

Zack Menendez
Mapframe Corporation