SQL Database Integration

Re: MySQL connection via MyODBC

msatish84 — Sat, 14 Apr 2007 09:52:38 GMT

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.

Re: MySQL connection via MyODBC

TheOnlyMaX — Mon, 12 Feb 2007 14:14:34 GMT

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

Re: MySQL connection via MyODBC

Navid — Mon, 12 Feb 2007 13:47:10 GMT

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 !

Re: MySQL connection via MyODBC

Clay Fox — Mon, 12 Feb 2007 13:28:24 GMT

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

MySQL connection via MyODBC

TheOnlyMaX — Mon, 12 Feb 2007 12:21:29 GMT

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.