ot: sql server error, help!

2002-10-02 Thread Tony Weeg 

The job failed.  Unable to determine if the owner
(NAVTRAK525\Administrator) of job SystemStatusCheck1 has server access
(reason: The server could not load DCOM. [SQLSTATE 42000] (Error 7404)).

this is what I am getting, when we try to run a job that has ran fine
for 6 months.  all of a sudden this morning I am getting this error.

Navtrak525\Administrator has full permissions as DBO\Server Admin\etc.
etc. etc.

does anyone have a clue why I would be getting this one?

thanks.

ps. If I run it under SA, I get no issues, and it runs fine.

..tony

Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

OT: SQL Server error.

2000-10-04 Thread Ric Smith 

I just started getting this error in one of my SQLServer 6.5 db's.
I don't know what could be causing it. The primarykey/identity
column is named FolderID. Why would it be trying to insert a
duplicate if it's an autonumber?

ODBC Error Code = 23000 (Integrity constraint violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY
constraint 'PK__Folders__FolderI__198AD3B0': Attempt to insert duplicate key
in object 'Folders'.

SQL = "INSERT INTO Folders ( ParentID, Name, Description,
ateAdded )VALUES( 7, 'test', 'test', {ts '2000-10-04 12:27:18'} );"

Thanks.

Ric Smith


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.