RE: [PHP4BETA] Stored Procedures

Hi Avrum, I'll keep any future replies to this subject off this list; don't want to clutter it up with plugs. This reply speaks more to architecture than Openlink's licensing though. Bascially, with and ODBC connection between Apache, PHP and a database, with everything on the same machine, your database should experience exactly one client. If not, there is a security issue at work. In fact, I would recommend configuring your database connection in such a way that request from IP addresses other than the local machine are refused. Here is the tricky part, however - you may experience many concurrent connections with that one client. With multiple apache's delivering content, you will get multiple requests for data from the PHP engine. While this will probably not approach a 1:1 ratio of users:connections, it could theoritically approach that if you had _all_ of your resultant content stored in a database, and just filled template skeletons with pulled data. Openlink's drivers download with a free, non-expiring license that allows 2 users:10 concurrent connections. The 2 users will be more than you need, here, or allow your webserver full access, and still give you an administrative connection should it be needed. The 10 conncurrent connections, however, will be used up faster than you think. Please feel free to build it and see for yourself, but don't be surprised when you see 100 users come in and some get bounced (or forced to queue if you allow for that in your php code). Hope this helps! Best regards, Andrew ---------------------------------------------------- Andrew Hill Technical Support Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers -----Original Message----- From: Avrum Goodblatt [mailto:goodblat@sprynet.com] Sent: Friday, March 17, 2000 5:57 PM To: Andrew Hill Subject: RE: [PHP4BETA] Stored Procedures Thanks. Now how does this work when used with php? That means that my client is the same machine as the server, so I only need one client license, and since my php connections are quickly opened and closed, chances are that I could get by for a long while with the minimum number of conncurrent connections.Is all this correct or am I mistaken in something? I am downloading the evaluation package now - perhaps its explained in the docs. Send reply to: <ahill@openlinksw.com> From: "Andrew Hill" <ahill@openlinksw.com> To: "Avrum Goodblatt" <goodblat@sprynet.com> Copies to: "Php4beta@Lists. Php. Net" <php4beta@lists.php.net> Date sent: Fri, 17 Mar 2000 16:50:04 -0500 Subject: RE: [PHP4BETA] Stored Procedures > Hi Avrum, > > You should be able to do this, yes. > > > Best regards, > Andrew > ---------------------------------------------------- > Andrew Hill > Technical Support Consultant > OpenLink Software > http://www.openlinksw.com > Universal Database Connectivity Technology Providers > > > -----Original Message----- > From: Avrum Goodblatt [mailto:goodblat@sprynet.com] > Sent: Friday, March 17, 2000 4:47 PM > To: Andrew Hill > Subject: RE: [PHP4BETA] Stored Procedures > > > Does this mean that I would be able to use your driver for Access 2000 to > properly deal with cursors, and row positioning? (things which > > > > If the driver you need is not availbe from MS, you can get on at > > www.openlinksw.com > > We enforce full SQL92 compliance onto back end databases, and fully > support > > stored procedures. > > > > Best regards, > > Andrew > > ---------------------------------------------------- > > Andrew Hill > > Technical Support Consultant > > OpenLink Software > > http://www.openlinksw.com > > Universal Database Connectivity Technology Providers > > > > > > -----Original Message----- > > From: Avrum Goodblatt [mailto:goodblat@sprynet.com] > > Sent: Friday, March 17, 2000 12:57 PM > > To: Gaylord Aulke; php4beta@lists.php.net > > Subject: Re: [PHP4BETA] Stored Procedures > > > > > > We have been using stored procedures with ODBC extensively with no > problems. > > Passing variables to stored procedures however required upgrading our ODBC > > driver (under NT). If you are using NT, then you can download the newer > > driver > > from www.microsoft.com/database (or something like that). > > > > > Hi, > > > > > > did anyone manage to call a stored procedure via ODBC and read the > > > result the stored procedure produces into php variables? > > > > > > i can call the procedure and odbc_num_rows() reports that there is > > > one row in the result set but i cannot read the data. (fetch_row throws > > > an error) any ideas? > > > > > > gaylord aulke > > > agi, stuttgart, germany > > > > -------------------------------------------------- > > Avrum Goodblatt goodblat@sprynet.com (415) 9451368 > > http://home.sprynet.com/~goodblat > > > > -- > > PHP 4.0 Beta Mailing List < > > �������*�.�vQ�http://www.php.net/version4/> > > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > > For additional commands, e-mail: php4beta-help@lists.php.net > > To contact the list administrators, e-mail: php4beta-admin@lists.php.net > > > > > > > -------------------------------------------------- > Avrum Goodblatt goodblat@sprynet.com (415) 9451368 > http://home.sprynet.com/~goodblat > > > -- > PHP 4.0 Beta Mailing List <http://www.php.net/version4/> > To unsubscribe, e-mail: php4beta-unsubscribe@lists.php.net > For additional commands, e-mail: php4beta-help@lists.php.net > To contact the list administrators, e-mail: php4beta-admin@lists.php.net > -------------------------------------------------- Avrum Goodblatt goodblat@sprynet.com (415) 9451368 http://home.sprynet.com/~goodblat