DSXchange

Hi Everybody,

I need to import the metadata of the tables into profileStage from a text file/folder. I have created a DSN using Microsoft text driver and pointed it to the folder. I have specified all the options in the "Load Database Meta Data" screen and when I click on "Select Table" button, I get the following error:

"Error retrieving table list
Error may be database or schema specified in this connection does not contain any tables. Please see the latest error log (select Tables_yyyymmdd_n.log) for details"

Other wise the DSN works fine when working with DataStage.

I have seen this earlier in the forum but that did not help me really . Can anyone pls get me out of this situation.


Thanks in advance,

Regards,
Nash[/i]

Loading the data drivers from ascential is the only way to do that.

Thanks for that feedback. ODBC is supposedly a "standard" so, if ProfileStage can not use drivers that comply with the standard we have a bug. Have you reported this to your support provider and, if so, with what result?

I have run into the exact same issue and after talking to support they will not even listen to the problem if you are not use the ascential drivers. with that said I still can not connect to an oracle db through profile stage.