InfoPath Dev

Hi, I am trying to create an instance of SPSite in Form_Loading event of the InfoPath 2007 template. When I use: SPSite site = new SPSite("http://myserver/mysite") I get error: System.IO.FileNotFoundException: The Web application at http://myserver/mysite could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application. at Microsoft.SharePoint.SPSite..ctor(SPFarm farm, Uri requestUri, Boolean contextSite, SPUserToken userToken) at.... I am using Visual Studio 2008 on Windows 2008 R2 (64-Bit) Any suggestion?

Code that uses the SharePoint object model has to be run directly on the server or you will get a FileNotFound exception.  A better practice, if possible, is to use the SharePoint web services, which do not have that restriction.

Thanks Jimmy for the reply... Ok I will try web service but I am unable to figure out why it is not working. I am running code on the server. I also used the same code in the console application and it was working fine!!

hm, i successfully use SharePoint.DLL in my forms, but if you run it on the server (in case infopath client) or use it in web browser.