Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ConnectToObject Fails for Excel Documents

2 posts in DataWindow .NET Last posting was on 2004-08-26 14:09:14.0Z
Naresh Vajawat Posted on 2004-08-26 13:53:07.0Z
Sender: 504a.412deb50.1804289383@sybase.com
From: Naresh Vajawat
Newsgroups: sybase.public.datawindow.net
Subject: ConnectToObject Fails for Excel Documents
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <412decb5.51e5.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 26 Aug 2004 06:59:17 -0700, 10.22.241.42
Lines: 16
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Aug 2004 06:42:57 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Aug 2004 06:53:07 -0700
X-Trace: forums-1-dub 1093528387 10.22.108.75 (26 Aug 2004 06:53:07 -0700)
X-Original-Trace: 26 Aug 2004 06:53:07 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:205
Article PK: 124643

Hi All,
I have a composite datawindow which has 5 datawindows in
it.I savethem as Excel using the SaveAs Function and
htmltable! as the parameter. Now 4 of them do not have any
issues, but the 5th one creates a 2 MB excel file and the
connectoobject for it fails.Actually the code works just
fine in 6.5 and we migrated the code from 6.5 to 9.0. We
also installed the 5506 patch but even that did not work.We
have been struggling hard to get a solution for this.Any
pointers on this would be appreciated. If you are in US you
can call me at 813 978 2699.If you need further information
please let me know. you can reach me at
naresh_vajawat@infosys.com.

Thanks and regards,
Naresh


dfish Posted on 2004-08-26 14:09:14.0Z
From: dfish@_no_spam_sybase.com (Dave Fish [Team Sybase])
Newsgroups: sybase.public.datawindow.net
Subject: Re: ConnectToObject Fails for Excel Documents
Organization: Sybase Professional Services
Reply-To: nospam_dfish@sybase.com_nospam
Message-ID: <412dec39.155747743@forums.sybase.com>
References: <412decb5.51e5.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
X-Original-NNTP-Posting-Host: vpn-dub-037.sybase.com
X-Original-Trace: 26 Aug 2004 07:15:24 -0700, vpn-dub-037.sybase.com
Lines: 28
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Aug 2004 06:59:04 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Aug 2004 07:09:14 -0700
X-Trace: forums-1-dub 1093529354 10.22.108.75 (26 Aug 2004 07:09:14 -0700)
X-Original-Trace: 26 Aug 2004 07:09:14 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:206
Article PK: 124642

This newsgroup is for DataWindow .NET questions and issues. Please
post your message in the powerbuilder.ole-activex-ocx newsgroup.

Regards,
Dave Fish
Sybase

TeamSybase blogs: http://www.teamsybase.net/blogs/

On 26 Aug 2004 06:53:07 -0700, Naresh Vajawat wrote:

>Hi All,
> I have a composite datawindow which has 5 datawindows in
>it.I savethem as Excel using the SaveAs Function and
>htmltable! as the parameter. Now 4 of them do not have any
>issues, but the 5th one creates a 2 MB excel file and the
>connectoobject for it fails.Actually the code works just
>fine in 6.5 and we migrated the code from 6.5 to 9.0. We
>also installed the 5506 patch but even that did not work.We
>have been struggling hard to get a solution for this.Any
>pointers on this would be appreciated. If you are in US you
>can call me at 813 978 2699.If you need further information
>please let me know. you can reach me at
>naresh_vajawat@infosys.com.
>
>Thanks and regards,
>Naresh