If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Data Access Page Problem
I think that when you access Data Access Pages with your web browser you
don't do it through HTTP, you do it directly. So in your web browser address bar you put something like \\Servername\SharedFolder\dataaccesspage.htm "Delf Meek" wrote in message ... hello all, I'm new to Data Access Pages, and am trying to deploy a simple data access page on the internet. I've followed the instructions in Microsoft's MSDN article "Deploying Data Access Pages on the Internet or Your Intranet". I do not understand what I am doing wrong. When I place the data access page in the C:\Inetpub\wwwroot, and try to browse the server name by typing http://servername/dataccesspage.htm, all i get is the header section of the Data Access Page, but no controls that allow a person to enter data. if I open the web page directly through windows explorer, it tells me "The UseRemoteProvider propery is supported only for pages saved to Web folders". So, I do believe I have the UseRemoteProvider property in the access database set properly. It acts like the web page cannot connect to the database, which is also located on the webserver. Can anybody give me any pointers? I'm starting to get very frustrated with this. Do I need to install something else on my server? Below is a copy of my MSDFMAP.ini file from my Windows 2000 Server. ;[connect name] will modify the connection if ADC.connect="name" ;[connect default] will modify the connection if name is not found ;[sql name] will modify the Sql if ADC.sql="name(args)" ;[sql default] will modify the Sql if name is not found ;Override strings: Connect, UserId, Password, Sql. ;Only the Sql strings support parameters using "?" ;The override strings must not equal "" or they are ignored ;A Sql entry must exist in each sql section or the section is ignored ;An Access entry must exist in each connect section or the section is ignored ;Access=NoAccess ;Access=ReadOnly ;Access=ReadWrite ;[userlist name] allows specific users to have special access ;The Access is computed as follows: ; (1) First take the access of the connect section. ; (2) If a user entry is found, it will override. [connect default] ;If we want to disable unknown connect values, we set Access to NoAccess Access=ReadWrite [connect C:\database\db1.mdb] ;If we want to disable unknown connect values, we set Access to NoAccess Access=ReadWrite [sql default] ;If we want to disable unknown sql values, we set Sql to an invalid query. ;Sql=" " [connect CustomerDatabase] Access=ReadWrite Connect="DSN=AdvWorks" [sql CustomerById] Sql="SELECT * FROM Customers WHERE CustomerID = ?" [connect AuthorDatabase] Access=ReadOnly Connect="DSN=MyLibraryInfo;UID=MyUserID;PWD=MyPass word" [userlist AuthorDatabase] Administrator=ReadWrite [sql AuthorById] Sql="SELECT * FROM Authors WHERE au_id = ?" Thanks, Delf |
Thread Tools | |
Display Modes | |
|
|