List:MySQL ODBC« Previous MessageNext Message »
From:Calistra Research Labs Date:March 19 1999 5:13pm
Subject:ODBC Error 13
View as plain text  
I am executing
ALTER TABLE Cases 
CHANGE COLUMN newcol CaseID int(11) NULL
to rename a column.

MySQL renames the file Cases.frm to B-1.frm and returns the 
following error

SQLExecDirect returned SQL_ERROR
 State S1000 Native Code 7
[TCX][MyODBC]Error on rename of './Reginald/cases.ISD' to 
'./Reginald/B-1.ISD' (Errcode: 13)

Whereafter the table Cases no longer exists!

Any ideas - (I will be running the debug log tomorrow)
Dave Appleton		Calistra Research Labs Pte Ltd
Tel : +65-9-640-2960	111 North Bridge Rd #21-01
Fax : 756-6058		Peninsular Plaza
                        Singapore 179098
Machine Vision Systems
Interactive Voice Response Systems Development 
IT Consultants & Custom Software Development                    
mySQL Database Consultants / Developers
Thread
MySql error (File DSN not saved)James Coyle19 Mar
  • Re: MySql error (File DSN not saved)Christian Mack19 Mar
  • Re: MySql error (File DSN not saved)Ingo Dean19 Mar
    • ODBC Error 13Calistra Research Labs19 Mar
      • ODBC Error 13Michael Widenius19 Mar