Data Bind Failed on Spreadsheet Control v10 after installation of

I have a customized Public folder form (it is not a one-off form) that has
version 10 of the Microsoft Spreadsheet control on it. The custom form is
based off the task form. Everything was working fine until we installed
Office XP SP3. We now get an error "Data Bind Failed". This custom form
also will not work with Outlook 2003.

I used the wizard to setup the Datasource and command text. The "test
connection" works fine from within the wizard. We are trying to bind to SQL
Server 2000.

The returned connection string from the wizard looks like this:
"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=xx;Initial
Catalog=xxxxxx;Data Source=xxxxxx;PASSWORD=xxxxxx;"

To work around this problem I can get a recordset and loop through the rows
of the recordset populating the spreadsheet one cell at a time.

I would like to understand what is going on that caused this problem after
installing SP3. A better understanding of this problem will allow me to make
better decissions in the future regarding custom form development.

Thank you,
Eric Fintel

Outlook doesn't suppport binding form controls to datasources. You will need
to write code to fill the spreadsheet control with the desired data.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Eric Fintel" <Eric Fintel@discussions.microsoft.com> wrote in message
news:CCFC467E-CF29-4842-B399-E188B491AEBC@microsoft.com...
>I have a customized Public folder form (it is not a one-off form) that has
> version 10 of the Microsoft Spreadsheet control on it. The custom form is
> based off the task form. Everything was working fine until we installed
> Office XP SP3. We now get an error "Data Bind Failed". This custom form
> also will not work with Outlook 2003.
>
> I used the wizard to setup the Datasource and command text. The "test
> connection" works fine from within the wizard. We are trying to bind to
> SQL
> Server 2000.
>
> The returned connection string from the wizard looks like this:
> "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=xx;Initial
> Catalog=xxxxxx;Data Source=xxxxxx;PASSWORD=xxxxxx;"
>
> To work around this problem I can get a recordset and loop through the
> rows
> of the recordset populating the spreadsheet one cell at a time.
>
> I would like to understand what is going on that caused this problem after
> installing SP3. A better understanding of this problem will allow me to
> make
> better decissions in the future regarding custom form development.
>
> Thank you,
> Eric Fintel