Hi

i use this code to retrieve my image field from sql server
(my file isn't picture !!!)

***********
            Dim MyData() As Byte
            MyData = Ds.Tables(mytable).Rows(0).Item(myfield) 'For Example
            Dim K As Long
            K = UBound(MyData)

            Dim fs As New FileStream("c:\mkh.xml", FileMode.OpenOrCreate, FileAccess.Write) 'in this line get error
            fs.Write(MyData, 0, K)
            fs.Close()

            fs = Nothing
            Ds = Nothing
************
but it doesn't work and give me this error in ASP.Net(With Vb)
<<Access to the path "C:\mkh.xml" is denied.>>

i get this code from microsoft msdn and alot of furoms !!!!
then why doesn't work??

____________________________
MkhProgrammer

hi,

Please go to the file mkh.xml and right click on it. Check its security settings. Give access permissions to the user SYSTEM.

I hope this will assist you

regards


____________________________
MacD

Have you checked that you are logged in as a user with write permissions for "C:" or that SQLServer account has such permissions.?
OOOPs - Mac beat me to the post


[Edited by GeoffS on 21-10-2004 at 10:09 AM GMT]

____________________________
multi-tasking - the ability to hang more than one app. at the same time.