I'm using it with no problems at all. My blog and a couple clients run on sql 2005.
Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 24, 2006 8:28 PM To: [email protected] Subject: [Reactor for CF] Reactor & SQL Server 2005 Anyone else have this problem. I haven't been able to get Reactor to work with MS SQL Server 2005 at all. If I do read, everything is fine. Once I try to write to the database, everything fails. I've isolated the problem to Reactor trying to get metadata from SQL Server 2005. According to MS, that information is previleged, and only users with "VIEW DEFINITION" can access that info. Anyways, what happens is that for identities, MS will return null if you dont have access, which reactor thinks is not an identity. And when writing, tries to insert an PK/identity even though you cant and fails. I've copied the script that Reactor over to SSMS and tried runnign it with full 'sa' permissions and still get NULL returned. It seems SQL 2005 is a bit too secure... it tells me what is a PK but wont tell me if its an identity! Has anyone run Reactor with 2005? What is the basic setup/instructions needed. I've tried on Enterprise and Developer editions. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
