Can't create table

[blumi]

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??

[Stu]

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

[Fernand St-Georges]

Because you are in MySql
"blumi" <te**@me.com> a écrit dans le message de news:
d9**********@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??