just to throw this out there, have you compared the Windows permissions on this DB vs. the ones that work?
On Thu, Sep 30, 2010 at 1:52 PM, <> wrote: > > >>u have CF 5/6/7/8/9 installed. > > On my development desktop yes, but not on my production server on which I'm > having the problems. > > >>as your setup seems to change from 1 post to the next. > > No, nothing was changed either on my desktop, nor on my server. > I installed CF9 on my server August 25, and did not change anything ever > since, except for trying to define new datasources. > When I installed it, I was able to redefine all DSNs which were already there > for CF 5, no problem. > But now the problem is for new DSN. > Even if I define it first in CF 5 and then in CF 9, I still get the same > error. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

