OLEDB data connection

[Former Member]

Hi all.

We are trying to create an AIF that connects to a SQL server DB at runtime.

We've created an OLEDB data connection, at design time in the Livecycle Designer the connection is estabilished ad in preview we can see the DB data. At runtime when the PDF is generated and opened in the Reader we get error message ("Unable to create SOM expression $record.[connectionName.[fieldName]") and the data are not displayed.

We did the same thing in Livecycle Designer standalone (outside the SAP gui) and saved the form as a "Dynamic XML form". This way is not possible to save the form data but.....

...magic the data are retrieved from DB!

Anybody know if ther are any parameter that need to be set during form generation or

if SAP blocks the OLEDDB connection option?

Thank in advance

Luca

[OttoGold · Accepted solution]

Hello, notice that the SAP Adobe forms are the older version (one version back) of the standalone LCD. That could mean your problem has no solution in SAP because it is a brand new feature. This can be tested on older standalone LCD I guess. Also look for the guy who´s name is Cameron who is a kind of Adobe guru, he may help you on this.

This is so specific issue I can recommend you to talk directly to SAP or Adobe guys. I have never done this and know nobody who has, I am very sorry I can´t help, Otto.

[Former Member · Accepted solution]

Hi Otto, thanks for response.

For standalone LCD, i mean that i use the SAP version of LCD but i call it directly from my filesystem outside the sapgui, this allow to save the form on my local pc in different formats (i use this only for test: this form has no reader rights, you can use it in Adobe Professional, while n Reader you can't save the data).

The problem i've exposed above happens when the form is generated (with reader rights) from SAP.

I know Stefan Cameron blog and i used his tutorial to do this this, but what works for him doesn't for me!!

Than i think this is a SAP problem. I opened a message yesterday, i'm still waiting the response.

Luca

[Former Member]

Hi,

Did any one have the answers to this Problem.

I am also stuck and don't know what to do next.

[OttoGold]

That is what I tried to tell: SAP works with older Adobe version. Not the reader but the ADS service. Maybe this older version generator generates a form which is not capable of connecting to the OLEDB the way you expect.

Did you set all the required things in the form and the coding? I guess your form is dynamic, is fillable, fields are not read-only etc. You seem to be a skilled Adobe developer:))

Otto

[Former Member]

no one can help on this?