Re: MDB with MS sql server

Here is the result of test.php with my modified mssql.php file : Testing mssql://sa:@localhost/driver_test mdb_manager_testcase : Starting testcreatedatabase ... Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in c:\Php\PEAR\MDB\mssql.php on line 129 PEAR-ErrorMDB Error: Query: Could not query a Microsoft SQL server: [nativecode = -1 - Cannot drop the database 'driver_test', because it does not exist in the system catalog.]Test passed mdb_manager_testcase : Starting testupdatedatabase ... Test passed mdb_api_testcase : Starting testconnect ... Test passed mdb_api_testcase : Starting testgetoption ... Test passed mdb_api_testcase : Starting testsetoption ... Test passed mdb_api_testcase : Starting testloadmanager ... Test passed mdb_api_testcase : Starting testquery ... Test passed mdb_api_testcase : Starting testfetchinto ... Test passed mdb_api_testcase : Starting testnumcols ... Test passed mdb_api_testcase : Starting testsingleton ... Test passed mdb_usage_testcase : Starting teststorage ... Test passed mdb_usage_testcase : Starting testbulkfetch ... Test passed mdb_usage_testcase : Starting testpreparedqueries ... Test passed mdb_usage_testcase : Starting testmetadata ... Test passed mdb_usage_testcase : Starting testnulls ... Test passed mdb_usage_testcase : Starting testescapesequences ... Test passed mdb_usage_testcase : Starting testranges ... Failure 1 : This database does not support SelectRowRanges expected true, actual false There were 1 failures for testranges There were 0 errors for testranges mdb_usage_testcase : Starting testsequences ... Fatal error: Call to undefined function: mssql_insert_id() in c:\Php\PEAR\MDB\mssql.php on line 1162 -- Thierry bothorel "Thierry Bothorel" <thierry.bo@netcourrier.com> a écrit dans le message de news:20031119163618.59705.qmail@pb1.pair.com... > "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 ! >