Re: COM and ADODB access
| From: | Scott Carr | Date: | Tue, 16 Apr 2002 14:26:35 +0000 |
| Subject: | Re: COM and ADODB access | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-13126@lists.php.net to get a copy of this message | ||
It may be the ADO connection with Access. I am not sure. DB_adodb is a DB
class I am writing for the Pear_DB abstraction layer.
I am attaching it to this email so everyone can look at it. At this point it is
kind of a hack. There is no capability in ADO to count the number of records
that a query produced, unless you count each record yourself which would take
too long.
Currently, there is no Transaction or nextID support, either. But, it is
working to some degree. ;-)
I can sometimes pass a long string, sometimes I can't. There doesn't appear to
be any ryme or reason at this point.
--
Scott Carr
OpenOffice.org
Whiteboard-Doc Maintainer
http://whiteboard.openoffice.org/doc/
Quoting Alan Brown <abrown@pobox.com>:
> I actually use VERY long strings to COM. Can you send me a small test case
> (some snipit from adodb.php, since I do not seem to have this file in my
> pear directory, I can only assume this is something you are writing) and I
> will trace into the source and find out what is happening and fix it if
> there is a bug or tell you what is wrong with your source otherwise.....
>
> Alan.
> ----- Original Message -----
> From: "Scott Carr" <scarr@progbits.com>
> To: "PHP Windows" <php-windows@lists.php.net>
> Sent: Monday, April 15, 2002 17:43
> Subject: [PHP-WIN] COM and ADODB access
>
>
> > I am having a problem with SQL statements passed to a COM object.
> >
> > "SELECT * FROM Reports" works fine.
> >
> > "SELECT IDCode, Report_Name, Report_Description, Report_Status FROM
> Reports"
> > blows up. I have been having this issue with 4.0.6 through 4.2.0 RC3.
> >
> > Has anybody else tried to pass semi-long strings to a COM object?
> >
> > Here is the error I get on the second select statement:
> >
> > Warning: Error in php_OLECHAR_to_char() in d:\php\pear\DB\adodb.php on
> line 191
> >
> > It's like that for every large string I pass.
> > --
> > Scott Carr
> > OpenOffice.org
> > Whiteboard-Doc Maintainer
> > http://whiteboard.openoffice.org/doc/
> >
> >
> >
> >
> >
> > -------------------------------------------------
> > This mail sent through IMP: http://horde.org/imp/
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/