I have spent hours actually days lookling for a way to add, edit, update and delete record form mysql database using adobe designer but i can't figure out how it is done, can someone pint me in the right direction..
thanks
SG
My Product Information:
LiveCycle Designer, Windows
Is the MySQL DB local or Remote? This makes a huge difference.
The "DataView" tab in LiveCycle Designer is for connecting to an "OLEDB" driver, i.e., an OLE (Read MicroSoft) interface for a Database. MySQL is not specifically listed in the stuff that installs with LiveCycle Designer, but that doesn't mean that such a thing doesn't exist. If the DB is local then you can probably hook it up to ODBC, which the PDF can talk to, I don't know. You might need to find an OLEDB or ODBC driver for MySQL.
But if the DB is remote, that's a different game.
For a remote DB you'll need to write a server side script to handle the DB access and talk to the document. There are some different options here, none of them easy or automatic. First, a PDF can talk to a server by two mechanisms, HTTP request/response and SOAP. SOAP requires specail Rights enabling to work on Reader so I'd stick with the standard HTTP access.
Cold fusion also offers some server side form filling features, but this probably won't work for your case. But if your serious you should do some reseach on it.
The "DataView" tab in LiveCycle Designer is for connecting to an "OLEDB" driver, i.e., an OLE (Read MicroSoft) interface for a Database. MySQL is not specifically listed in the stuff that installs with LiveCycle Designer, but that doesn't mean that such a thing doesn't exist. If the DB is local then you can probably hook it up to ODBC, which the PDF can talk to, I don't know. You might need to find an OLEDB or ODBC driver for MySQL.
But if the DB is remote, that's a different game.
For a remote DB you'll need to write a server side script to handle the DB access and talk to the document. There are some different options here, none of them easy or automatic. First, a PDF can talk to a server by two mechanisms, HTTP request/response and SOAP. SOAP requires specail Rights enabling to work on Reader so I'd stick with the standard HTTP access.
Cold fusion also offers some server side form filling features, but this probably won't work for your case. But if your serious you should do some reseach on it.
Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script