Skip to main content
July 7, 2006
Question

CF Data Source Problem

  • July 7, 2006
  • 1 reply
  • 608 views
When I upload my pages to my website, I get this error message:

Data source SiteTest could not be found.
The error occurred in C:\Websites\yh7849a3\login.cfm: line 9

7 : <cfset MM_redirectLoginSuccess="success.htm">
8 : <cfset MM_redirectLoginFailed="failure.htm">
9 : <cfquery name="MM_rsUser" datasource="MikesTest">
10 : SELECT UserName,Password FROM tblLogin WHERE UserName='#FORM.Username#' AND
11 : Password='#FORM.password#'

Why is it not finding my data source? Do I need to upload the data source to the web?

This all worked with my CF test server
This topic has been closed for replies.

1 reply

Participating Frequently
July 7, 2006
Did you create the datasource on your "production" ColdFusion server? What kind of database?

Phil
July 7, 2006
its a microsoft access database...for usernames and passwords....

what do you mean by my production coldfusion server?
Participating Frequently
July 7, 2006
quote:

what do you mean by my production coldfusion server?

Well, you said "This all worked with my CF test server" so I assume that you have a different ColdFusion server where this isn't working. If this is NOT the case, then when you said "I upload my pages to my website...", what did you mean?

It may just be a matter of uploading a copy of your Access database to your "website" and creating the datasource there.

Phil