Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-13 Thread Robert Twitty
ODBTP can be used for the purpose you described. Although I have not used it with file-based databases, it should not be a problem. The only requirement is that the ODBC drivers must be thread safe if it will be accessed by multiple clients. This, of course, will be the case it it is used on

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-05 Thread Maxim Maletsky
Robert Twitty [EMAIL PROTECTED] wrote... : In other words, it allows a PHP client on UNIX to access a database using the ODBC drivers installed on a Windows NT / 2000 server. It is nothing more than a middle man service for Win32 ODBC. Sounds interesting. The name of the service is

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-05 Thread Robert Twitty
The name of the service is called ODBTP (Open Database Transport Protocol), and no there is not a RFC for this protocol. Thus far, I have successfully accessed MS-SQL, Oracle and Sybase databases via ODBTP. Have Oracle ran well through it? Yes. * Supports all data types, including

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-05 Thread Maxim Maletsky
Robert Twitty [EMAIL PROTECTED] wrote... : What about RECORD type for Oracle? Objects? XMLType(s)? Have you had a chance to play with them yet? I have not tried those types (I primarilly use it for MS-SQL), however, ODBTP can be easily modified to accomadate any type. The key however

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-05 Thread Maxim Maletsky
Wez Furlong [EMAIL PROTECTED] wrote... : As for developer interest; most of the big boys are attending a conference this week/weekend, so don't be disheartened if you still haven't had much response before the next weekend. Considering the wireless network problems we are having, answering

RE: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-04 Thread Mike Robinson
Robert Twitty writes: So far 3 people have shown interest in ODBTP, however, it is the weekend. I am currently working on packaging it in a tar.gz file. If the response is low I will only release it to those who have shown an interest, and if it becomes higher than I will release it to

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-04 Thread Robert Twitty
I'd be interested in seeing more about this extension. It sounds like it could be useful. What kind of license would this stuff be released under? If it proves to be a viable DB solution, then my goal is to have it become a part of PHP. Thus, it would be under the same license as PHP. Best

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-03 Thread Robert Twitty
gt; * Designed to be as easy as possible to use with PHP How committed is your organization to supporting your selection of PHP? Have you been involved in any open source coding efforts? My organization's committment to PHP is primarily determined by me. I am the software development

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-03 Thread Wez Furlong
Hi Bob, I'm interested in this becoming more mainstream, although I personally dislike mssql; the only current alternative that works in a similar way is one of the packages that Dan mentioned (I forget which) - it was difficult to configure as it required quite a large amount of fiddling around

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-03 Thread Sander Steffann
Hi, To php-dev: I feel that Robert has had a bit of a cool reception; opensource development relies on positive feedback to make progress. Sorry that I'm late :) I too think this is a very nice extension!!! We (nederland.net, hosting provider in The Netherlands) don't need this yet, but I

[PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-02 Thread Robert Twitty
Hello (NOTE: This message was originally posted to PHP-DB, but I was told that PHP-DEV was a more appropriate place) I have been using PHP for about 9 months, and have chosen it as my primary scripting language for web applications. I have and still use ASP and JSP. IMHO, PHP is superior and

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-02 Thread Dan Kalowsky
On Saturday, November 2, 2002, at 12:38 PM, Robert Twitty wrote: its capabilities and useless in certain situations. Another alternative was to use a commercial ODBC driver management system on UNIX. Sadly, it was not in the budget for this endeavor, and the PHP odbc extensions could use

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-02 Thread Marcus Boerger
At 18:38 02.11.2002, Robert Twitty wrote: Hello (NOTE: This message was originally posted to PHP-DB, but I was told that PHP-DEV was a more appropriate place) I have been using PHP for about 9 months, and have chosen it as my primary scripting language for web applications. I have and still

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-02 Thread Robert Twitty
Hi Dan Below, I have addressed each of your comments. Keep in mind that ODBTP is not a replacement for ODBC. The motivation for ODBTP was to devise a scheme that would make it easy to keep up with Microsoft's perpetual changes in the TDS protocol. Which from my research appears to be the

Re: [PHP-DEV] ODBTP, a possible solution for MS-SQL and other databases

2002-11-02 Thread Robert Twitty
I do not like MySQL due to its simplicity and lack of relations. But i must disagree to PHP/Postgres. Postgres IS very stable and fast. Another very important thing is that any security problem found in postgres is fixed very soon. On the otherhand there is Microsoft and we have seen in the