ID: 11655
User Update by: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: COM related
Operating system: Win NT4.0 SP6a
PHP Version: 4.0.6
Description: Ivoking COM will not work.
Thank you, you are completely right. I had a closer look at this and found the
following problem with the connection string:
To achieve a dsn-less connection, I used a valid System-DSN pointing to an empty .mdb
file. The DBQ-Attribute pointed to the actual database. This does not work under PHP,
it has to be the same datasource as in the DSN (e.g. in ColdFusion this is the only
way of creating a dsn-less connection).
To get a dsn-less connection with PHP is actually even simpler, done with this
connection string:
$myDSN = "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=c:\\test.mdb;User='root';Password='';";
(note that in my post above is a space missing, instead of
Microsoft Access Driver(*.mdb), it should read
Microsoft Access Driver (*.mdb)
-----------------------^
, which will prevent it from working correctly, too.)
Previous Comments:
---------------------------------------------------------------------------
[2001-06-27 07:12:48] [EMAIL PROTECTED]
i can't reproduce this. are you sure that your mdb is in the right place ? i get this
kind of error if the DSN is invalid.
harald
---------------------------------------------------------------------------
[2001-06-26 10:29:12] [EMAIL PROTECTED]
The exception occurs in line 5, which is
$dbc->Open($myDSN);
---------------------------------------------------------------------------
[2001-06-26 10:20:46] [EMAIL PROTECTED]
in which line does the warning occur ?
---------------------------------------------------------------------------
[2001-06-25 06:49:59] [EMAIL PROTECTED]
This does not work, but worked unchanged in PHP 4.0.4pl1
$myDSN = "DSN=dbEmpty;DBQ='c:\test.mdb';DRIVER={Microsoft Access
Driver(*.mdb)};UID='root';PW='';";
$dbc = new COM("ADODB.Connection");
$dbc->Provider = "MSDASQL";
$dbc->Open($myDSN);
Warning: Invoke() failed: Exception occurred (line $dbc->Open($myDSN); )
Setting from php.ini:
;com.typelib_file =
com.allow_dcom = On
---------------------------------------------------------------------------
Full Bug description available at: http://bugs.php.net/?id=11655
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
