Samuel_Zheng wrote: > Hi Martin, > > I know Chinese. Just that it is not displayed properly Icannot read it. > what more info is needed? Do you think. > I use the excel to open the ACCESS97 database and it was fine. > regards, > samuel With a 42000 error should be some text describing the error - the syntax error in your SQL. If you can't get this you'll have to output the SQL when prepare fails and examine it to see what looks wrong. I can't really say anything more since you appear to have a syntax error but there is no associated description so the problem could be anything. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com > ----- Original Message ----- From: "Martin Evans" > > To: > Sent: Wednesday, August 01, 2007 3:20 AM > Subject: Re: error > > >> Samuel_Zheng wrote: >>> this is the error message, Because it on a Chinese 2003 server and >>> the chinese is missing some bytes. I cannot read what it says. Does >>> anyone can tell what it means and suggest things to try? >>> thanks, >>> samuel >>> >>> Software error: >>> DBI connect('btn','',...) failed: [Microsoft][ODBC Microsoft Access >>> Driver] uEz (SQL-42000)(DBD: db_login/SQLConnect err=-1) at >>> C:\web\validate.pl line 130 >>> >>> >>> >> Can't really tell much from that except it is a 42000 error which is >> "Syntax error or access violation" and the problem depends on what >> ODBC API you were calling (probably SQLPrepare/SQLExecDirect). You can >> find 42000 description at: >> >> http://www.easysoft.com/developer/interfaces/odbc/sqlstate_status_return_codes.html#42000 >> >> >> but I think you are going to have to dig deeper or learn Chinese. >> >> Martin >> -- >> Martin J. Evans >> Easysoft Limited >> http://www.easysoft.com >> >> __________ NOD32 2430 (20070731) Information __________ >> >> This message was checked by NOD32 antivirus system. >> http://www.nod32.com.hk >> >> > >