This plugin is potentiallymost intresting and efficient.
However, after two days of intensive testing I've come across serious problems when reaching out to SQL Server tables.
1) Field names containing accented characters or other 128 bit characters are not accepted, for example "Extrudé".(item 3 on enclosed image).
2) Table names with more than one word are not accepted, for example "PFA Extrudé". (Item 1 on enclosed image).
3) Computed fields are not accepted. If I leave them out of the field selection it is OK, and they are still updated properly. I note however that I can replace them with a WpDataTables computed field. (Item 4 on enclosed image)
I can happily provide you with an access to my SQL Server test database for you to experiment. Just let me know if you intend to try and correct these problems.
4) Another question I have is why I cannot use the SQLSRV driver instead of the ODBC driver. Is this SQLSRV driver intended only for MySql ?
5) Last, when accessing an exisitng SQL Server database, it would be practical to see the tables and the views in alphabetical order.
My client is waiting to use your plugin, but cannot under the circumstances. I also intend to upgrade to the Pro version as soon as these problems are cleared.
Hello,
This plugin is potentially most intresting and efficient.
However, after two days of intensive testing I've come across serious problems when reaching out to SQL Server tables.
1) Field names containing accented characters or other 128 bit characters are not accepted, for example "Extrudé".(item 3 on enclosed image).
2) Table names with more than one word are not accepted, for example "PFA Extrudé". (Item 1 on enclosed image).
3) Computed fields are not accepted. If I leave them out of the field selection it is OK, and they are still updated properly. I note however that I can replace them with a WpDataTables computed field. (Item 4 on enclosed image)
I can happily provide you with an access to my SQL Server test database for you to experiment. Just let me know if you intend to try and correct these problems.
4) Another question I have is why I cannot use the SQLSRV driver instead of the ODBC driver. Is this SQLSRV driver intended only for MySql ?
5) Last, when accessing an exisitng SQL Server database, it would be practical to see the tables and the views in alphabetical order.
My client is waiting to use your plugin, but cannot under the circumstances.
I also intend to upgrade to the Pro version as soon as these problems are cleared.
Thank you for a prompt comment and best regards.
Attached files: wpdt1.png