[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-users
Subject:    Re: error
From:       Martin Evans <martin.evans () easysoft ! com>
Date:       2007-08-01 14:25:11
Message-ID: 46B097C7.2080600 () easysoft ! com
[Download RAW message or body]

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" 
> <martin.evans@easysoft.com>
> To: <dbi-users@perl.org>
> 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
>>
>>
> 
> 
[prev in list] [next in list] [prev in thread] [next in thread]