Three Tier Access Database page

• Previous message: Scott: "How do I create a search engine for my database???"
• Messages sorted by: [ date ] [ thread ]

Date: 3 Jun 2004 09:41:53 -0700

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=MyPassword"

[userlist AuthorDatabase]
Administrator=ReadWrite

[sql AuthorById]
Sql="SELECT * FROM Authors WHERE au_id = ?"

Thanks,

Delf

• Previous message: Scott: "How do I create a search engine for my database???"
• Messages sorted by: [ date ] [ thread ]