Cant create table

I get this error when I try to create the following tables:

ERROR 1005 (HY000): Can't create table '.\haps\transcript.frm' (errno: 150)

create table teaching (
ProfId int,
CrsCode varchar(10),
Semester varchar(10),
primary key(ProfId, CrsCode, Semester)
) engine=InnoDB;

create table transcript (
StudId int,
CrsCode varchar(10),
Semester varchar(10),
primary key(StudId, CrsCode, Semester),
foreign key(CrsCode, Semester) references teaching(ProfId, CrsCode,
Semester)
) engine=InnoDB;

What am I doing wrong??For starters, you're posting in the wrong newsgroup :)

Try posting in the MySQL newsgroups, rather than the SQL Server groups,
and they might be help to give you better insight. However, this link
might point you in the right direction.

http://www.mysqlusers.com/msg/11638.html

HTH,
Stu|||Because you are in MySql

"blumi" <test@.me.com> a crit dans le message de news:
d9roip$m29$1@.news.net.uni-c.dk...
>I get this error when I try to create the following tables:
>
> ERROR 1005 (HY000): Can't create table '.\haps\transcript.frm' (errno:
> 150)
> create table teaching (
> ProfId int,
> CrsCode varchar(10),
> Semester varchar(10),
> primary key(ProfId, CrsCode, Semester)
> ) engine=InnoDB;
>
> create table transcript (
> StudId int,
> CrsCode varchar(10),
> Semester varchar(10),
> primary key(StudId, CrsCode, Semester),
> foreign key(CrsCode, Semester) references teaching(ProfId, CrsCode,
> Semester)
> ) engine=InnoDB;
> What am I doing wrong??