LiveCode Forums.

As mentioned, if the revopendatabase returns an integer you're connected, otherwise look for error messages.

for me this is the error returned: Not connected [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Which makes sense since I don't have the information to set up a dsn for your database. What is in the result for you?

There is always the fallback of using cfm scripts to grab your data and learn to deal with the output.

If you DO have the correct dsn setup to point to your remote database, does the remote db allow external connections? (if not, we're back to using cf to do the query through a web call) As for livecode server, yes there is one, works really well, but it sounds like you know cold fusion well enough to do what you want with it.

To close this out - I have finally figured out that my ISP did not have my new IP address on the list of approved IP addresses- so the firewall was blocking it. All the code I was using on LiveCode's end was correct. But I realized that contacting the database directly was not a good idea because of hacking by others. (I know...you have been trying to tell me that.) Anyway, I have set it up so that Cold Fusion contacts the database and posts the results (with no other text) - with the first line the names of the columns. Once I bring it into LiveCode, I have LiveCode switch <br> with return and usetab (I put that it where there is supposed to be a tab) is switched to tab. Then it's like LiveCode imported a .txt tab delimited file.

Thanks for helping me through this.