Upload if files from client PC or local network

[Siobhan]

Hi - I create a input box as follows:
<INPUT id="inpJobDescE mpSpec" style="BORDER-RIGHT: gray thin solid;
BORDER-TOP: gray thin solid; Z-INDEX: 181; LEFT: 232px; BORDER-LEFT: gray
thin solid; WIDTH: 640px; BORDER-BOTTOM: gray thin solid; POSITION: absolute;
TOP: 400px; HEIGHT: 22px" tabIndex="27" type="file" maxLength="250" size="87"
name="inpJobDes cEmpSpec" RunAt="Server">

to allow the user to select a file which I want saved to a SQL Server
database.

On the save I then run this code to insert the document into the database:

'only try and attach file if there is one specified
Dim impersonationCo ntext As
System.Security .Principal.Wind owsImpersonatio nContext
Dim currentWindowsI dentity As
System.Security .Principal.Wind owsIdentity

currentWindowsI dentity = CType(User.Iden tity,
System.Security .Principal.Wind owsIdentity)
impersonationCo ntext = currentWindowsI dentity.Imperso nate()

'Insert your code that runs under the security context of
the authenticating user here.
If Len(Trim(inpJob DescEmpSpec.Val ue)) <> 0 Then
Dim fs As New System.IO.FileS tream _
(inpJobDescEmpS pec.Value,
System.IO.FileM ode.OpenOrCreat e, _
System.IO.FileA ccess.Read)
Dim MyData(fs.Lengt h) As Byte
fs.Read(MyData, 0, fs.Length)
fs.Close()
.JobDescEmpSpec Doc = MyData
.UpdateDocument = True
Else
Dim MyData(0) As Byte
.JobDescEmpSpec Doc = MyData
.UpdateDocument = False
End If
impersonationCo ntext.Undo()

(where I am setting MyData to a byte property of my data class)

This works perfectly fine in the development environment (my PC has Visual
Studio and is the web server connectin to a SQL server database on out
network.

I can browse for and attach files with or network paths (C:\Folder\File .doc
or \\Server\Share\ Folder\File.doc )

If I connect to the website on my PC from another PC the local drive upload
works fine (C:\Folder\File .doc) but the network upload fails because
somewhere along the way the backslashes are beibng removed so it is trying to
access file \ServerShareFol derFile.doc

Anyone any idea why this is?

Thanks in advance
Siobhan

[intrader]

On Tue, 01 Nov 2005 06:57:03 -0800, Siobhan wrote:

Hi - I create a input box as follows:
<INPUT id="inpJobDescE mpSpec" style="BORDER-RIGHT: gray thin solid;
BORDER-TOP: gray thin solid; Z-INDEX: 181; LEFT: 232px; BORDER-LEFT: gray
thin solid; WIDTH: 640px; BORDER-BOTTOM: gray thin solid; POSITION: absolute;
TOP: 400px; HEIGHT: 22px" tabIndex="27" type="file" maxLength="250" size="87"
name="inpJobDes cEmpSpec" RunAt="Server">

to allow the user to select a file which I want saved to a SQL Server
database.

On the save I then run this code to insert the document into the database:

'only try and attach file if there is one specified
Dim impersonationCo ntext As
System.Security .Principal.Wind owsImpersonatio nContext
Dim currentWindowsI dentity As
System.Security .Principal.Wind owsIdentity

currentWindowsI dentity = CType(User.Iden tity,
System.Security .Principal.Wind owsIdentity)
impersonationCo ntext = currentWindowsI dentity.Imperso nate()

'Insert your code that runs under the security context of
the authenticating user here.
If Len(Trim(inpJob DescEmpSpec.Val ue)) <> 0 Then
Dim fs As New System.IO.FileS tream _
(inpJobDescEmpS pec.Value,
System.IO.FileM ode.OpenOrCreat e, _
System.IO.FileA ccess.Read)
Dim MyData(fs.Lengt h) As Byte
fs.Read(MyData, 0, fs.Length)
fs.Close()
.JobDescEmpSpec Doc = MyData
.UpdateDocument = True
Else
Dim MyData(0) As Byte
.JobDescEmpSpec Doc = MyData
.UpdateDocument = False
End If
impersonationCo ntext.Undo()

(where I am setting MyData to a byte property of my data class)

This works perfectly fine in the development environment (my PC has Visual
Studio and is the web server connectin to a SQL server database on out
network.

I can browse for and attach files with or network paths (C:\Folder\File .doc
or \\Server\Share\ Folder\File.doc )

If I connect to the website on my PC from another PC the local drive upload
works fine (C:\Folder\File .doc) but the network upload fails because
somewhere along the way the backslashes are beibng removed so it is trying to
access file \ServerShareFol derFile.doc

Anyone any idea why this is?

Thanks in advance
Siobhan

The problem is that inside strings, the backslash is considered an escape
to allow special characters. So you may use double slashes.

[Bruce Barker]

the problem is credentials forwarding. by default (and with ntlm impossible)
its not allowed to forward user credentials from a second machine to a third
(1 hop rule).

when you are on your local box, iis and asp.net has a primatuy token and can
talk to network resouces on other machines. if you connect to your pc from
another, then iis and asp.net no longer have a primary token can can not use
the token to talk to another resource.

if you switch to kerberos and enable forwarding you will able to do what you
want.

http://support.microsoft.com/default...b;en-us;810572

-- bruce (sqlwork.com)


"Siobhan" <Si*****@discus sions.microsoft .com> wrote in message
news:81******** *************** ***********@mic rosoft.com...

Hi - I create a input box as follows:
<INPUT id="inpJobDescE mpSpec" style="BORDER-RIGHT: gray thin solid;
BORDER-TOP: gray thin solid; Z-INDEX: 181; LEFT: 232px; BORDER-LEFT: gray
thin solid; WIDTH: 640px; BORDER-BOTTOM: gray thin solid; POSITION:
absolute;
TOP: 400px; HEIGHT: 22px" tabIndex="27" type="file" maxLength="250"
size="87"
name="inpJobDes cEmpSpec" RunAt="Server">

to allow the user to select a file which I want saved to a SQL Server
database.

On the save I then run this code to insert the document into the database:

'only try and attach file if there is one specified
Dim impersonationCo ntext As
System.Security .Principal.Wind owsImpersonatio nContext
Dim currentWindowsI dentity As
System.Security .Principal.Wind owsIdentity

currentWindowsI dentity = CType(User.Iden tity,
System.Security .Principal.Wind owsIdentity)
impersonationCo ntext = currentWindowsI dentity.Imperso nate()

'Insert your code that runs under the security context of
the authenticating user here.
If Len(Trim(inpJob DescEmpSpec.Val ue)) <> 0 Then
Dim fs As New System.IO.FileS tream _
(inpJobDescEmpS pec.Value,
System.IO.FileM ode.OpenOrCreat e, _
System.IO.FileA ccess.Read)
Dim MyData(fs.Lengt h) As Byte
fs.Read(MyData, 0, fs.Length)
fs.Close()
.JobDescEmpSpec Doc = MyData
.UpdateDocument = True
Else
Dim MyData(0) As Byte
.JobDescEmpSpec Doc = MyData
.UpdateDocument = False
End If
impersonationCo ntext.Undo()

(where I am setting MyData to a byte property of my data class)

This works perfectly fine in the development environment (my PC has Visual
Studio and is the web server connectin to a SQL server database on out
network.

I can browse for and attach files with or network paths
(C:\Folder\File .doc
or \\Server\Share\ Folder\File.doc )

If I connect to the website on my PC from another PC the local drive
upload
works fine (C:\Folder\File .doc) but the network upload fails because
somewhere along the way the backslashes are beibng removed so it is trying
to
access file \ServerShareFol derFile.doc

Anyone any idea why this is?

Thanks in advance
Siobhan