InfoPath Dev

Hi,


I'd like to connect an InfoPath form to a MySQL database.

So, I've installed a MyODBC driver. But I can't correctly create the connection. The message is "Test connection failed because of an error in initializing provider. Catastrophic failure."

I've learned that there were some bugs with MyODBC drivers.

Does someone already made a connection to MySQL via MyODBC ?


Thanks.

In order to connect a form to a MYSQL database you would need to use a webservice. InfoPath only supports Microsoft SQL or Access for its native "Database" connection. Unfortunately it does not use ODBC. However with Web Services anything is possible. I am not familiar however with what it would take to add webservices to MySQL.

Thanks
Clay

Hi,

Do u check the infopath ODBC DataConnections ?
when u want to design a new form , click on "New From Data connection".
click on "Select DataBase" and Then check the first choice and then click on "New Source".
"ODBC DSN" DataSources are available there and u can choose which one u want to use .
you can also choose "Other/Advanced" Datasources and manage your connection .
I hope this could be helpful !

Even if it is possible to configure an ODBC connection, it doesn't seem possible to use it.

I have created a form in infopath Now I have to Enter the value in the form so that it should store in access database....please tell the procedure because just now i started to use infopath.