Turns out the Sysadmin moved the database to a different ip address. Didn't tell me yet. He assures me he was GOING to! So I was accessing the old database with my Query Analyser, fixing problems, setting up tables etc, but I wasn't making any changes on the database that ColdFusion was accessing. So no matter what I did, thinking I was fixing the problem, I did nothing of the kind. No wonder everything I did made no difference. I'd set up the table in this example with a teensy error in it, and just at that moment the Sysadmin moved the ip addresses to the new location. So I couldn't correct the error, even though I thought I was.
Thanks everyone for the helpful suggestions, but I bet none of you had anything close to that in mind! Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -----Original Message----- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 31, 2002 11:39 PM To: CF-Talk Subject: RE: CF Can't insertinto SQL2K ... any ideas? On 3/31/02, Mike Kear penned: >Yes, and it doesn't show anything but the error message. And the memberID >is an identity field. The SQL2K equivalent of Access's autonumber field. If >you try to enter anything in there yourself it barfs on you. > >The SQL inside the <CFQUERY tag works fine when sent using Query Analyser. >So the SQL itself is ok. I'd gladly look at the debug info but the page >doesn't show any. Doesn't show anything but the error message. That is strange. From before: >IS this the problem?? > >I'm thinking the problem is the SERVER doesn't have permissions to insert >into the database - it needs to be set up as database owner and hasn't been. >Which means I have to focus the SysAdmin's eye on it and that's not easy at >Easter time. IS there anything else I should look for? Something I might >have overlooked? I would think that if you can insert anything through query analyzer then you must have owner or datareader/datawriter permissions. Just for the heck of it, maybe you could try making the memberID field a regular integer field and trying an insert with a value for the memberID hard coded in the cfquery. Also, I know this is probably a stupid question, but since it IS an identity field, you aren't including that field in your insert statement, are you? If you want to email me off list with the username, password database name and IP Address of the SQL Server, along with the query with some hard coded values, I can try it from here to see if it works. -- Bud Schneehagen - Tropical Web Creations ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
