Permission Error Maybe??

[Elliott3]

Hi,
I am not very familiar with the following code that is in an ASP site I am working on... when the folloing code is executed:

CREATE VIEW #Clinical_Trial_Listings AS SELECT DocTitle, Directory, vpath, filename, size, write, characterization, rank, CompanyType FROM SCOPE (' SHALLOW TRAVERSAL OF "/patient/studies" ')

It gives the this error
error '80070005'

The site has been moved from an NT OS to Windows 2003 Standard edition... it appears as though the error is to do with permissions but I have been unsuccessful finding out where exactly.
I have added the IUSR_[computer_name] and IWAM_[computer_name] as users under the root folder on the security tab and given full access.

Maybe I am looking in the wrong direction... can anyone point in the right direction? Could it be something to do with the above statement? It does work on the NT box and the code has not been changed.

CES

 

[donutman]

I recently took my OS from 2000 Server to 2003 Server. It broke several ODBC related things with my SQL Server. I found posts about the problem on the web, but no solutions. I reverted back to 2000 Server and everything is kewl.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[Elliott3]

Does anyone know what the '#' number sign before Clinical_trial_.... means?

CES

 

[SQLSister]

#sign is usually used to create a local temp table. I have never seen anyone use it in a view before.

Questions about posting. See faq183-874

 

[vongrunt]

Me too... this comes from books offline:

"You cannot create temporary views, and you cannot create views on temporary tables."

On the other hand, this isn't query over SQL data - SCOPE/TRAVERSAL are used for file content searches (Indexing Service).

 

[Elliott3]

Thats what it told me when I ran the query directly on the server...
'Views or functions are not allowed on temporary tables. Table names that begin with '#' denote temporary tables.'

I beleive the connection looks ok... has there been many changes to version 8 from I believe it was version 7?

Any ideas?

CES

 

[Elliott3]

Ok so I can run this simple create view:

CREATE VIEW viewName AS SELECT * FROM tblName

It will run ok directly on the server but not through my asp?? I still get the error 80070005... Could I have missed some permissions that need to be set somewhere?

CES

 

[vongrunt]

80070005 - smells like insufficient NTFS permissions on some DLL files (Server.CreateObject error?), not web folders.

 

[Elliott3]

It doesn't seem to fail on the create.. it fails on the execute... are u suggestion unregistered dlls? can you elaborate at all?

CES

 

[Elliott3]

Does it give any more clues if the statement:

SET PROPERTYNAME 'd1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1' PROPID 'CompanyType' AS CompanyType

executes ok right before the statement of this discussion fails to execute??

CES

 

[vongrunt]

Got a bit confused here... what kind of SQL statement is that?

About ASP/Win2003 errors:

http://www.aspfaq.com/show.asp?id=2476

 

[Elliott3]

An SQL statement that is a pain!! I am working wiith someone elses uncommented code...

Thanks for the faq... unfortunately I have seen this before... However the object does get created... this is how it is created:

Server.CreateObject("ADODB.Command")

let me know if you have any more thoughts... im pretty confused here..