Re: DB_Data_Object - cant create Objectfiles

I had a quick look at the mssql driver - it appears to do SELECT * FROM {tablename} to get a single row to find out the types of the columns. I dont know mssql well enough to say if it is possible to simplify this (eg. by limiting or requesting a single row somehow..) - or if there is a better way to read the table structure - by doing something with syscolumns ??? Regards Alan Barry Steele wrote:

Hi, I've just started on a project on mssql/php/apache and have been as far as getting PEAR::DB running against the database and have been trying to user createTables.php to bild the dataobjects. I'm getting the following error at the command line: E:\bin>Membership.bat E:\bin>C:\PHP\PEAR\DB\scripts\db_dataobject_createTables e:/www/include/membersh Content-type: text/html X-Powered-By: PHP/4.3.4 CREATING FOR mssql://user:password@192.168.0.200/Membership PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\PHP\PEAR\pear\DB\mssql.php on line 480 <br /> <b>Fatal error</b>: Maximum execution time of 30 seconds exceeded in <b>C:\PHP\PEAR\pear\DB\mssql.php</b> on line <b>480</b><br /> PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\PHP\PEAR\pear\PEAR.php on line 655 <br /> <b>Fatal error</b>: Maximum execution time of 30 seconds exceeded in <b>C:\PHP\PEAR\pear\PEAR.php</b> on line <b>655</b><br /> I'll be looking more deeply into it later on tonight, but if anyone know what it is quickly, I would be extremely happy and thankful. Barry

        Barry Steele
        hpfm solutions pty ltd
        mob: 0413947980
        fax:  0299817727
        mailto:: barry@hpfm.com.au