No, the plugin uses the WP installation connection and issues SQL that likely only working with MySQL.
Thanks – so if I can connect by odbc to the main myqsl database, I could also connect to “yours,” Right? I assume it would be one of the available database options. It would save me so much time. Too bad Filemaker doesn’t work directly with the iqy. I love that.
Right, the plugin uses the same database as the WP installation does, but it uses its own table in that DB instance (wp_cf7dbplugin_submits). So if you can get to the WP DB via ODBC, you can get to the table.
But the data in that table may not be organized the way you expect to see. Each form/field is its own row (multiple rows per submission) and the data gets pivoted during the query. Read this post to see how the pivot query is constructed and this post about the schema.
