WSS and secondary data connection problem?

[Chris K]

I have a form that has main data source connections to a SQL database. I
have a number of tables that are a part of this main data sources. I also
have 8 secondary data sources. These secondary data sources are a part of
the same SQL database (different tables with a key relationship to a table in
the main data source) that provide status codes and description values. I
use the secondary data sources to provide valid values in drop down lists.

On my machine the form works correctly (wherever I open it from; WSS,
folder,...), meaning the drop down lists show the values defined in the code
tables, the data is submitted correctly, and the data when viewed in the form
is correct.

The problem exists when others try to view the form. No matter how a user
tries to connect to the form (publish to WSS or to a shared folder).
Infopath erros out as long as any secondary data source is a part of the
form. If I try to open the exact same form from my computer, I can
successfuly open it.

Any ideas on how to correct this?

Thanks
Chris

 

[Scott L. Heim [MSFT]]

Hi Chris,

What exactly occurs? What error are your users seeing?

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Chris K]

The error message is

InfoPath cannot open the following file: Test.xml.

InfoPath cannot open the form. To fix this problem, contact your system
administrator.

Form template:
http://wss1.ralston.com/IT/PM/Project/Project Tracking/Forms/template.xsn

The following DataObject either cannot be created or cannot be initialized:
PROGRAM

The query cannot be run for the following DataObject: PROGRAM

InfoPath cannot run the specified query.

InfoPath cannot connect to the data source.

[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
______________

We figured out a way to solve the problem, is this the only(best) way? The
users who could not connect did not have a User DSN connection setup yet.
Once that was setup the connection happens with no problems.

 

[Scott L. Heim [MSFT]]

Hi Chris,

Basically yes - keep in mind that regardless of where you store the XSN,
the created "form" will be opened locally on each user's machine. As such,
connections that you have created to be able to get to data sources must
also exist on the users machines as well.

Glad to hear you have this working!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.