I'm looking to have my FM solution communicate with a SQL based solution. I was told that I need drivers for ODBC DB-OLE.

What is the DB-OLE? I looked for drivers and cannot see anything relating to that.

Thoughts anyone?

M

the direction of the communication is the key. If you want FM to push/pull data from another source you need the drivers for that other source and set up DSNs (Data Source Names) using those drivers.

That part is totally outside of FM's control and you need to find info on the other SQL solution.

If you want the other solution to be in control then you need to work with FM's ODBC drivers.

What do you mean by this? It seems to contradict your first comment.

If you want the other solution to be in control then you need to work with FM's ODBC drivers.

Thanks,

M

The direction has to do with where you do your coding. Which solution is "in control".

If it is the other solution your coding logic is in that other solution and you're pulling data out of FM and/or pushing other data into FM. In this scenario you need to make a connection to FM from the other source using FM's ODBC drivers.

If your coding logic is in FM then FM is in control and you need to make a data connection to the other source using the other source's ODBC drivers and push FM data into the other source and pull data from that source.