G
Gary
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
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