Adobe LiveCycle Designer vs. MySQL 4.1


hi,
i have design input form client using livecycle designer, client want use database mysql server. can't make connection mysql server.
to connect, use "new data connection" file menu, select "oledb database", select "build ..." button, olebd providers select "microsoft ole db provider sql server", click "next" button. in field "select or enter server name" write "localhost", specify user name , password, specify database on server, , click "test connection" button. error message i've got is:
"test connection failed because of error in intializing provider. [dbnetlib][connectionopen(connect()).] sql server not exist or access denied."

my question is: can use livecycle designer mysql server? if yes, need? how can make connection mysql server? can use sql statements, select, insert , update? saw script available formcalc , javascript.

i find on site (http://www.romsym.ro/detalii.php?ctg=687) mysql server can use livecycle, have install on server "windows 2003 server, enterprise edition".

if use ms access database, need server, or can use on computer windows xp professional?

thanks.

p.s.
i use livecycle designer 8.0

i had no problem connecting accesss...

i created drop down menu , clicked on object > binding click on > default binding (open, save, submit) "new data connection"
then connect database using filedsn (i created filedsn connect access db in odbc connections on computer).

then selected tables , under query wrote
select * tablename

then gave me fields table , dragged name field on drop down menu.


More discussions in LiveCycle pre-ES (6.x and 7.x) discussions


adobe

Comments