RE: Problem with Windows ODBC driver and PHP

Hello!

> Hello Claus
>
> > -----Original Message-----
> > From: Claus Windeler [mailto:cw@xxxxxx]
> > Sent: Freitag, 17. Dezember 2004 15:36
> > To: maxdb@xxxxxxxxxxxxxxx
> > Subject: Problem with Windows ODBC driver and PHP
> >
> [problem description snipped]
>
> > Because it's working in Linux, I believe the problem is
> > related to the Windows
> > ODBC driver.
>
> Hm, the code base for the ODBC-driver is essentially the same. But
> what is definitely different is the driver manager (if you use any
> under Linux).
>
> Please switch on the internal or driver manager trace. Maybe this
> shed some light on the problem.

Here is the Windows trace from the relevant part (at least I think so):

INSERT INTO MYFILES (id, filetype, filecontent, filesize) VALUES( ?, ?, ?, ?)
EXECUTE: CMD   :
PARSEID: INPUT :  000101B3 00004001 23000000 01000000
INPUT  :    1: COLUMN1                         :                2319
INPUT  :    2: COLUMN2                         : original
INPUT  :    3: COLUMN3                         : LONGVARCHAR-DESC
INPUT  :    4: COLUMN4                         :            12369440
LONGVAR:    3: PARAMETER                       :
HOSTVAR LENGTH :    131         LONGVAR LENGTH :    131
VALUE  :FIRST PART                             : 4D4D002A00000008001100FE000400
 ...   : 0000010000
INPUT  : LONG VARCHAR FROM TO POSITION :         1 -   131
SQLERRD(INDEX_3) : 1
START  :  DATE :  2004-12-20    TIME :  0015:37:00
END    :  DATE :  2004-12-20    TIME :  0015:37:00
PUTLONG: CMD   :
PARSEID:       :  000101B3 00004001 23000000 01000000
LONGVAR:    3: PARAMETER                       :
HOSTVAR LENGTH :      0         LONGVAR LENGTH :    131
START  :  DATE :  2004-12-20    TIME :  0015:37:00
END    :  DATE :  2004-12-20    TIME :  0015:37:00

SUBTRANS END
START  :  DATE :  2004-12-20    TIME :  0015:37:00
END    :  DATE :  2004-12-20    TIME :  0015:37:00

PARSEID: DROP  :  000101B3 00003D01 23000000 01000000
START  :  DATE :  2004-12-20    TIME :  0015:37:00
END    :  DATE :  2004-12-20    TIME :  0015:37:00

SQCDROPPARSID
PARSEID:       :  000101B3 00003D01 23000000 01000000

PARSEID: DROP  :  000101B3 00004001 23000000 01000000
START  :  DATE :  2004-12-20    TIME :  0015:37:00
END    :  DATE :  2004-12-20    TIME :  0015:37:00

SQCDROPPARSID
PARSEID:       :  000101B3 00004001 23000000 01000000

Isn't the longvar/hostvar length much to short for a 12MB file ??

I hope this helps to solve my problem !?

Bye
Claus




> http://sapdb.2scale.net/moin.cgi/ODBCTrace
>
>
> Regards  Thomas
>
> ----------------------------------------------
> Dr. Thomas Kötter
> SAP AG, SAP Labs Berlin
>
>
> Do you know SAP^H^H^H MaxDB ?
> www.mysql.com/products/maxdb  www.sapdb.org
>
>
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    http://lists.mysql.com/maxdb?unsub=cw@xxxxxx
>
>




-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/



--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx