Dave, I do not know if your question was answered or not. What version of CFAS are you using? MS SQL Server is only supported on CF Pro and CF ENT. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -----Original Message----- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 7:31 PM To: CF-Talk Subject: RE: SQL2000 server not recognized by CF 4.5 - continued... Hello everyone, i sent an email two days ago about not being able to get CF and SQL2000 to talk to each other. i followed the instructions everyone sent me including installing the latest MDAC and still, i couldn't get them to talk to each other. i did finally get them to talk by checking the "use trusted connection" checkbox, but someone at work told me that i hadn't fixed any problem, i'd just gone around it. of course, i really don't know what he means by that at all. As you might have guessed, i'm new to server admin. Also, i can't even get an access DB to be recognized. CF just tells me the datasource cannot be verified. i've added it in my ODBC panel under SystemDSN, but the problem persists with getting CF to talk to databases. if anyone can shed any light onto this problem i would greatly appreciate it. thanks in advance. d -----Original Message----- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 12:25 PM To: CF-Talk Subject: Re: SQL2000 server not recognized by CF 4.5 On 4/23/01 1:52 PM David Baskin wrote: > I'm hoping someone can help with a problem i cannot figure out. i have a new > box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend > without problems, but now i cannot get SQL and CF to play together. i try to > set up the ODBC and my connection fails every time. the base SQL server that > shows up as default on the ODBC admin does not connect, nor does the one > that i create. not sure how to trouble shoot this problem at all. any help > is greatly appreciated. Have you reinstalled the MDAC since installing CF 4.5? If not, pop the windows 2K CD in and run the upgrade and this will fix the MDAC that gets broken when you install CF 4.5. - Sean ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
