Skip to Content
0
Apr 18, 2006 at 05:40 PM

DTW - Trouble using ODBC and Configuration Files

99 Views

I am using SBO SP1 PL2 and DTW 2005.

I have been making use of saving the configuration for the import of an object and then using the command line to run it, as described in DTW help under "Schedule Run".

I typically use tab-delimited files saved from Excel and the above method works very well.

However, I would prefer to use ODBC directly from the template tables I have in a SQL database. It works perfectly using the GUI within DTW, and it lets me save the configuration file, but when I try to run DTW from the command line using ODBC, I get these error messages:

Can not connect to ODBC data source.

Can not get SQL handler.

Does anyone have any suggestions on how I can use DTW from the command line while using ODBC sources?

Thank you.