Re: MDB with MS sql server

I'll take a look at SelectRowRanges. The insert_id has been fixed in cvs.

- Frank

> 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@xxxxxxxxxxxxxxx> a écrit dans le message
de
> news:20031119163618.59705.qmail@xxxxxxxxxxxxxxx
> > "Lukas Smith" <smith@xxxxxxxxxxxxxxxx> a écrit dans le message de
> > news:php.pear.general-9013@xxxxxxxxxxxxxxx
> >
> > >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 !
> >
> 
> -- 
> PEAR General Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PEAR General Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php