Data Bind Failed on Spreadsheet Control v10 after installation of

[Eric Fintel]

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

 

[Sue Mosher [MVP-Outlook]]

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