Sorry, the attachment didn't work right.
The DSN structure is as follows:
adodb:///Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\path\\to\\database.mdb
adodb:///Data Source={ODBC DSN}
Everything after the last / is considered the ADO Connection string.
--
Scott Carr
OpenOffice.org
Whiteboard-Doc Maintainer
http://whiteboard.openoffice.org/doc/
Quoting Scott Carr <[EMAIL PROTECTED]>:
> 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 <[EMAIL PROTECTED]>:
>
> > 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" <[EMAIL PROTECTED]>
> > To: "PHP Windows" <[EMAIL PROTECTED]>
> > 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/
>
> --
> 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/
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
