Skip to main content
T
techieg
Participating Frequently
January 12, 2010
Question

Database Errors

  • January 12, 2010
  • 1 reply
  • 800 views

Hello All,

I am taking a Coldfusion class and hav completed the projects. The problem is that the database works fine on my PC but when uploaded to the school's server there is always an error (such as (Datasource studentinfo could not be found) when I access the page on the school's server. The teacher said I did not properly name the database. Any ideas on "how to properly name the db"?

Thank you,

This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
January 12, 2010

My opinion is different than your teacher's.

There are two prerequisites for a datasource to be recognized.  First, the database has to be made available to ColdFusion.  Second, a datasource has to be set up on ColdFusion by the Administrator.

Were both steps done?

If so, does datasource "studentinfo" point to your database?

T
techiegAuthor
Participating Frequently
January 12, 2010

Dan, thanx for your response. The datasource was set on conldfusion8 via the admin login on my local computer so it works fine, however, this is not the case for the school server because I simply uploaded the assignments and projects to the school server without the ability for me to create the datasource on the school server. Although in each student's Database folder on the school server there is a DSNXXXX.mdb file, I'm not sure if this file is supposed to specify the datasource per student. Any ideas?

T
techiegAuthor
Participating Frequently
January 12, 2010

Here is one of the errors;

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

Datasource signup could not be found.

The error occurred inD:\sololizmi\Students\0103\homeworks\week10\signup.cfm: line 10
8 : <body>
9 : 
10 : <cfquery name="qgetguests" datasource="signup">
11 : select FirstName, LastName, Email
12 : from signup
DATASOURCE  signup
Resources:

Browser  Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/532.5 (KHTML, like Gecko) Chrome/4.0.249.64 Safari/532.5
Remote Address  208.58.77.206
Referrer  http://160.253.0.40/Students/Students/0103/homeworks/week10/index.cfm
Date/Time  12-Jan-10 04:44 PM
Stack Trace
at cfsignup2ecfm2073356486.runPage(D:\sololizmi\Students\0103\homeworks\week10\signup.cfm:10) at cfsignup2ecfm2073356486.runPage(D:\sololizmi\Students\0103\homeworks\week10\signup.cfm:10) 

java.sql.SQLException: Datasource signup could not be found.
     at coldfusion.sql.DataSrcImpl.validate(DataSrcImpl.java:95)
     at coldfusion.sql.SqlImpl.validate(SqlImpl.java:279)
     at coldfusion.tagext.sql.QueryTag.doStartTag(QueryTag.java:467)
     at cfsignup2ecfm2073356486.runPage(D:\sololizmi\Students\0103\homeworks\week10\signup.cfm:10)
     at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:192)
     at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:366)
     at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
     at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
     at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
     at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
     at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
     at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
     at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
     at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
     at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
     at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
     at coldfusion.CfmServlet.service(CfmServlet.java:175)
     at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
     at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
     at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
     at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
     at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
     at jrun.servlet.FilterChain.service(FilterChain.java:101)
     at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
     at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
     at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:284)
     at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
     at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
     at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
     at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
     at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
     at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices