Skip to main content
Known Participant
May 5, 2006
Question

Data source CFMXBible.mdb could not be found.

  • May 5, 2006
  • 3 replies
  • 627 views
Hello
I am following the book CFMXBible and I got it set up.
but in the beginning of the tutorial there is a form that is suppose to sent the contents of my form to the db.

After I press the submit button, I get this error’


What is wrong here?
What should I do?


thanks


The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.
The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request
Data source CFMXBible.mdb could not be found.




Resources: · Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option. · Check the ColdFusion documentation to verify that you are using the correct syntax. · Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322)
Remote Address 127.0.0.1
Referrer http://server:8500/cfmxbible/ch02/companyaddform.cfm
Date/Time 05-May-06 01:23 PM



This topic has been closed for replies.

3 replies

Inspiring
May 8, 2006
What is your code that you are doing in your query to access the db?
Known Participant
May 8, 2006
hi again,
i found something interesting.

there is another page that are in the finished folder.
C:\CFusionMX7\wwwroot\CFMXBIBLE\ch02\finished
it seems to work when i use the files in there.

but when i use the files that i created it is not working
here are the comaprisons.

-------------------------

From this page
//myserver:8500/CFMXBIBLE/ch02/CompanyAddForm.cfm
I hit the submit button it goes to this page

//myserver:8500/CFMXBIBLE/ch02/CompanyAddAction.cfm
and this errors occurs

The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.
The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request
Data source CFMXBible.mdb could not be found.




Resources: · Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option. · Check the ColdFusion documentation to verify that you are using the correct syntax. · Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322)
Remote Address myserver
Referrer //myserver:8500/CFMXBIBLE/ch02/CompanyAddForm.cfm


However,

In this page
//myserver:8500/CFMXBIBLE/ch02/finished/
there is a link

to add a form
//myserver:8500/CFMXBIBLE/ch02/finished/CompanyAddForm.cfm
this works fine when I click submit.

It goes to

//myserver:8500/CFMXBIBLE/ch02/finished/CompanyList.cfm

it shows all the current list on the db. I also checked the access db and it is all in there.


Company List
ID Name Address City State ZIP Code
21 mama 252 los angeles ca 90056 Employees Add Edit Delete
14 Ma's Homemade Pies 5332 Courtland Court Abilene AL 29555 Employees Add Edit Delete
15 Normwelland and Drake Clothing Co. 1240 Pierpont Point Boston MA 02134 Employees Add Edit Delete
16 Pizza Palace 1548 High Point Freeway New York NY 00248 Employees Add Edit Delete


What seems to be the problem? Hmm?

Lets back track
On the tutorials there are files to be copied from the cd to the drives.

There are finished files done and there are files that I have created but has exactly the same line of codes.


?
Inspiring
May 8, 2006
What is your code that you are doing in your query to access the db?
Participating Frequently
May 5, 2006
Did you go into ColdFusion administrator and add the datasource in question?
Known Participant
May 8, 2006
C:\CFusionMX7\CFMXBible.mdb

Yes,
it is in the folder outside wwwroot
In the C:\CFusionMX7
C:\CFusionMX7\ CFMXBible.mdb



Data & Services > Datasources > Microsoft Access

Microsoft Access : CFMXBIBLEACCESS
CF Data Source Name
Database File C:\CFusionMX7\CFMXBible.mdb
System Database File
Use Default Username
ColdFusion Username
ColdFusion Password (16-character limit)
Description