Access DB for ColdFusion MX

[IkeInMass]

How do I setup a MS Access database in Plesk to work with ColdFusion 7 MX? I would think there would be a JDBC Settings like there is for ODBC Settings. I've tried setting it up as an ODBC datasource and can't connect to it. I'm on a shared hosting provider.

 

[renhack]

You still need to set up the DSN in the Coldfusion administrator. It would be a nice feature if plesk could add this automatically but it doesnt.

-ren

 

[IkeInMass]

You mean I have to bug my provider every time I need a new DSN?

 

[renhack]

Unfortunately.

 

[renhack]

Also, as you might know since you mentioned jdbc. CF5 would pick up odbc system DSN's but CFMX only picks up system JDBC.

Since CFMX is a J2EE app there may be a component out there that allows this. WHo knows.