Question
Datasource could not be found
Been working on this problem for several days now. My CF 7
server with developer configuration (using the built-in CF server)
is fine, so I copied my production-ready site to my new CF 8
production server (using IIS). The problem, now, is that I'm
getting a "Datasource dimdbcfm could not be found."
The datasources on the CF 8 server have been set up in the CF admin, so that shouldn't be the problem. In fact, if I use the built-in CF server as a test ( http://s355ab5:8301/CFIDE/index.cfm) I get the expected page with it's menu form and database-driven options. However, the CGI values are missing ... not showing int the debug or cfoutputs. For example, remote_user and auth_user is blank, but remote_host is good. On the other hand, if I use the IIS server ( http://s355ab5/CFIDE/) it gives me the CGI values just fine but the datasource can not be found.
I've researched the problem across the net, through my books, even check with some in-house help and can't figure it out ... mostly because I can't find the same problem. I'm thinking it's a case where it's either a misunderstood/ambiguous cause or something is not right with my IIS or my CF.
Another potential problem is the location (directory path) of the site and/or the IIS settings.
• I kept the site under the \JRun4\servers\KIMprod\cfusion.ear\cfusion.war\CFIDE directory.
• I didn't bother with the \Inetpub\www\CFIDE directory.
• I reset the default site to the same JRun4 directory.
• I checked "local path" and the associated permissions. Seem OK.
Other checks done.
• I checked the Authentication Methods and set to "Integrated Windows authentication".
• I have CF configured as Multiserver.
• I even tested this with a temporary ODBC connection. The test connection was successful.
• I also added a JRunScripts virtual directory as suggested by another web site. (Didn't get created automatically.)
• Also created sandbox settings. No change.
Seriously stuck here, and I'm hoping it's a simple problem, even though I might hang my head in embarrassment if it is.
Let me know if you need more info or clarification.
The datasources on the CF 8 server have been set up in the CF admin, so that shouldn't be the problem. In fact, if I use the built-in CF server as a test ( http://s355ab5:8301/CFIDE/index.cfm) I get the expected page with it's menu form and database-driven options. However, the CGI values are missing ... not showing int the debug or cfoutputs. For example, remote_user and auth_user is blank, but remote_host is good. On the other hand, if I use the IIS server ( http://s355ab5/CFIDE/) it gives me the CGI values just fine but the datasource can not be found.
I've researched the problem across the net, through my books, even check with some in-house help and can't figure it out ... mostly because I can't find the same problem. I'm thinking it's a case where it's either a misunderstood/ambiguous cause or something is not right with my IIS or my CF.
Another potential problem is the location (directory path) of the site and/or the IIS settings.
• I kept the site under the \JRun4\servers\KIMprod\cfusion.ear\cfusion.war\CFIDE directory.
• I didn't bother with the \Inetpub\www\CFIDE directory.
• I reset the default site to the same JRun4 directory.
• I checked "local path" and the associated permissions. Seem OK.
Other checks done.
• I checked the Authentication Methods and set to "Integrated Windows authentication".
• I have CF configured as Multiserver.
• I even tested this with a temporary ODBC connection. The test connection was successful.
• I also added a JRunScripts virtual directory as suggested by another web site. (Didn't get created automatically.)
• Also created sandbox settings. No change.
Seriously stuck here, and I'm hoping it's a simple problem, even though I might hang my head in embarrassment if it is.
Let me know if you need more info or clarification.
AdChoices