ID: 9196 User Update by: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: COM related Description: Cannot create ADO objects with MDAC 2.6 I've managed to work out what was wrong - it seems that if I am using the ZendOptimiser I get problems wth COM, otherwise it works OK. Previous Comments: --------------------------------------------------------------------------- [2001-02-09 13:45:11] [EMAIL PROTECTED] The code snippet below fails on the line which sets the Active Connection of the Command Object. It works OK with MDAC 2.5 SP1, but not MDAC 2.6 - weird... <? require "adovbs.php"; $conGFA = new COM("ADODB.Connection") or die("Unable to instantiate GFA DB Connection"); $conGFA -> ConnectionString = "Provider=SQLOLEDB;OLE DB Services=0;Persist Security Info=False;User ID=UserID;Password=Password;Initial Catalog=gfa;Data Source=DBSERVER;"; $conGFA -> Open; $cmdGFA = new COM("ADODB.Command") or die("Unable to instantiate GFA DB Command Object"); $cmdGFA -> ActiveConnection = $conGFA -> ConnectionString; ?> --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=9196 -- 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]