F
fakethingsster
I have a reporting application that is created using Microsoft Access
Data Access Pages. The pages currently interface with a SQL Server
2000 server which needs to be moved.
I found the following in some of the Data Access Pages and plan to
modify the Data Source parameter:
<a:ConnectionString>Provider=SQLOLEDB.1;Persist Security Info=True;User
ID=CADII;Initial Catalog=CADII;Data Source=oldserver
I also found a file called DataAccessPage.odc [which, according to the
property page, says its a Microsoft Office Data Connection file]. It
contains another reference to the Data Source on the old server which I
was planning to update.
Is there anything else that needs to happen so that these pages retain
functionality once the database is moved to the new server?
Thanks!
Data Access Pages. The pages currently interface with a SQL Server
2000 server which needs to be moved.
I found the following in some of the Data Access Pages and plan to
modify the Data Source parameter:
<a:ConnectionString>Provider=SQLOLEDB.1;Persist Security Info=True;User
ID=CADII;Initial Catalog=CADII;Data Source=oldserver
I also found a file called DataAccessPage.odc [which, according to the
property page, says its a Microsoft Office Data Connection file]. It
contains another reference to the Data Source on the old server which I
was planning to update.
Is there anything else that needs to happen so that these pages retain
functionality once the database is moved to the new server?
Thanks!