Re: MDB with MS sql server

"Lukas Smith" <smith@backendmedia.com> a écrit dans le message de news:php.pear.general-9013@news.php.net... >Well I dont run tests on it. >Frank Kormann wrote it .. but I think he didn't go too deep into testing I >think. >Are you now using the 1.1.4RC4 version? Yes I was thinking I was able to make the driver working properly, but there is too much work to do, and I have no knowledge in MS sql server. With the included diff file to mssql.php, I succeded : - to use MDB Manager to create tables. Database creation does not work, but this is not the driver fault, I simply did not found how to allow this in mssql server. - run queries that do not modify the database Now I run into this error when I want to insert rows : Fatal error: Call to undefined function: mssql_insert_id() in c:\Php\PEAR\MDB\mssql.php on line 1162 The script use 'mssql_insert_id()' function that does not exist in native php functions ! 336a337 > $this->selected_database = $this->database_name; 424a426 > } 428c430 < $this->affected_rows = mssql_affected_rows($this->connection); --- > $this->affected_rows = mssql_rows_affected($this->connection); 700d701 < } 701a703 > 731c733 < return((isset($field["length"]) ? "$name VARCHAR (".$field["length"].")" : "$name TEXT").(isset($field["default"]) ? " DEFAULT ".$this->GetTextFieldValue($field["default"]) : "").(isset($field["notnull"]) ? " NOT NULL" : " NULL")); --- > return((isset($field["length"]) ? "$name VARCHAR (".$field["length"].")" : "$name TEXT").(isset($field["default"]) ? " DEFAULT ".$this->GetTextValue($field["default"]) : "").(isset($field["notnull"]) ? " NOT NULL" : " NULL")); 1393c1395,1396 < ?> \ No newline at end of file --- > ?> > -- Thierry Bothorel