Skip to main content
B
bdixon12
Participant
September 18, 2009
Question

Error Executing Database Query Question

  • September 18, 2009
  • 1 reply
  • 1696 views

I have mulitple coldfusion applications and they all suddenly starting displaying the message below. Any idea what the problem is? I really don't know where to start with debugging.

Error Executing Database Query.

Unspecified error
The error occurred in D:\Hosting\tnwhiz\find.cfm: line 23
21 : </cfcase>
22 : <cfcase value="community">
23 : <cfquery name="GetProperties" datasource="#Datasource#">
24 :      SELECT p.*, s.*
25 :      FROM Properties p, Subdivisions s
SQL        SELECT p.*, s.*      FROM Properties p, Subdivisions s      WHERE s.subdivision_id = p.subdivision_id       AND p.property_is_active = YES      ORDER BY s.subdivision_name
DATASOURCE  tnwhiz_accesscf_finehomes
SQLSTATE
Resources:

Browser  Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2
Remote Address  68.52.169.45
Referrer  http://billfine.com/about.cfm
Date/Time  18-Sep-09 07:23 AM
Stack Trace
at cffind2ecfm161412284.runPage(D:\Hosting\tnwhiz\find.cfm:23)                                                                         

com.inzoom.adojni.ComException: Unspecified error in Microsoft JET Database Engine code=0 Type=1
     at com.inzoom.ado.Connection.jniOpen(Native Method)
     at com.inzoom.ado.Connection.open(Connection.java:40)
     at com.inzoom.jdbcado.Connection.doOpen(Connection.java:27)
     at com.inzoom.jdbcado.Connection.<init>(Connection.java:17)
     at com.inzoom.jdbcado.MSJetConnection.<init>(MSJetConnection.java:6)
     at com.inzoom.jdbcado.ConnectInit.connect(ConnectInit.java:171)
     at com.inzoom.jdbcado.Driver.connect(Driver.java:31)
     at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:562)
     at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67)
     at java.lang.Thread.run(Thread.java:534)
This topic has been closed for replies.

1 reply

A
Anonymous
September 18, 2009
23 : <cfquery name="GetProperties" datasource="#Datasource#">

Are you able to run any queries with this datasource? Have you gone into the ColdFusion Administrator 
and tried to test the "Datasource" connection? What are you using for your database? Access, MS SQL, MySQL?
B
bdixon12Author
Participant
September 18, 2009

I am not able to run any queries. I'm using shared GoDaddy hosting so I'm not able to access the Coldfusion Administrator. I am using an Access database.

A
Anonymous
September 18, 2009

Did you have this working before and now it's not, or are you just now trying to set it up?

I'm not familiar with what GoDaddy uses for an admin/datasource set up, do they have something where you can add your Access database and verify the connection is working? Maybe someone who uses GoDaddy can chime in as well.

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