Search results for query: *

MarshallSoft.com makes a nice library for that purpose. Works great and it's inexpensive: http://www.marshallsoft.com/ http://hostingxchange.com - Fast, Easy, Reliable and Affordable Hosting

Generally, when I have problems importing an Excel file, I save it as a CSV and import that instead. Failing that, try saving it in Office 97 format and see if that works for you. http://hostingxchange.com - Fast, Easy, Reliable and Affordable Hosting

That's incorrect. The windows task scheduler can fire tasks at intervals down to one minute intervals. First create the task and specify one day intervals, then open the task, go to the Schedule tab and click the Advanced settings button. Then tick the Repeat checkbox and specify the interval...

My application only required updates every 5 minutes. Don't know about shorter intervals. You could always use a hybrid approach or use the task scheduler to monitor and restart your app if needed as well. http://hostingxchange.com - Fast, Easy, Reliable and Affordable Hosting

I wrote a similar app in VFP 5 some years ago and had the same problem. I ended up resoving it by doing away with the timer and using the Windows task scheduler instead. Worked like a charm and it took only minutes to implement. Just wasn't worth the time it was going to consume tracking down...

You might find this tutorial useful. It uses cygwin to set up an ssh tunnel to connect via odbc to a mysql database. This would only require that ssh be available on the remote host and that you had the ability to set the correct permissions for the mysql user. (IOW Port 3306 doesn't need to be...

Hosts that allow remote odbc connections are becoming hard to find, I thought I might be doing the community a service. Sorry about that. http://hostingxchange.com - Fast, Easy, Reliable and Affordable Hosting

Setting your Remote Host Access to % means anyone in the world can attempt connections to your MySQL server Randy. A much better idea is to limit connections to a specific host name or IP address. If you have a dynamic IP address you want to connect from, just go to dyndns.org and set up a free...

No doubt there are less expensive solutions out there Eliott. I too could offer such packages and make them look very attractive, but then I would have to do as other hosts do and limit the number of connections to the server (ever had a MySQL timeout or site just freeze up on you?), limit...

You're right, it is a simple issue. MySQL will accept ODBC connections on port 3306 if configured properly. I've written VFP apps that depend on remote updatable views to a MySQL table with great success. It's not that hard to get around the security issue if there's enough interest. You simply...