Cannot connect PHP to MS Accesss Database

Junior WebHelper Joined: 27 Jul 2003 Posts: 4

Hi,
Although I defined the System DSN I am having the error message below:
SQL error:[Microsoft][ODBC Microsoft Access Driver] Cannot modify the design of tabel 'testtable'. It is in a read-only database., SQL state 42000 in SQLExecDirect in c:inetpub\wwwroot\createtable.php on line 7
Code in createtable.php is as follows:

Code:

<?php
$connectionID = odbc_connect ("database.dsn","",""); //database.dsn is the name of system DSN
$statement = "CREATE TABLE testtable (name TEXT, telephone TEXT);";
odbc_do ($connectionID, $statement);
odbc_close = ($connectionID);
?>

As you can notice I am new in this subject and trying to use MS Access as th database of PHP pages by using windows XP IIS and the database in the same machine. The name of the database is "database" and saved in wwwroot directory.
Is there anyone who can help me????
Thanx in advance.

Posted: Sun Jul 27, 2003 8:36 am (20 years, 8 months ago)

As per the 'Forum Rules' the duplicate of this post has been removed from 'Server-Side Coding' - Please only post a question in one forum, thanks.