Many bad experience with Infopath 2007

[Bidyut Bhattacharjee]

Hi,
I have worked on InfoPath 2003; recently started to work with InfoPath 2007.
Would have never started to work on Infoapth 2007, had I knew that it is
screwed up.
I have two secondary data sources (two tables), from a SQL Server 2005
database. I am trying to populate a drop down box, using a secondary
connection, with a value the retrieved from a table (of secondary data
source, tblBookLevel ). So If the user selects a certain ‘display name’ from
the drop down the corresponding ‘value’ of the ‘display name’ will be entered
in that field.
I am the database administrator and I have 'Full Control' of the server.
When I am doing a 'preview' of the form I receive the following error message:
'The query cannot be run for the following DataObject: tblBookLevel
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Access is denied.
Access is denied.
'
To test my luck, I changed the Security and Trust Level to 'Full Trust' and
checked 'sign this form template’, and tried to do a preview, this time I got
a message 'InfoPath cannot open the selected form'. This is bizarre.

I don't think I have ever seen such stupid error messages with InfoPath 2003.

I understand that with every new product Microsoft (MS) claims that it is
trying to make its products more secure and stable; but what it is yet to
realize, that it is not so competent to deal with security and stability
issues with grace; and maybe that’s why many enterprise users keep themselves
away from Windows server system, SQL Server and the like MS technologies,
which MS clamis to be enterprise ready.

 

[SSA]

After assigning full trust, the form must be published properly before you
could preview it. Create and deploy a simple form first. Create a form using
the database wizard and if everything goes ok then you can try your custom
code.

 

[Clay Fox]

I have found no significant differences or problems between 2003 and 2007
over the past year and I work with it on a daily basis. But I know how
frustrating it can be when things do not work the way you want.

I think your permissions issue would happen with 2003 as well. If you are
not using some custom code, Full trust probably won't solve your issue.

Verify you can connect via ODBC.
Add the Server to your Intranet or Trusted Sites zone in IE

Try making a database type form to one of your tables in SQL as a test as
well.

If you are using InfoPath and SQL I would recommend the Database Accelerator
Web Services Package from http://www.qdabra.com It installs a whole toolkit
of web services for Database Interaction.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Bidyut Bhattacharjee]

Hi,

Thank you for responding so quickly.

As per the suggestion I created a simple form first, with one 'Main'
connection and 'Preview/ed' it. It works fine. Please note that I am not
deploying the form; but it works fine, which should be the case.

The problem occurs when I add a secondary data source.

After adding a secondary data source, when I am trying to 'preview' the
form, I am getting the same error message 'One or more data sources that are
required to open this form is not available'..then I have three buttons 'Work
Offline','Try to connect' and 'Show Details'.When I click on 'Show Details' I
see this (same error message, the one I got earlier):

'The query cannot be run for the following DataObject: tblBookLevel
InfoPath cannot run the specified query.
The form has requested data that is currently not available offline. The
data will be available when your computer is connected to the network.
'

I am sure it has nothing to do with access rights. Please note that I am
not accessing any field from the secondary data source, I have just added a
secondary connection.

I started to work no InfoPath 2003 about 3 years ago; and found it to be
very useful, to develop UI very quickly; but InfoPath 2007 is ridiculous.


Thanks
Bidyut

 

[Bidyut Bhattacharjee]

Hi Clay,

Thanks for the response. I have never come across such error messages with
InfoPath 2003 when connected to SQL 2005 databases. I don't want to download
anything http://www.qdabra.com and get more into licensing stuff, and end up
spending more money for using a unfriendly technology.

I am extremely frustrated with InfoPath 2007. I will try to create the UI
some other technology. I don't want to waste any more time.

Thanks

 

[Jotto]

You need to specify the correct preview domain in Form options.

This is done by opening Tools > Form Options > Preview
Enter your domain in the Domain text box.