Group:  Other Microsoft Office Products ยป microsoft.public.infopath
Thread: Sharepoint Deployment

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Sharepoint Deployment
Gary 27.07.2006 00:30:01
I have a form that I developed on my computer. It includes a couple of data
connections that use a ODBC data source and some managed code that includes
reading and writing to the Access database. The managed code also accesses
Active Directory (I've also tried a web service for this). Everything works
fine.

I then modify the code to change the location of the database in the code
and publish to a Sharepoint server. I logon to the server add a trusted
certificate and I have to modify the data connections to point to the correct
path. Not sure why I have to do this because I defined the same ODBC data
source in the server, the only difference being the path for the database.
After I make those changes everything works on that machine.

I now go to a user machine and fill in the form from the Sharepoint site and
I receive an error that states that the form can not find the secondary data
connection. I link to the server drive, create the ODBC data source on the
user machine and the form tells me that the path is wrong and allows me to
change it. I change it, the form comes up but it doesn't update the database
from the code, and none of the Active Directory fields are populated.

What am I doing wrong??? Do I need to install the form on each machine and
modify it to execute in that machine??

FYI...I'm using the same user account in both the server and the user machine
--
Gary

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net