You may need to supply a password with the query for it to authenicate to the SQL server.
Basically it stats that the user account you entered is invalid. ----- Original Message ----- From: "Julia Green" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, January 04, 2002 2:38 PM 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 > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
