I found out from the ISP that there is not table LC_Feature on this database that was sent.
So I will have to wait for the other hosting company to send me a valid backup. Thank you all for your help Jim Louis > Its the database. Now I Figured out what was wrong. > > New Query New Error. > > <cfquery name="qryActiveFeatures" datasource="#request.lcDatasource#" > username="#request.Username#" password="#request.Password#"> > SELECT LC_FEATURE_PATH FROM LC_FEATURE WHERE IS_ACTIVE = 1 AND > AVAILABLE = 1 > </cfquery> > > New Error > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name > 'LC_FEATURE'. > > I do not have access to the MS SQL Database remotely yet. Downloading > the program, but I have contacted the ISP to see if they can see if > there is a table called LC_Feature. The Database was restored from a > backup, which I think is not complete. > > Jim Louis > > > > What is 'LC_KCALA'? I don't see that in your code. Is it one of > the > > variables you're using (un/pw)? > > > > > -----Original Message----- > > > From: Jim Louis [mailto:[EMAIL PROTECTED] > > > Sent: Friday, March 03, 2006 3:14 PM > > > To: CF-Talk > > > Subject: Re: MS SQL and querying it > > > > > > I just found out it is Coded into coldfusion MX so I moved it > > > over to MX and removed the provider and stuff so the query is > > > > > > <cfquery name="qryActiveFeatures" > > > datasource="#request.lcDatasource#" > > > username="#request.Username#" > > > password="#request.Password#" > > > dbtype="OLEDB"> > > > SELECT LC_FEATURE_PATH FROM LC_FEATURE WHERE IS_ACTIVE > > > = 1 AND AVAILABLE = 1 > > > </cfquery> > > > > > > > > > I get this error, > > > > > > Error Executing Database Query. > > > ERROR: Could not locate LC_KCALA. This usually means that the > > > jrun-resources file does not contain configuration data for > > > this database or pool > > > > > > The MS SQL is on server 10.0.0.1 (yes Fake IP) how do I put > > > it in there to tell it to go to 10.0.0.1. > > > > > > [INFO] -- Access Manager: > > This transmission may contain information that is privileged, > > confidential and/or exempt from disclosure under applicable law. If > > > you are not the intended recipient, you are hereby notified that any > > > disclosure, copying, distribution, or use of the information > contained > > herein (including any reliance thereon) is STRICTLY PROHIBITED. If > you > > received this transmission in error, please immediately contact the > > > sender and destroy the material in its entirety, whether in > electronic > > or hard copy format. Thank you. A2 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234165 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
