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@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