Has anyone been able to access a d3 database using macromedia's coldfusion
going through mv.net, or any other way?

Bryce Goodwin
bryce2000 (AT) byu (DOT) edu

"Bryce Goodwin" <NOSPAMbryce2000 (AT) byu (DOT) edu> wrote:
Hey Bryce, it does no good to put NOSPAM in your mailing address if
you're just going to sign your unmunged address at the bottom of
postings anyway...

For Coldfusion to D3:

If you want to use mv.NET, check here for one technique:
http://coldfusion.sys-con.com/read/44772.htm

Also, you can use a CFHTTP for a Get or CFHTTPPARAM for a Post call to
a web server running ASP.NET, parse the query string, use that to
invoke mv.NET functions to the back-end (or anything else that will
plug you into D3), then just return results as content-type
text/plain. Then parse the result on the CF side. I did this years
ago using FlashCONNECT as the pipe and it worked fine.

If you don't want to use .NET in the middle tier, you can use Java,
since CF runs over J2EE anyway. Use the same technique to HTTP in
through FlashCONNECT.

And if you are adept at Java then note that FlashCONNECT exposes a
Java API as well as Web Services, so you should be able to plug more
directly into D3 through there.

You can also wrap the D3 Class Library in a COM wrapper within Java,
but I wouldn't recommend that as a production solution. Might be
better to use the above CFHTTP option then use the library from an ASP
page.

Finally, again for a Java developer and only because CF uses Java
internally - while the D3 ODBC Server does not announce itself as
JDBC-compliant, it can process basic JDBC requests through a bridge.
This solution will only work with a Win32 client/middle-tier because
D3 doesn't have an ODBC client driver for *nix. I did this years ago
but again I don't think it's a production solution.

Please let me know how you decide to go about this, or if you'd rather
have someone else do it.
TG@ 99.ways.to.skin.your.catNebula-RnD
..com