Hi All,
I am having issue connecting to the local database from the Adobe Form.
Here is the code that I have to open the connection:
// Search for sourceSet node which matchs the DataConnection name
var nIndex = 0;
while(xfa.sourceSet.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oDB = xfa.sourceSet.nodes.item(nIndex);
xfa.host.messageBox("Check 1: "+xfa.sourceSet.nodes.item(nIndex).name); // I am getting the DSN name that I created.
oDB.open(); // I am getting the below message. Once I click "Yes". It is just opening the Form.
xfa.host.messageBox("Check 2: "+xfa.sourceSet.nodes.item(nIndex).name); // I am NOT getting this message.
oDB.first();