Jump to content
Welcome to the new FusionPro User Forum! ×

Javascript and ODBC


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.



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...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...