Hey guys, I have some questions concerning ODBC, I'm doing a job on a server which requires me to access a MS Access DB and write a front end for it, so employees of the company can run query's. I just have some questions. I'm using mysql w/ odbc drivers and php. Does teh server (NT 4) need to have access installed in order to run query's? I was able to access a db using odbc_connect(DSN_Name, user, password); but i couldn't run the query "CREATE TABLE customers (customerid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(30) NOT NULL);
It gave me an error saying error in SQL syntaz at CREATE TABLE.. i used odbc_exec() but MS Access is not installed on that machine yet. Do i need to do this in order to create tables and run queries? and if so is the SQL sytnax exactly the same as 'normal' SQL syntax? thanks Jule --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
