MAS200 to Oracle using ODBC Error

[nickerp]

Hello Everyone,

I am trying to export data from MAS200 into Oracle using the ODBC. The following are the steps that I followed.

Created a job in Export Job Maintenance

Provided the description

Selected the File

Selected ODBC Data Source for File Type

Clicked on the ODBC Login Security button and provided the login information

Selected the Oracle ODBC Data Source as the Data Source

Clicked on the tables button

Displayed all the tables

selected the required table from the list

Went to the Data tab on the Export job maintenance and selected the fields that I wanted to export

Then I pressed the Accept button

Then I received the following error.
"Error #15: Operating system command failed
program VIWX15 Line 0690"

 

[BigLouie]

Nick, Nick, Nick, one bit of advise. Give it up. Do not use VI to export data. Use code in Oracle to pull the data, way way faster. Use SQL queries.

 

[nickerp]

Thanks for the advice louie. Can you please provide me with the necessary steps how to pull MAS200 data from Oracle using MAS200 ODBC. I really appreciate your time.