Hi Tim At this point I have not received a response in regards to this request. I created ODBTP to provide the easiest and most complete access to MS SQL Server using PHP. Whilw it is similar to an ODBC-ODBC bridge, like the product from EasySoft, it is more like an ODBTP-ODBC bridge. Working directly with the ODBC API can be cumbersome and limiting when it comes to writing a driver for a scripting language. So, I created an API to facilitate the writing of a database driver for scripting languages like PHP and Perl.
Because my interest was only MS SQL Server, I primarily created ODBTP to support PHP's mssql extension, and not its odbc extension. The fact that it provides good support for other Win32 ODBC accessible databases was mostly a side effect. My personal feeling is that a DBD::ODBTP driver will provide more capabilities than the DBD::ODBC driver using an ODBTP-based ODBC driver. It probably would also be faster to write a DBD::ODBTP driver, but I do not know enough about Perl to be sure this is correct. It was the case for PHP. -- bob On Sun, 1 Feb 2004, Tim Bunce wrote: > Robert, did anything come of this? > > And/or have you thought about providing an ODBC driver interface > so it could be used via any unix ODBC driver manager? > (And thereby DBD::ODBC for Perl.) > > Tim. > > On Tue, Dec 02, 2003 at 10:27:09AM -0500, Robert Twitty wrote: > > Hello > > > > I created an open source solution that allows you to remotely connect to > > any Win32 ODBC accessible database from any platform. It is called ODBTP. > > Information about it can be found at http://odbtp.sourceforge.net. It was > > primarily designed to provide complete access to MS-SQL databases from > > UNIX platforms like Solaris, Linux and Mac OS X, becaus there were no > > adequate open source solutions for this purpose. > > > > Because I am an extensive user of PHP, I created a PHP extension for > > ODBTP. It has proven to be a solid solution, and is very fast. In fact, > > one user said the PHP/ODBTP solution was faster than the Perl/ODBC > > solution. It is also faster and more capable than FreeTDS-based > > solutions. > > > > Now, the reason why I am here is because several requests have been made > > for a DBD::ODBTP perl interface. Unfortunately, I have very little > > experience with perl, and have absolutely no idea about DBD driver > > creation. So, I was wondering if there is anyone who would be willing to > > take a look at ODBTP, and create one for this project. I am currently > > working on ODBTP 1.1, and that plus my other obligations does not allow > > me enough time to go through the perl learning curve and development > > process. > > > > -- bob > > >
