Can we have LF forms access data to and from MySQL server or is it strictly only tied in to MSSQL ?
That's what I thought, i am assuming LF forms can look at mssql views, because we might be able to create views on sql server from data of mysql.
Anyone here worked on LF forms tie in to Views on sql ?
Hi,
I have used a Linked Server from MSSQL to MySQL. You will want the view on the MySQL side to limit the data being loaded. On the MSSQL side just treat the result like a table.
Curtis so you were able to fill fields on Forms using data from linked MySQL ? I have created views and sps on SQL server that fetch data from Linked Mysql but forms cannot grab or see that data at all.
Hi Sumeet,
Yes, I have a link server to a MySQL server. The MySQL server has a view that limits the data being pulled to the current year. On the MSSQL side there is a sp that further filters the data and makes a set of values available to a drop-down control on my form.
You might want to verify that your MSSQL sp will return data if you execute it in MS Management Studio and that your sp can be seen in the form if you hard code some values in the sp. Also consider how much data you have in the MySQL view. Remember that the entire result set will be brought MSSQL side regardless of criteria you are including in your sp.
I believe it is currently MSSQL and Oracle. See the help documentation.