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:234160 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
