Database request support from normal user in their VD

Hi Egbert Nierop,

Thanks for your reply first.

However, how do I know whether my server supports "Ole Db connection string"
or related string/methods for users?

"Egbert Nierop (MVP for IIS)" wrote:

 >
 > "Alan T" <AlanT.TakeThisOut@discussions.microsoft.com> wrote in message
 > news:61A88E88-3D4D-41FA-ADDF-A1AF29D432E8@microsoft.com...
  > > I've setup an IIS 6.0 server and allow users running with ASP & ASP.NET in
  > > their virtual directories. However, some users request to use database
 > under
  > > their VD. I know that if I customize the anonymous user account on
 > particular
  > > folder/file under their VD that can allow anonymous user from web browser
 > to
  > > write data into their database file (e.g. *.mdb). Is it the only way to
  > > support them?
 >
 >
 > You also can use 'Authenticated Users' instead of the anonymous user... But
 > decide carefully. It's not wise, to allow Access databases by the way.
 > That's because Access simply is not designed for HTTP traffic.
 >
  > > In additional, I read some materials about "Data Source Name (DSN)". Is it
 > a
  > > choice for user or for administrator to hold a web server that support
  > > database?
 >
 > DSNs are stored in the registry and require a lot of extra administrative
 > work.
 > Better is it, to use a Ole Db connection string
 >
 > myDB = "Data Source=" + Server.MapPath("datadir/yourdatabase.mdb") +
 > ";provider=Microsoft.Jet.Oledb.4.0;"
 >
 > --
 >
 > ISP Session; Session replacement for ASP + ASP.NET
<font color=purple> > <a style='text-decoration: underline;' href="http://www.nieropwebconsutl.nl/asp</font" target="_blank">http://www.nieropwebconsutl.nl/asp</font</a>>
 >
  > > Thanks,
  > > Alan
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database request support from normal user in their VD 

"Alan T" <AlanT.DeleteThis@discussions.microsoft.com> wrote in message
news:943CEB5C-49E6-4469-B5EC-CB604E92CAB7@microsoft.com...
 > Hi Egbert Nierop,
 >
 > Thanks for your reply first.
 >
 > However, how do I know whether my server supports "Ole Db connection
 > string"
 > or related string/methods for users?

It's even difficult -not- to support ole db. By default, a windows 2000 and
2003 support Ole Db out of the box. However, it is a best practice, to
update MDAC to the most recent version.


In addition, the question is , if you have the JET Ole Db Driver on your
system.

First install the most recent MDAC
<a style='text-decoration: underline;' href="http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en" target="_blank">http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795...7d-b037</a>
Then install JET

(for XP:
<a style='text-decoration: underline;' href="http://www.microsoft.com/downloads/details.aspx?FamilyID=2deddec4-350e-4cd0-a12a-d7f70a153156&DisplayLang=en" target="_blank">http://www.microsoft.com/downloads/details.aspx?FamilyID=2deddec4-350e...d0-a12a</a>)
or for Windows 2000
<a style='text-decoration: underline;' href="http://www.microsoft.com/downloads/details.aspx?FamilyID=1e268b39-533e-48b0-b8d7-1781befde1f8&DisplayLang=en" target="_blank">http://www.microsoft.com/downloads/details.aspx?FamilyID=1e268b39-533e...b0-b8d7</a>
or for Windows 2003
<a style='text-decoration: underline;' href="http://www.microsoft.com/downloads/details.aspx?FamilyID=97bc8126-5c60-44bc-a2ce-1e40c7fe2b34&DisplayLang=en" target="_blank">http://www.microsoft.com/downloads/details.aspx?FamilyID=97bc8126-5c60...bc-a2ce</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database request support from normal user in their VD 

Then, any relationship between OLE DB & JET? Any materials talking about
database support on Win2000/2003 that can refer on web?

"Egbert Nierop (MVP for IIS)" wrote:

 > "Alan T" <AlanT.DeleteThis@discussions.microsoft.com> wrote in message
 > news:943CEB5C-49E6-4469-B5EC-CB604E92CAB7@microsoft.com...
  > > Hi Egbert Nierop,
  > >
  > > Thanks for your reply first.
  > >
  > > However, how do I know whether my server supports "Ole Db connection
  > > string"
  > > or related string/methods for users?
 >
 > It's even difficult -not- to support ole db. By default, a windows 2000 and
 > 2003 support Ole Db out of the box. However, it is a best practice, to
 > update MDAC to the most recent version.
 >
 >
 > In addition, the question is , if you have the JET Ole Db Driver on your
 > system.
 >
 > First install the most recent MDAC
<font color=purple> > <a style='text-decoration: underline;' href="http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en</font" target="_blank">http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795...7d-b037</a>>
 > Then install JET
 >
 > (for XP:
 > <a style='text-decoration: underline;' href="http://www.microsoft.com/downloads/details.aspx?FamilyID=2deddec4-350e-4cd0-a12a-d7f70a153156&DisplayLang=en" target="_blank">http://www.microsoft.com/downloads/details.aspx?FamilyID=2deddec4-350e...d0-a12a</a>)
 > or for Windows 2000
<font color=purple> > <a style='text-decoration: underline;' href="http://www.microsoft.com/downloads/details.aspx?FamilyID=1e268b39-533e-48b0-b8d7-1781befde1f8&DisplayLang=en</font" target="_blank">http://www.microsoft.com/downloads/details.aspx?FamilyID=1e268b39-533e...b0-b8d7</a>>
 > or for Windows 2003
 > <a style='text-decoration: underline;' href="http://www.microsoft.com/downloads/details.aspx?FamilyID=97bc8126-5c60-44bc-a2ce-1e40c7fe2b34&DisplayLang=en" target="_blank">http://www.microsoft.com/downloads/details.aspx?FamilyID=97bc8126-5c60...bc-a2ce</a>
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Database request support from normal user in their VD