**snip** <CFQUERY NAME="gilwaya" DATASOURCE="jgrn123" USERNAME="jgrn123">
where's the password attribute? <CFQUERY NAME="gilwaya" DATASOURCE="jgrn123" USERNAME="jgrn123" PASSWORD="??????"> -----Original Message----- From: Julia Green [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 2:39 PM To: CF-Talk Subject: Dave or someone -- Help me with error msg!!! I just started a $90 a month ISP account with ColdFusion and a database. Help confirmed that I actually got my tables over, and that the error is on my side. This is the error I get and beneath it is the code: (Don't laugh -- I have done ColdFusion at UPS for two years...) Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 28000 (Invalid authorization specification) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'jgrn123'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (2:1) to (2:64). Date/Time: 01/04/02 14:28:08 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) Remote Address: 24.128.190.210 This is my coldfusion code: <CFQUERY NAME="gilwaya" DATASOURCE="jgrn123" USERNAME="jgrn123"> SELECT * FROM ultra </CFQUERY> <html> <head></head> <body> <cfoutput query="gilwaya"> <br> <BR> <FONT SIZE="-1"> #Name# </FONT> <BR> </cfoutput> </body> </html> Thanks Julia Green, Julia Computer Consulting Email: [EMAIL PROTECTED] --- Dave Watts <[EMAIL PROTECTED]> wrote: > > I was looking through the list archives at recommedations > > for protecting images - ie, not allowing images files to > > be called directly from the browser. The main recommendations > > seem to involve CFCONTENT. The site I will be working on > > will require this, and will also potentially be quite high > > traffic. I was wondering how well cfcontent works under load > > in situations like this. > > It's going to run every request through CF, which is going to > significantly > increase the amount of work CF has to do. The same issue comes up > with > regular HTML pages - if you want to force authorization using CF, you > might > map .html to be processed by CF, but there's a serious performance > penalty. > > You can address this by either finding an alternative that doesn't > require > runtime processing (with CF or any other CGI tool), or by ensuring > that your > CF servers can handle the load by getting more and/or bigger ones. > > > Also, the other recommendation was to get the web server to handle > > this. I will be on IIS5 on Win2K, on shared hosting, but my host is > > > usually quite accomodating when it comes to setting things up for > me. > > How would you restrict calling images through IIS? Does it involve > > setting the image file types to be handled by the CF server, so > > Application.cfm is called before each? Is this better (in terms of > > performance) than using CFCONTENT for the same purpose? > > To the best of my knowledge, the only way to get IIS to handle this > for you > is to set the appropriate permissions on each image file, and have > IIS force > authentication against requests for those files. There's very little > overhead in that, but it would require that you have a Windows > account for > the user to use, and it wouldn't directly integrate with your > application, > in the sense that the user would get a browser authentication popup > window. > > You might be able to do something better by writing an ISAPI > extension (or > looking for an existing ISAPI extension) which checks for the > existence of > some token (a cookie or URL variable, for example) before allowing > the > request to be processed. I haven't written any ISAPI extensions > myself, and > suspect it's a bit more complicated than most CF programming, but I'd > guess > that it would perform better for this specific task. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
