Current Position:Home > DTW - Trouble using ODBC and Configuration Files

DTW - Trouble using ODBC and Configuration Files

Update:11-30Source: network consolidation
Advertisement
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.

The Best Answer

Advertisement
I've got the same problem.
I solve it once by editing the xml file's <ExID> tag from <ExID></ExID> to <ExID />
So the problem resides at the XML syntax.
My problem is that I lost the XML file I used and now I can't make it work again.
Have anybody found the solution at this problem or is there an updated version of DTW?
  • DTW - Trouble using ODBC and Configuration Files Update:11-30

    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 sav

  • 11g ER: Checkbox "Don't ask me again" for Configure File Type Associations Update:10-11

    Hi JDev team On opening JDev 11g the Configure File Type Associations dialog opens each time, allowing me to associate JDev with 4 different file types. I don't want to associate the file types with JDev, I haven't found an option to turn this off an

  • War files and configuration files Update:10-11

    Hi, I'm trying to deploy servlets using a WAR file. Everything works fine except I can't read the configuration files from the servlet code. The code reading the configuration file is as follows: input = ClassLoader.getSystemResourceAsStream("test.pr

  • An OS-Intergrated place to store per-user application configuration files. Update:10-11

    A Chairde, I'm developing an application that could be deployed on multiple platforms. I'm looking for a location to store per-user configuration files in a OS-integrated way. I use a utility class to determine the OS of the users machine. I know fro

  • Imac is no longer able to open the Configuration file Update:10-11

    Hi , I have an imac ( ilamp) 20' connected to ADSL, via Netopia Router which is connected to the Airport extreme connected to imac, for the PB Aluminum Tiger 10.4.5. we both can connect. PB can print via imac/printer. The imac is no longer able to op

  • No dsn is present in the configuration file in the reporting services 2008 Update:10-11

    HI i have found this error in the log file of my reporting services , when i comes to the Configuration file in that my DSN path is empty no input code is there in that DSN tags <DSN> <DSN/> it shows the empty tags, and my Current Report Serve

  • Configure File Type Associations dosen't work for users Update:10-11

    Hi EB, Does anyones knows how to set the File Type Associations for users ? It works for me when i'm logged in as Admin but not as a user. When logged as user it always ask to configure the file associations when i open JDev and even with JDev open i

  • Error reading configuration file Update:10-11

    I've setup the Adobe Access 4.0 trial license server and when I run the Validator.bat with -g -r on the Tomcat install dir \licenseserver I get an 'Error reading configuration file' message. Here is the log dump: [] 2012-12-20 22:46:32,176 INFO  [[Pa