|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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
|
|
|