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 last published in August 2004

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchCloudComputing

SearchSoftwareQuality

SearchSOA

TheServerSide

SearchCloudApplications

Close