Re: can a .NET app get access to a shared doc in SPS?

From: Nick Malik (nickmalik_at_hotmail.nospam.com)
Date: 09/09/04 

Date: Thu, 09 Sep 2004 10:45:52 GMT

A shared document in WSS is available by clicking a link. The link contains
the URL of the document. I'm not sure why this would be difficult to do.

I would suggest that you provide an ASP.NET app that allows the user to look
up their record in Oracle. When they find it, they upload a document to the
asp.net site which will catch the upload, open WSS, and store the document
using the primary key from Oracle into a document library in Sharepoint
(e.g. the user isn't aware that they are using sharepoint at all). Since
your ASP.NET app would impersonate a domain account that has write access to
that document library, WSS would allow the user to upload the document via
the ASP.NET app, but not directly.

Then, when your app shows data from Oracle, provide the link directly to the
Sharepoint library using the primary key value from Oracle.

Note: you may want to put in code to check to make sure that a document
exists for the particular user before showing the link. Easy enough. See
the SPFile object.

Does this help?

--- Nick

"Jason Shohet" <__ash477@yahoo.com> wrote in message
news:ezDGL9bkEHA.3632@TK2MSFTNGP09.phx.gbl...
> 1. Lets say a user uploads a shared document, MJohnson.pdf in
Sharepoint.
> 2. Then the user goes into an external ASP.NET app (or perhaps a SP web
> part)
>
> 3. This app could *somehow* allow the user to associate MJohnson.pdf
with
> the record for the employee "Mike Johnson" -- which is in an external
Oracle
> database, not part of Sharepoint.
>
> 4. A user using that ASP.NET app could then bring up Mike Johnson's
detail
> info from Oracle
> 5. The user will see a link that when clicked, opens MJohnson.pdf!
(stored
> in Sharepoint)
>
> IOTW, can Sharepoint be used for document management somehow, and
integrate
> with another enterprise application in this manner? I'm trying to avoid
> doing the old "have web application hit a db field which contains the
> location of a file on the server". I'm looking for a way to leverage
> sharepoint here, and I'm probably not using Sharepoint in the way it was
> intended... Thanks for any insights
>
> Jason Shohet
>
>

Relevant Pages

  • Re: can a .NET app get access to a shared doc in SPS?
    ... But Sharepoint is storing it in its ... >> I would suggest that you provide an ASP.NET app that allows the user to ... they upload a document to ... >> using the primary key from Oracle into a document library in Sharepoint ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: onetutil.dll unable to connect to the configuration database
    ... account as the WSS Admin App Pool account. ... Sharepoint Central Admin stie. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Deploying Asp.net 2.0 web app on WSS 3.0
    ... for instance) in the sharepoint server. ... Can anybody help me out how should i delpoy Asp.net 2.0 web app on WSS ... Actually im a fresh to start sharepoint. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How to access an ASP.NET from Sharepoint Services
    ... application is NOT affected by WSS. ... The box runs Sharepoint Intranet, Server SQL, and the ASP.NET ... the app virtual directory is ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: WSS FAQ additions and changes - 19th - 25th June 2006
    ... Does the cSmartLaunch webpart work with WSS or SPS/WSS? ... Thanks for a great informative Sharepoint website wss.collution. ... Sneak Preview of the 2007 Microsoft Office System ... Windows SharePoint Services 3.0 Beta 2 Pack for Microsoft Operations Manager ...
    (microsoft.public.sharepoint.windowsservices)