error

------=_NextPart_000_000E_01C7D3D6.DBE3A5E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=3D-1) at =
C:\web\validate.pl line 130



------=_NextPart_000_000E_01C7D3D6.DBE3A5E0--

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_s tatus_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

Re: error

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

----- 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_s tatus_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
>
>

Re: error

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_s tatus_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
>>
>>
>
>