Error Occurred While Processing Request 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

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.
 
The error occurred in \\itchynscratchy\websites-templates\public-websites\www.igluvillas.com\CFC\properties.cfc: line 99
 
97 : 						<cfelse>
98 : 							ORDER BY #arguments.sortOrder# 
99 : 					</cfif>
100 : 	</cfquery>
101 :
SQL    SELECT DISTINCT (va.propertyid) AS propertyID, p.name AS pname, v.name AS vname, c.name AS cname, r.name AS rname ,MIN(va.minprice) AS price, MAX(maxprice) AS maxprice, MIN(va.sleeps) AS sleeps, va.sortOrder, p.mainpictureroot, p.mainpicture, pc.includestravel, pc.includesflights, pc.includesferry, pc.includeseurotunnel, pc.includescarhire, pc.accommonly, va.regioncode, va.countrycode, MAX(va.lastmodified) AS lastModified, va.regioncode as rcode , min(va.unitid) as unitid FROM avail_write.prod_villasAvail_2 va, avail_write.property p, avail_write.village v, avail_write.region r, avail_write.country c, avail_write.pricecode pc ,igluvillasnewDB..propertyfeature pf WHERE 0 = 0 AND va.propertyID = p.propertyID AND p.villageID = v.villageID AND v.regionCode = r.regionCode AND r.countryCode = c.countryCode AND va.pricecode = pc.pricecode AND va.regioncode not in ( 'PO', 'LB', 'BU', 'DO', 'LO', 'MI', 'TT', 'TK', 'TS', 'UM', '') AND p.publish = 1 AND va.propertyid = pf.propertyid AND pf.featurecode in ( 'BNB', '') GROUP BY va.propertyid, p.name, v.name, r.name, c.name, va.sortOrder, p.mainpictureroot, p.mainpicture, pc.includestravel, pc.includesflights, pc.includesferry, pc.includeseurotunnel, pc.includescarhire, pc.accommonly, va.regioncode, va.countrycode ORDER BY va.sortorder ASC
DATASOURCE   villasAvailability
SQLSTATE   08001
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.107.191.83
Referrer  
Date/Time   10-Mar-10 10:48 PM
Stack Trace
at cfproperties2ecfc1429878710$funcGETPROPS.runFunction(\\itchynscratchy\websites-templates\public-websites\www.igluvillas.com\CFC\properties.cfc:99) at cfbeach_villas2ecfm1288420269.runPage(\\itchynscratchy\websites-templates\public-websites\www.igluvillas.com\beach_villas.cfm:43) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.
	at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
	at macromedia.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
	at macromedia.jdbc.base.BaseConnection.open(Unknown Source)
	at macromedia.jdbc.base.BaseDriver.connect(Unknown Source)
	at macromedia.jdbc.MacromediaDriver.connect(Unknown Source)
	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)