InfoPath Dev

Hope someone can help me with this:........pls
When i tried to open the form template (uploaded the form template) through sharepoint from other machines I get the follwing error

Eventhough I changed my Trust level  of my form to FULL TRUST ,I get the error

InfoPath cannot connect to a data source
To try to connect to other data sources, click "Try to connect".
To use previously used data, click "Work offline".

If I click on the 'Show Details' button, I receive the following info:

The query cannot be run for the following DataObject: My
connection
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Access is denied.
Access is denied.

'My Connection' is the connection name that I specified during initial
setup.Any help would be greatly appreciated .........!!!!!!!!

Regards Inzia 

Hi,

Generally, this error would be displayed when we don't have permissions to connect to that secondary data connection or the schema is incorrect. Can you tell, what is the 'My Connection' data connection is connecting to?

Hello,

Can you check once that connection is available or not in Internet Explorer once before opening the form. (My connection)

Can you give more details on what type of connection it is ‘My connection'?

Whenever you are trying to connect that connection is not available or you don't have access permission to that connection.

 Thank u very much for ur reply

I am using MSSQL 2000 as back end.

Cannot connect to following data object :JC and JC is th table I am using

 Thank u ........

My connection is MSSQL 2000...........

Hi,

Make sure that you have permissions to access that database.