I have the program which requires a ODBC connection to input and output data. To get ODBC I whent into Win2k3's start menu, administrative tools and ODBC.. from there I added username, pass, made the db.mdb file and have tested the connection with PHP and it works to connect and query the tables.
But the syntax is a little different for ODBC I believe..
I use this in ODBC to create a table, and it works:
CREATE TABLE users (output VARCHAR(255) NOT NULL);
But I want like with MySQL you can have each new input in the database to be assigned a numeric id which increasing with each new input to the database. To do the same and include a numeric id only in MySQL I would do this:
Thanks for reply.
I get this error when using that code:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement., SQL state 37000 in SQLExecDirect in W:\www\odbc\odbc.php on line 10
Heres my whole file:
$con = odbc_connect('ren','root','root');