Hi,

I have a client that is using DB/Textworks as their current database. I will be writing an application in Coldfusion that will need to interface with this database.

What I am trying to find out is how can I go about connecting to and then querying the database from my Coldfusion code? Is there a way to setup an ODBC connection of any kind?

Once I am connected how would I go about structuring my queries? Do I just use standard SQL for that?

Any answers would be appreciated.