I want to use ajDBRunSQL to execute a SQL statement. I have defined a MySQL database connection on the External Resource worksheet already. However, when I clicked Preview Function Point to test the function, the following error popped up.
System Error
========
1. Function ajDBRunSQL in cell BizLogic!A13: Data Source ID 'primary' is invalid or disabled in '##ExternalResources' sheet.
Does anyone have any ideas ?
Hi @Terry Fok
This error appears when AlchemyJ cannot find the data source configuration. You mentioned that you have already defined it in the ExternalResources worksheet. Please further check the following:
In Data Source Configuration table, is the disable column set to "Yes"? It should be empty. Otherwise, the data connection is disabled.
On your endpoint group worksheet, check whether you have filled in the data source ID for your function point. Remember data source IDs are case-sensitive.
Make sure you have provided the correct data source ID to ajDBRunSQL.
I hope this helps.