Jump to content

Javascript and ODBC


ericg

Recommended Posts

I was wondering if anyone could tell me if you can connect to an ODBC datasource through Javascript using, say, the OnJobStart rule. My problem is that I am using a .csv file for my input file but it doesn't have all the data i need in it. And adding the data I need would be quite a pain because it would require numerous changes back up the line. Any help would be appreciated.

 

Thanks

Link to comment
Share on other sites

Sorry, the answer is No. You can only connect to ODBC for your main input data source (and currently on Windows only). There's no ExternalDataFileEx-type functionality to access a secondary ODBC data source. Your best bet is probably to dump the data to a tab-delimited file and use ExternalDataFileEx.
Link to comment
Share on other sites

Just to clarify, you can indeed access fields from an ODBC data source in JavaScript with the Field function, just as with any other primary data source type. However, the "secondary" data file functionality through ExternalDataFileEx only works for flat (delimited) text files. (Did that clarify or just confuse things?)
Link to comment
Share on other sites

  • 2 years later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...