InfoPath Dev

While testing for our transfer from XP to 7, I came across a problem.

If I open a new form from Sharepoint in Windows 7, I get an error messages that it cannot connect to my data connections that are windows server databases. I run queries on these databases using VB in the loading event. It works fine in XP, nut not 7.

However, if I go to design the form and not adjust anything and click preview, everything works fine. So then I thought maybe I just need to save the form from Windows 7, I created a test Form Library on Sharepoint and published my form there and it still fails with the data connection issue as above.

Does anyone have some insight as to how I can fix this?

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

Are you using IP data connections in your code? Or some other approach? What is the trust level on the form?

I don't believe I'm using IP connections in the code.

This is the code I use to run the query:
' Get the EMPLOYEE_VW connection from the DataConnections collection.
Dim myEMPLOYEE_VW As AdoQueryConnection = _
DirectCast(Me.DataConnections("EMPLOYEE_VW"), AdoQueryConnection)

' Change the SQL command for EMPLOYEE_VW connection to retrieve
' the record of the Username from the current user.
myEMPLOYEE_VW.Command = "select * from [EMPLOYEE_VW] where [COMPUTER_USERNAME] = upper('" + CUser + "')"

' Execute the updated command against the data connection to refresh the data.
myEMPLOYEE_VW.Execute()

I added the data connection through the data connection wizard, selecting Microsoft SQL Server.

The trust level is set to automatic, and while grayed out it has Domain Highlighted.

The weird thing is it works when I preview it but not when it's published.

I'm also running on WSS not MOSS it that makes a difference.

You are using a form data connection, so it shouldn't require full trust. What happens on your local machine if instead of Design / Preview, you simply open the form? Instead of opening from SharePoint?

Is your SharePoint site in your local intranet? (I'm trying to think of things that may be different between your XP machine and your Windows 7 machine).

Opening a form from my local machine works fine.

SharePoint is on the local intranet.

Do you have one machine that is Windows 7? Or more than one? Does it fail on all Windows 7 machines? For all users? Sorry -- as you can tell, I don't know what is causing this, just trying to help you brainstorm solutions.

It is failing on all Windows 7 Machines, for all users. Thank you for all your help, I'm just in a bind because the form this is for is a used for troubleshooting users issues in our department, and having accurate data is difficult to get if we rely on the users for all the data.

The big difference going between XP and Windows 7 is user account control (UAC).  The first thing to try is make sure to run as administrator following these steps.

1) Close all Internet Explorer and InfoPath windows.  Check in task manager to make sure none are hanging around.

2) Run IE as administrator.  Navigate to the SharePoint site (making sure it shows local intranet in the taskbar), and then open the form.

 

Also, where do the databases reside?

 

The taskbar for windows or the status bar of IE?

The status bar only says trusted sites | protected mode:off

The task bar for my network status says company.com (internet access)

 When I run IE as admin and go to Sharepoint I still get the Access Denied Errors.