dose it possible to run site with access database?

[fishown]

i wonderd if i can use MS Access as site database..
if its possible how do i connect to the database with adodb?
and what are the diffrents betwen Jet and Driver?

Thank you very much

[NogDog]

It is possible via a ODBC connection, though I would give serious consideration to moving the database to pretty much any other DBMS if possible. :p See the users' notes on the [man]odbc_connect[/man] page for various information and examples of using MS Access.

[fishown]

NogDog;10886182 wrote:

It is possible via a ODBC connection, though I would give serious consideration to moving the database to pretty much any other DBMS if possible. :p See the users' notes on the [man]odbc_connect[/man] page for various information and examples of using MS Access.

i know how to connect via odbc, i wonder how can you define odbc connention on web server?

is it possible can you direct me to explanation?

thank you..

[rokchik]

<?php
   include_once('DB.php');

   $conninfo = "mysql://username:password@localhost/phpdb";
   $db = DB::connect($conninfo);

   if (DB::isError($db)) {
      print $db->getMessage();
      exit;
   } else {
      $result = $db->query("SELECT * FROM people;");

  while ($result->fetchInto($row, DB_FETCHMODE_ASSOC)) {
     extract($row);
     print "$Name: $NumVisits\n";
  }

  $result->free();
   }

   $db->disconnect();
?>

Notice how PEAR:😃B uses a URL-like connection string, often called a Data Source Name (DSN), to entirely define its connection. This is the same method as seen in JDBC, so it should be familiar to Java developers already. The string can be broken down like this:
mysql:// Connection type
Username Your username
Password Your password
@ The address of your server
/phpdb The database name to use

The connection type is for what kind of server to which you intend on connecting. You can choose from the following list:
fbsql FrontBase
ibase InterBase
ifx Informix
msql Mini SQL
mssql Microsoft SQL Server
mysql MySQL
oci8 Oracle 7/8/8i
odbc ODBC (Open Database Connectivity)
pgsql PostgreSQL
sqlite SQLite
sybase SyBase

http://hudzilla.org/phpwiki/index.php?title=Introducing_PEAR:😃B

So you change mysql:// to mssql:// and that's it...

[fishown]

and if i dont want to define the database on ODBC...
just wanna conntent to the file as it is...
do i need to change the DBname (phpdb) to the db location?