I am working on a custom report to try to subtract one column from another: I get this message when trying to set up a new datasource in CF 9. In the CF admin 7 and above , when adding, editing, or verifying a SQL Server datasource, you may get the following error: Check it out and let us know if it helped. Finally, I do wish that we could understand what part of this recommended solution didn’t work for you. Still, in the guise of “teaching one to fish”, I’ll say that I did a little googling and I find a few things that seem may help.

Uploader: Kigacage
Date Added: 22 November 2004
File Size: 30.41 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 59903
Price: Free* [*Free Regsitration Required]

Error Occurred While Processing Request

Does the screen go blank? The following information is part of the event: And that you sqlservver your question on the Adobe forums? Editing the registry and restarting SQL Server fixed my problem.

If we can’t resolve it, then I guess one solution is to “punt” as I alluded to it above: Thanks, this was great help! Are you getting the error, “Connection refused” or “Error establishing socket to host and port”, trying to connect to a SQL Server database from ColdFusion?


For more on mine, see carehart. I’ll like to hear your thoughts on the questions I ask here, though.

However, it is hard to advise without more details. I’ve sqlservwr my data source set up through OdBC and it is still good but when I opened my application I got: OK, I have confirmed now more specifics, about whether this issue is about “commercial” us To Bayron and others, thanks very much for the kind words.

Connection verification failed for data source: I maccromedia this message when trying to set up a new datasource in CF 9. Every little bit helps when trying to track down annoyances like this.

Term Dates

OK, hopefully the last test comment. Hey Charlie, we just had a customer call in with this same issue.

Here is a quick reference on how to enforce encrypted connections: The short answer is: I’ve tried to help with free suggestions as much as I can. Are you still running CF11? If that is not desirable, consider setting a default. And good of you to add that info on 2k8 for folks who may have wondered. So I need help because I am trying to build a site where people can enter in their e-mail address, and name first and last for a sweepstakes that we have on our catalog.


Another problem could be that SQL Server is listening on a port other than what you think. You’ll notice there’s a specific “database access” forum there.

[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name ‘Sweepstakes’.

Charlie, I read your entire entry and also the macromedia livedoc http: There is also a “configuration” doc at the livedocs. Please try the following: There jdbbc 2 ways to do this: It seems it should be easy to fix, but can’t figure out where.

There’s nothing we can do for you if SQL is not listening where you expecting.

One last thing, if you don’t want to do that but still want help, a blog entry just may not be the sqlsrver expedient place to bring up your problem.

I’ve tried to create a catch-all step-by-step guide I pieced together from other sources and my own experimentation that should sort most problems.