dao in asp

"Robert Chafer" <rob.TakeThisOut@silverfrost.com> wrote in message <news:2n6vrv8844lnn6mq1n1fd5f2lm1isk0hr3@4ax.com>...

 > "Vikramaditya Singh" <vicksjaipur.TakeThisOut@yahoo.com> wrote:
 >
  > > is it possible to use dao 3.6 object in asp page. and if yes than how to
  > > create dao.dbengine and dao.database object in asp
  > >
  > > thanks
  > >
 > Why would you bother?

Agreed. Using DAO instead of SQL Server from ASP is probably
a EULA violation! Although a CreateObject("DAO.DBEngine.35")
or CreateObject("DAO.DBEngine.36") ought to work in VBScript.

--
Joe Foster <mailto:jlfoster%40znet.com> Space Cooties! <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: dao in asp 

CreateObject(DAO.DBEngine.35) won't work in VBscript
unless DAO/Jet has been /licensed/ as well as installed
and registered. Licensing normally happens when you
install Access or Visual Studio or ????. I know I
can't VBscript DAO.DBEngine.35 after installing DAO/Jet
3.5 on a clean copy of Windows.

Given that Jet 4.0 was part of the last Windows Service
pack, I don't know that the same applies to DBengine.36

Also, reviewing the experience of Jet with Web, we see
that the first problem was that the ODBC drivers were not
thread safe (compiled with a version of the C++ data
classes that was not thread safe). The second problem
was that the data could not be backed up (when asp pages
are sourced from a Jet database, the database is locked
unless the web server is brought down). Neither of
these problems are obviously relevant to the question.
Jet is a relatively fast and flexible database engine:
If he can avoid the licensing problem, it will be interesting
to see what he comes up with.

(david)


"Joe "Nuke Me Xemu" Foster" <joe.DeleteThis@bftsi0.UUCP> wrote in message
news:uZLNr1SsDHA.2304@TK2MSFTNGP12.phx.gbl...
 > "Robert Chafer" <rob.DeleteThis@silverfrost.com> wrote in message
<news:2n6vrv8844lnn6mq1n1fd5f2lm1isk0hr3@4ax.com>...
 >
  > > "Vikramaditya Singh" <vicksjaipur.DeleteThis@yahoo.com> wrote:
  > >
   > > > is it possible to use dao 3.6 object in asp page. and if yes than how
to
   > > > create dao.dbengine and dao.database object in asp
   > > >
   > > > thanks
   > > >
  > > Why would you bother?
 >
 > Agreed. Using DAO instead of SQL Server from ASP is probably
 > a EULA violation! Although a CreateObject("DAO.DBEngine.35")
 > or CreateObject("DAO.DBEngine.36") ought to work in VBScript.
 >
 > --
 > Joe Foster <mailto:jlfoster%40znet.com> Space Cooties!
<http://www.xenu.net/>
 > WARNING: I cannot be held responsible for the above They're
coming to
 > because my cats have apparently learned to type. take me away,
ha ha!
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: dao in asp