AxOWC11 in OWC11-web-application?!

[Rouven Hertenstein]

Hi,

I've created a webservice and the adapted OWC11-windows-application based on
article http://support.microsoft.com/default.aspx?scid=kb;en-us;315695

It works really fine - incredible ;-)

Now, I want to exercise it in the same way as a vb.net web-application. The
problem is to referencing to AxOWC11. So, it's impossible to access
AxDataSourceControl1, AxPivotTable1 and so on.

It seems that the web-application isn't able to work with the windows forms.
Though I've set a reference to System.Windows.Forms.dll

Error in reasoning? Bad beginning? Wrong way? Or just a newbie?!

Thanks for helping me!
Rouven

 

[Alvin Bruney [MVP - ASP.NET]]

I'm not really sure i understand what you are saying. Are you wanting to
build a windows owc based app that reads a web based owc app?

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

 

[Rouven Hertenstein]

Sorry for my bad description.

I only want to connect an OWC-web-application with my web service ;-)
I excuted the sample with the windows-application just for comparison. just
for a thread.

Now, I dont't know how to address the AxPivotTable, AxChartSpace,
AxDataSourceControl etc. because I can't import or reference to AxOWC11 in a
web-application. But it's strangely possible to do that in a
windows-application (for comparison only).

It's obscure for me, because I thought, that I can build an
owc-web-application in the same way like a owc-windows-application. It seems
not to be so.

I hope, I described my problem clearer?!

I'm not really sure i understand what you are saying. Are you wanting to
build a windows owc based app that reads a web based owc app?

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Hi,

I've created a webservice and the adapted OWC11-windows-application based
on
article http://support.microsoft.com/default.aspx?scid=kb;en-us;315695

It works really fine - incredible ;-)

Now, I want to exercise it in the same way as a vb.net web-application.
The
problem is to referencing to AxOWC11. So, it's impossible to access
AxDataSourceControl1, AxPivotTable1 and so on.

It seems that the web-application isn't able to work with the windows
forms.
Though I've set a reference to System.Windows.Forms.dll

Error in reasoning? Bad beginning? Wrong way? Or just a newbie?!

Thanks for helping me!
Rouven

 

[Alvin Bruney [MVP - ASP.NET]]

first, you need to embed the owc object in the page. Once it is embedded,
your webservice would need to be modified to retrieve comma delimited data.
Then you can use the webservice behavior or xml-http to retrieve data from
the webservice. I have a full example implemented in the black book, but
basically the process would be roughly equivalent to:

-create xml-http instance
var obj = server.createinstance("microsoft.xmlhttp")
if obj
spreadsheet1.CSVDATA = obj.getData()

The assumption here is that getData is the webservice. Ofcourse, you have a
lot of plumbing work to do to get the xml-http wired up, but this is the
general approach.


--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Sorry for my bad description.

I only want to connect an OWC-web-application with my web service ;-)
I excuted the sample with the windows-application just for comparison.
just
for a thread.

Now, I dont't know how to address the AxPivotTable, AxChartSpace,
AxDataSourceControl etc. because I can't import or reference to AxOWC11 in
a
web-application. But it's strangely possible to do that in a
windows-application (for comparison only).

It's obscure for me, because I thought, that I can build an
owc-web-application in the same way like a owc-windows-application. It
seems
not to be so.

I hope, I described my problem clearer?!

I'm not really sure i understand what you are saying. Are you wanting to
build a windows owc based app that reads a web based owc app?

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
in
message news:[email protected]...

Hi,

I've created a webservice and the adapted OWC11-windows-application
based
on
article http://support.microsoft.com/default.aspx?scid=kb;en-us;315695

It works really fine - incredible ;-)

Now, I want to exercise it in the same way as a vb.net web-application.
The
problem is to referencing to AxOWC11. So, it's impossible to access
AxDataSourceControl1, AxPivotTable1 and so on.

It seems that the web-application isn't able to work with the windows
forms.
Though I've set a reference to System.Windows.Forms.dll

Error in reasoning? Bad beginning? Wrong way? Or just a newbie?!

Thanks for helping me!
Rouven

 

[Rouven Hertenstein]

Hi Alvin,

I'm a little irritated. I thought, that the xml-structure from my webservice
is owc-conform. Finally, the owc-windows-application (that I've just created
for testing) works with this webservice:

<WebMethod()> Public Function GetResultsAsAdoXML() As String
Dim myAdoRs As ADODB.Recordset
Dim myAdoConnection As New ADODB.Connection
Dim mypersiststream As New ADODB.Stream

Dim myConnectionString As String = "driver={SQL Server};" & _
"Server=sql-server;" & _
"Database=test-database;" & _
"UID=sa;" & _
"PW=;"

Dim mySelect As String = "SELECT * from xy"

myAdoConnection.ConnectionString = myConnectionString
myAdoConnection.Open()
myAdoRs = myAdoConnection.Execute(mySelect)
myAdoRs.Save(mypersiststream, ADODB.PersistFormatEnum.adPersistXML)
Return mypersiststream.ReadText
End Function

So, needs an owc-web-application an other xml-structure than an
owc-windows-application? Would be hard to believe.

Regards,
Rouven

first, you need to embed the owc object in the page. Once it is embedded,
your webservice would need to be modified to retrieve comma delimited data.
Then you can use the webservice behavior or xml-http to retrieve data from
the webservice. I have a full example implemented in the black book, but
basically the process would be roughly equivalent to:

-create xml-http instance
var obj = server.createinstance("microsoft.xmlhttp")
if obj
spreadsheet1.CSVDATA = obj.getData()

The assumption here is that getData is the webservice. Ofcourse, you have a
lot of plumbing work to do to get the xml-http wired up, but this is the
general approach.


--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Sorry for my bad description.

I only want to connect an OWC-web-application with my web service ;-)
I excuted the sample with the windows-application just for comparison.
just
for a thread.

Now, I dont't know how to address the AxPivotTable, AxChartSpace,
AxDataSourceControl etc. because I can't import or reference to AxOWC11 in
a
web-application. But it's strangely possible to do that in a
windows-application (for comparison only).

It's obscure for me, because I thought, that I can build an
owc-web-application in the same way like a owc-windows-application. It
seems
not to be so.

I hope, I described my problem clearer?!

I'm not really sure i understand what you are saying. Are you wanting to
build a windows owc based app that reads a web based owc app?

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
in
message Hi,

I've created a webservice and the adapted OWC11-windows-application
based
on
article http://support.microsoft.com/default.aspx?scid=kb;en-us;315695

It works really fine - incredible ;-)

Now, I want to exercise it in the same way as a vb.net web-application.
The
problem is to referencing to AxOWC11. So, it's impossible to access
AxDataSourceControl1, AxPivotTable1 and so on.

It seems that the web-application isn't able to work with the windows
forms.
Though I've set a reference to System.Windows.Forms.dll

Error in reasoning? Bad beginning? Wrong way? Or just a newbie?!

Thanks for helping me!
Rouven

 

[Rouven Hertenstein]

Is it possible to buy your black book in the form of an e-book? The shipment
would take a long time :-(

Regards,
Rouven

Hi Alvin,

I'm a little irritated. I thought, that the xml-structure from my webservice
is owc-conform. Finally, the owc-windows-application (that I've just created
for testing) works with this webservice:

<WebMethod()> Public Function GetResultsAsAdoXML() As String
Dim myAdoRs As ADODB.Recordset
Dim myAdoConnection As New ADODB.Connection
Dim mypersiststream As New ADODB.Stream

Dim myConnectionString As String = "driver={SQL Server};" & _
"Server=sql-server;" & _
"Database=test-database;" & _
"UID=sa;" & _
"PW=;"

Dim mySelect As String = "SELECT * from xy"

myAdoConnection.ConnectionString = myConnectionString
myAdoConnection.Open()
myAdoRs = myAdoConnection.Execute(mySelect)
myAdoRs.Save(mypersiststream, ADODB.PersistFormatEnum.adPersistXML)
Return mypersiststream.ReadText
End Function

So, needs an owc-web-application an other xml-structure than an
owc-windows-application? Would be hard to believe.

Regards,
Rouven

first, you need to embed the owc object in the page. Once it is embedded,
your webservice would need to be modified to retrieve comma delimited data.
Then you can use the webservice behavior or xml-http to retrieve data from
the webservice. I have a full example implemented in the black book, but
basically the process would be roughly equivalent to:

-create xml-http instance
var obj = server.createinstance("microsoft.xmlhttp")
if obj
spreadsheet1.CSVDATA = obj.getData()

The assumption here is that getData is the webservice. Ofcourse, you have a
lot of plumbing work to do to get the xml-http wired up, but this is the
general approach.


--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Sorry for my bad description.

I only want to connect an OWC-web-application with my web service ;-)
I excuted the sample with the windows-application just for comparison.
just
for a thread.

Now, I dont't know how to address the AxPivotTable, AxChartSpace,
AxDataSourceControl etc. because I can't import or reference to AxOWC11 in
a
web-application. But it's strangely possible to do that in a
windows-application (for comparison only).

It's obscure for me, because I thought, that I can build an
owc-web-application in the same way like a owc-windows-application. It
seems
not to be so.

I hope, I described my problem clearer?!


:

I'm not really sure i understand what you are saying. Are you wanting to
build a windows owc based app that reads a web based owc app?

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
in
message Hi,

I've created a webservice and the adapted OWC11-windows-application
based
on
article http://support.microsoft.com/default.aspx?scid=kb;en-us;315695

It works really fine - incredible ;-)

Now, I want to exercise it in the same way as a vb.net web-application.
The
problem is to referencing to AxOWC11. So, it's impossible to access
AxDataSourceControl1, AxPivotTable1 and so on.

It seems that the web-application isn't able to work with the windows
forms.
Though I've set a reference to System.Windows.Forms.dll

Error in reasoning? Bad beginning? Wrong way? Or just a newbie?!

Thanks for helping me!
Rouven

 

[Alvin Bruney [MVP - ASP.NET]]

there is an e-book, but it isn't currently available - possibly toward the
end of the year.


--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc

Is it possible to buy your black book in the form of an e-book? The
shipment
would take a long time :-(

Regards,
Rouven

Hi Alvin,

I'm a little irritated. I thought, that the xml-structure from my
webservice
is owc-conform. Finally, the owc-windows-application (that I've just
created
for testing) works with this webservice:

<WebMethod()> Public Function GetResultsAsAdoXML() As String
Dim myAdoRs As ADODB.Recordset
Dim myAdoConnection As New ADODB.Connection
Dim mypersiststream As New ADODB.Stream

Dim myConnectionString As String = "driver={SQL Server};" & _
"Server=sql-server;" & _
"Database=test-database;" & _
"UID=sa;" & _
"PW=;"

Dim mySelect As String = "SELECT * from xy"

myAdoConnection.ConnectionString = myConnectionString
myAdoConnection.Open()
myAdoRs = myAdoConnection.Execute(mySelect)
myAdoRs.Save(mypersiststream,
ADODB.PersistFormatEnum.adPersistXML)
Return mypersiststream.ReadText
End Function

So, needs an owc-web-application an other xml-structure than an
owc-windows-application? Would be hard to believe.

Regards,
Rouven

first, you need to embed the owc object in the page. Once it is
embedded,
your webservice would need to be modified to retrieve comma delimited
data.
Then you can use the webservice behavior or xml-http to retrieve data
from
the webservice. I have a full example implemented in the black book,
but
basically the process would be roughly equivalent to:

-create xml-http instance
var obj = server.createinstance("microsoft.xmlhttp")
if obj
spreadsheet1.CSVDATA = obj.getData()

The assumption here is that getData is the webservice. Ofcourse, you
have a
lot of plumbing work to do to get the xml-http wired up, but this is
the
general approach.


--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"Rouven Hertenstein" <[email protected]>
wrote in
message Sorry for my bad description.

I only want to connect an OWC-web-application with my web service ;-)
I excuted the sample with the windows-application just for
comparison.
just
for a thread.

Now, I dont't know how to address the AxPivotTable, AxChartSpace,
AxDataSourceControl etc. because I can't import or reference to
AxOWC11 in
a
web-application. But it's strangely possible to do that in a
windows-application (for comparison only).

It's obscure for me, because I thought, that I can build an
owc-web-application in the same way like a owc-windows-application.
It
seems
not to be so.

I hope, I described my problem clearer?!


:

I'm not really sure i understand what you are saying. Are you
wanting to
build a windows owc based app that reads a web based owc app?

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
"Rouven Hertenstein" <[email protected]>
wrote
in
message Hi,

I've created a webservice and the adapted
OWC11-windows-application
based
on
article
http://support.microsoft.com/default.aspx?scid=kb;en-us;315695

It works really fine - incredible ;-)

Now, I want to exercise it in the same way as a vb.net
web-application.
The
problem is to referencing to AxOWC11. So, it's impossible to
access
AxDataSourceControl1, AxPivotTable1 and so on.

It seems that the web-application isn't able to work with the
windows
forms.
Though I've set a reference to System.Windows.Forms.dll

Error in reasoning? Bad beginning? Wrong way? Or just a newbie?!

Thanks for helping me!
Rouven