Platform: VC 7.0, NT4.0
 Database: SQL Server 2000
 Hi,
 I created an in-proc server. It uses registry related function like
 RegOpenKeyEx.
 When I execute this COM object from Visual Basic it works fine.
 When I execute same COM object from SQL Server Store procedure it files and
 returns error like "Cannot create a file when that file already exists". May
 I know why same code fails in case of SQL Server?
 Thanks in advance.
 Regards
 VijayHi
CREATE FUNCTION dbo.fn_file_exists(@.filename VARCHAR(300))
 RETURNS INT
AS
BEGIN
 DECLARE @.file_exists AS INT
 EXEC master..xp_fileexist @.filename, @.file_exists OUTPUT
 RETURN @.file_exists
END
GO
-- test
SELECT dbo.fn_file_exists('d:\test1.txt')
"vijay" <vijaysingh@.abo.abosoftware.com> wrote in message
news:ujQzO7VxDHA.1856@.TK2MSFTNGP09.phx.gbl...
> Platform: VC 7.0, NT4.0
> Database: SQL Server 2000
>
> Hi,
> I created an in-proc server. It uses registry related function like
> RegOpenKeyEx.
> When I execute this COM object from Visual Basic it works fine.
> When I execute same COM object from SQL Server Store procedure it files
and
> returns error like "Cannot create a file when that file already exists".
May
> I know why same code fails in case of SQL Server?
>
> Thanks in advance.
>
> Regards
> Vijay
>
Thursday, March 8, 2012
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment