foreign key problem

2002-03-04 Thread Asit Satpathy
(t1id) REFERENCES t1(id) ) TYPE=InnoDB; it supports the foreign key fine. if i will alter the table t2 and add one more column to it , then foreign key is not working . if anybody knows about this or it is a bug of MySQL ? Regards Asit

please help me

2002-02-28 Thread Asit Satpathy
I have installed mysql -3.23.39-pc-linux-gnu-i686 on linux , and i want to use foreign key constraints . what configurations i have to made. please give step by step procedure so that i am able to install in my machine and able to work. waiting for your reply. Regards --

Please help me

2002-02-28 Thread Asit Satpathy
I have installed mysql -3.23.39-pc-linux-gnu-i686 on linux , and i want to use foreign key constraints . what configurations i have to made. please give step by step procedure so that i am able to install in my machine and able to work. waiting for your reply. Regards

Help Regarding datadir configuration

2002-02-14 Thread Asit Satpathy
=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max-nt.exe user=asit password=asit QueryInterval=10 Regards Asit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Regarding Mysql Database file system

2002-02-13 Thread Asit Satpathy
I need to create a database in MySQL that I need to bundle with my program for distribution. The user will have its own copy of MySQL running. User using my program will not bother about database issues and the bundled database will provide him, through my application program GUI, to enter/retr

Help required for OLEDB on win32 for MySQL(linux)

2001-06-07 Thread asit
=Test dcncentral.Open str1- Giving Catastrophic Error End Sub This function is not opening the database and giving "Catastrophic Error". What should be the connection string for database ? Please help. Kindly note that I want to connect to MYSQL database without a DSN Thanks i