I haven't used SQL7 in awhile, but one thing you might try, if you have the
option, is running ColdFusion under a local administrator account, rather
than as Local System. This might solve that problem.
Bob
-----Original Message-----
From: David Sterling [mailto:[EMAIL PROTECTED]]
Sent: May 10, 2001 7:18 PM
To: CF-Talk
Subject: RE: Running DTS in Stored rocedure
Im running SQL 7.0 on an NT4.....
-----Original Message-----
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 3:53 PM
To: CF-Talk
Subject: RE: Running DTS in Stored rocedure
What version of SQL server are you running? I just had to set something
like this up on SQL2000, and there are a few pointers I can give you. Also,
which password are you referring to? The user login password, the package
password, etc?
Thanks,
Bob
-----Original Message-----
From: David Sterling [mailto:[EMAIL PROTECTED]]
Sent: May 10, 2001 3:18 PM
To: CF-Talk
Subject: Running DTS in Stored rocedure
I am having problems running a DTS package from a stored procedure...
Here is my code:
********************************************************
CREATE PROCEDURE [run_TestDTS]
AS
Exec MASTER..xp_CmdShell 'dtsrun /sql01/testun/testpass/testDTS'
********************************************************
I keep getting this error..
********************************************************
ODBC Error Code = 01000 (General warning)
[Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.c: Error 997 from
GetPassword on line 465
The error occurred while processing an element with a general identifier of
(CFSTOREDPROC), occupying document position (23:5) to (23:64).
********************************************************
I have changed the password, from the owner password, to the user password,
to my login password for SQL..
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists