Dear Sir, Re:MySQL Database - DSN How to create a DSN for MYSQL DATABSE on online LINUX server. Pl provide me the syntax. And also I need the syntax for FOREIGN KEY with references to access two tables in MYSQL. for eg. (A) Table name : Parent (column name is PARTY varchar(10) primary key); (B) Table Name : Child (column name is PARTY varchar(10) references parent(party)); its showing an error : the above command is working in MS-SQL SERVER 7.0 / Oracle 8 Kindly send the SYNTAX for the above. I fervently hope that the next ring of my mail will be of yours. Thanks and regards. truly yours Palaniappan. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. --------------------------------------------------------------------- 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