Finde den Fehler nicht (ADO)

[Julian Maicher]

Hi,

Folgender Fehler:

Warning: (null)(): Invoke() failed: Ausnahmefehler aufgetreten. Source: Microsoft OLE DB Provider for ODBC Drivers Description: [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in CREATE TABLE-Anweisung. in d:\localhost\sus_access\create.php on line 44
Creating client list table.

Folgender Code:

$conn = new COM("ADODB.Connection") or die("Cannot start ADO"); 

// Microsoft Access connection string.
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("datenbank.mdb"));
 
print "Creating Tables:\n";

$conn->execute("CREATE TABLE Patches (
             Patch_ID int unsigned DEFAULT '0' NOT NULL AUTO_INCREMENT,
             Patch_Name varchar(180) DEFAULT '' NOT NULL,
             Patch_Description varchar(40) DEFAULT '',
             Patch_OS varchar(30) DEFAULT '',
             Installed int unsigned DEFAULT '0' NOT NULL,
             Downloaded int unsigned DEFAULT '0' NOT NULL,
             PRIMARY KEY (Patch_ID))");  <--- Line 44

Finde den Fehler einfach nicht.

 

[MiLa]

$conn->execute("CREATE TABLE Patches (
             Patch_ID int unsigned DEFAULT '0' NOT NULL AUTO_INCREMENT,
             Patch_Name varchar(180) DEFAULT '',
             Patch_Description varchar(40) DEFAULT '',
             Patch_OS varchar(30) DEFAULT '',
             Installed int unsigned DEFAULT '0' NOT NULL,
             Downloaded int unsigned DEFAULT '0' NOT NULL,
             PRIMARY KEY (Patch_ID))");

Like this?