ODBTP & MSSQL (was Re: [PEAR-DEV] ODBTP PECL Extension - Evaluation)

Hi Hans ODBTP provides full support for SQL Server 2000. It allows you to prepare queries like {? = call AddName( ?, ? )}, and actually retrieve any output parameters. It also completely supports UNICODE fields ntext and nvarchar by processing them using UTF-8. This allows you to use the "FOR XML" T-SQL consttruct available in SQL 2k. Click on the "features" and "examples" links on the ODBTP home page (http://odbtp.sourceforge.net). I followed the sybase/mssql function naming and parameter scheme whenever it was possible. I chose not to alias the extension prefix, i.e., mssql_ -> odbtp_, so that it would not interefere with existing applications while people are testing it. Another peculiarity about the odbtp extension is that while it uses ODBC it behaves more like the mssql extension than it does the odbc extension. As a result I will probably modify it to take over the mssql extension's namespace. -- bob On Wed, 23 Apr 2003, Hans Lellelid wrote: > > No & no :-) So that makes sense. Yes, odbc extension w/ PHP has been > very frustrating. I'm very eager to see a new extension that will talk > w/ SQL Server (2k?) on Windows. Is it / will it be compatible with the > native mssql library (I mean in terms of namespace) in PHP? > > Cool! > > Hans > > Robert Twitty wrote: > > >Hi Hans > > > >I did look at Easysoft, and you are correct, I did want an open source > >solution. Also, unless Easysoft provided a PHP extension with their > >product, I could not use it to do what I needed because of the limitations > >of the odbc extension included with PHP. > > > >Do you invoke stored procedures with paramters, and / or use UNICODE data > >in your applications? > > > >-- bob > > > >On Wed, 23 Apr 2003, Hans Lellelid wrote: > > > > > > > >>Robert Twitty wrote: > >> > >> > >> > >>>ODBTP was primarily designed to provide the best access to MS SQL > >>>using the MS SQL Server ODBC driver. The fact that it can be used to > >>>connect to other Win32 ODBC accessible databases was secondary for me. > >>>The problem I had with the sqlralay and odbc extensions was that they were > >>>"Jack of all Trades" solutions. On the other hand, the goal for ODBTP is > >>>to be the "Master" solution for accessing MS SQL databases from PHP > >>>regardless of the underlying platform. > >>> > >>> > >>> > >>> > >>Did you look also at Easysoft's ODBC-ODBC bridge? -- anyway, if this is > >>/ is going to be an open-source product, I think it's great! :-) > >>Easysoft is not at all free. I've used Easysoft for awhile, but have > >>never been all that happy with it. (It just isn't as transparent a > >>'passthru' as I would have thought/hoped.) > >> > >>Hans > >> > >> > >> > >> > > > > > > > > > > >