Re: MDB with MS sql server

"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 !

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

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