Q

Is it possible to schedule SQLs written for a paradox database?

Is it possible to schedule SQLs written for a paradox database? I have written four SQL scripts to extract weekly data from a few paradox tables. As of now, I am running these queries manually and exporting the result set into text files using the export facility of Paradox. Is it possible to automate the whole process to save time and reduce the chances of any error(s)?
You can always automate things! You just need to create a Windows Service application, that will run the scheduled task. When it runs, you can just connect to the paradox database using ADO.NET and extract the data directly. Check my previous answers: http://searchvb.techtarget.com/vsnetATEAnswers/0,293820,sid8_gci951954_tax293673,00.html and http://searchvb.techtarget.com/vsnetATEAnswers/0,293820,sid8_gci996548_tax293673,00.html.
This was first published in August 2004
This Content Component encountered an error

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchCloudComputing

SearchSoftwareQuality

SearchSOA

TheServerSide

SearchCloudApplications

Close