ADO .NET and Excel ...

Hi

Frankly speaking, what ever one says, Microsoft technologies will always
remain problem-matic.. specially with versions... they don have seamless
integration. Deployment is always always an issue. But I still love .NET!!
Anyway folks, my problem goes like this...

I am reading and updating excel sheet using ADO .NET.

Everything is working fine on machine, but on server it is all messing up...

I connect to sheet using the string called...

Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel
8.0;HDR=YES;'

But whenver I try to execute insert command, following error occurs...

Operation must use an updateable query.Microsoft JET Database Engine at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at MyPledge.ClientPaymentData.Button1_Click(Object sender, EventArgs e) in
C:\Inetpub\wwwroot\Web1\Data.aspx.vb:line 74


I will highly appreciate if someone help me... !!!


eff_kay






-------------------
IMPORTANT: No trees were killed during the sending of this message but a
large number of electrons were terribly inconvienced.

Miha
Sun Dec 05 00:36:14 CST 2004

Nice of yout to frankly speak. :-)
Is this an aspnet application?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

"fahad" <fahad@discussions.microsoft.com> wrote in message
news:073958F7-897D-4950-A153-D9D745C8A8E3@microsoft.com...
> Hi
>
> Frankly speaking, what ever one says, Microsoft technologies will always
> remain problem-matic.. specially with versions... they don have seamless
> integration. Deployment is always always an issue. But I still love .NET!!
> Anyway folks, my problem goes like this...
>
> I am reading and updating excel sheet using ADO .NET.
>
> Everything is working fine on machine, but on server it is all messing
> up...
>
> I connect to sheet using the string called...
>
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended
> Properties='Excel
> 8.0;HDR=YES;'
>
> But whenver I try to execute insert command, following error occurs...
>
> Operation must use an updateable query.Microsoft JET Database Engine at
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
> at
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
> dbParams, Object& executeResult) at
> System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
> at
> System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
> Object& executeResult) at
> System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
> behavior, String method) at
> System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
> at MyPledge.ClientPaymentData.Button1_Click(Object sender, EventArgs e) in
> C:\Inetpub\wwwroot\Web1\Data.aspx.vb:line 74
>
>
> I will highly appreciate if someone help me... !!!
>
>
> eff_kay
>
>
>
>
>
>
> -------------------
> IMPORTANT: No trees were killed during the sending of this message but a
> large number of electrons were terribly inconvienced.

fahad
Sun Dec 05 07:59:02 CST 2004

yes, offcource...





"Miha Markic [MVP C#]" wrote:

> Nice of yout to frankly speak. :-)
> Is this an aspnet application?
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> SLODUG - Slovene Developer Users Group
> www.rthand.com
>
> "fahad" <fahad@discussions.microsoft.com> wrote in message
> news:073958F7-897D-4950-A153-D9D745C8A8E3@microsoft.com...
> > Hi
> >
> > Frankly speaking, what ever one says, Microsoft technologies will always
> > remain problem-matic.. specially with versions... they don have seamless
> > integration. Deployment is always always an issue. But I still love .NET!!
> > Anyway folks, my problem goes like this...
> >
> > I am reading and updating excel sheet using ADO .NET.
> >
> > Everything is working fine on machine, but on server it is all messing
> > up...
> >
> > I connect to sheet using the string called...
> >
> > Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended
> > Properties='Excel
> > 8.0;HDR=YES;'
> >
> > But whenver I try to execute insert command, following error occurs...
> >
> > Operation must use an updateable query.Microsoft JET Database Engine at
> > System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
> > at
> > System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
> > dbParams, Object& executeResult) at
> > System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
> > at
> > System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
> > Object& executeResult) at
> > System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
> > behavior, String method) at
> > System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
> > at MyPledge.ClientPaymentData.Button1_Click(Object sender, EventArgs e) in
> > C:\Inetpub\wwwroot\Web1\Data.aspx.vb:line 74
> >
> >
> > I will highly appreciate if someone help me... !!!
> >
> >
> > eff_kay
> >
> >
> >
> >
> >
> >
> > -------------------
> > IMPORTANT: No trees were killed during the sending of this message but a
> > large number of electrons were terribly inconvienced.
>
>
>

Miha
Sun Dec 05 08:46:36 CST 2004

Then, most probably, your aspnet local windows account (NETWORK SERVICE on
Windows 2003) has no NTFS privileges on mdb file and the folder where it
resides.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

"fahad" <fahad@discussions.microsoft.com> wrote in message
news:87C88BE1-194F-4A14-8DB5-C9D553217D06@microsoft.com...
> yes, offcource...
>
>
>
>
>
> "Miha Markic [MVP C#]" wrote:
>
>> Nice of yout to frankly speak. :-)
>> Is this an aspnet application?

Paul
Mon Dec 06 08:32:06 CST 2004

On Sun, 5 Dec 2004 15:46:36 +0100, "Miha Markic [MVP C#]" <miha at rthand com> wrote:

¤ Then, most probably, your aspnet local windows account (NETWORK SERVICE on
¤ Windows 2003) has no NTFS privileges on mdb file and the folder where it
¤ resides.

I think you meant "xls" and not "mdb".


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

xbmzaybx
Mon Dec 06 09:06:57 CST 2004

http://www.ardice.com/Computers/Programming/Databases/ADO/ADO.NET/

Miha
Mon Dec 06 11:06:16 CST 2004

Yes :-)
Thanks for correction - here is such a big amount of similar problems
(asp.net and access, but you know this already, do you) that those words
were imprinted into my fingers :-)

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:u9r8r0dlq8ko8d9gdv36jgfdqp8f3es5d9@4ax.com...
> On Sun, 5 Dec 2004 15:46:36 +0100, "Miha Markic [MVP C#]" <miha at rthand
> com> wrote:
>
> ¤ Then, most probably, your aspnet local windows account (NETWORK SERVICE
> on
> ¤ Windows 2003) has no NTFS privileges on mdb file and the folder where
> it
> ¤ resides.
>
> I think you meant "xls" and not "mdb".
>
>
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Paul
Tue Dec 07 09:00:14 CST 2004

On Mon, 6 Dec 2004 18:06:16 +0100, "Miha Markic [MVP C#]" <miha at rthand com> wrote:

¤ Yes :-)
¤ Thanks for correction - here is such a big amount of similar problems
¤ (asp.net and access, but you know this already, do you) that those words
¤ were imprinted into my fingers :-)

Yup. The error doesn't change under Jet regardless of which ISAM you are using.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Cor
Tue Dec 07 09:14:45 CST 2004

Paul,

In the dotnet general newsgroup is a typical question for you.

problem running net application from shared drive
It is about DAO

Maybe you can have a look,

Cor

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com>

> On Mon, 6 Dec 2004 18:06:16 +0100, "Miha Markic [MVP C#]" <miha at rthand
> com> wrote:
>
> ¤ Yes :-)
> ¤ Thanks for correction - here is such a big amount of similar problems
> ¤ (asp.net and access, but you know this already, do you) that those words
> ¤ were imprinted into my fingers :-)
>
> Yup. The error doesn't change under Jet regardless of which ISAM you are
> using.
>
>
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)