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