Re: [PHP-DB] Connectivity to AS/400
I'm going to be trying to connect to the native DB2 database in a AS/400 So far thats all I know about the IBM side. Can someone give me a short update on what options I have ? - JDBC - exec an external program. - unixODBC ...etc. - PHP with native ibm db2 support I have successfully connected built a front end application to a AS/400 using the 3rd option. So can help there. marios moutzouris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Connectivity to AS/400
There's been a lot of talk about this recently. Check the archives for the last 2 months, and PHPBuilder.com Last I heard, you needed DRDA(DB2 Connect) installed, as well as the runtime client. Also on the client - DB2 Application Development package. Use this to compile PHP --with-ibm-db2=path. Make sure you run the CATALOG commands on the client so that it can find the AS400 database. 'Luck! -Szii At 10:41 AM 2/4/2001 -0800, Pete Lancashire wrote: I'm going to be trying to connect to the native DB2 database in a AS/400 So far thats all I know about the IBM side. Can someone give me a short update on what options I have ? TIA !!! -pete -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle TNS problems with PHP4?
Hi Mark, I run Oracle 8i with apache and PHP 4 on about 6 different machines , all connect to a remote DB and i have no problems @ all. Regards Steve Farmer At 8:29 AM -0600 2/2/01, Mark Farver wrote: I am running Oracle 8.0.5 Net8 drivers on a Win95 system using Apache and PHP4.04pl1. I'm getting consistent TNS No service errors from PHP using all three methods of accessing Oracle (oracle,oci,odbc). ODBC works fine in other apps, and the SQLPlus and tnsping work fine (even when called from a passthru(), so its not environment related). I've noticed a large number of bug reports on this.. but no answers (other than modifing the ORACLE_SID, and ORACLE_HOME environment vars, and that only works if the DB is local). I'm trying to nail down how widespread this problem is... How many of you have Oracle working with PHP4? What version of the Oracle drivers? Are you accessing a local db or a remote one? Did you have to tweak any settings to make it work? Windows or Unix? Thanks Mark -- "The greatest dangers to liberty lurk in insidious enroachment by mean of zeal, well-meaning but without understanding." -- Justice Louis O. Brandeis, Olmstead vs. United States -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- --- "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] How to make $1,000,000 by selling to newcomers on the net
Dear [EMAIL PROTECTED], {Thank you - you have been automatically removed from all future mailings.} Every month over 1,000,000 new commerce web-sites join the internet. Newcomers to the Net who need your help. The question is, how do you trace them, and sell them your Internet Program? In fact, there is a place ... a main gate... a "newbie" lounge where most newcomers gather, to establish a web-based home business. I can show you where they are! None of the Marketing Gurus can tell you where to reach these people, I'll be glad to show how you can. Send an email with "booklet" in the subject field to [EMAIL PROTECTED] and I will send you a 30 page FREE booklet that will explain most of the the details. I'm looking forward to hearing from you soon. Best Regards Chris Moore {Thank you - You have been automatically removed from all future mailings.} -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Connection closing problem!
Hi, Does anyone know of or have a problem that means that the HTML server will not receive the message back from the MySQL server to say close the connection. The two servers are on two seperate machines. The html server is Apache using the PHP scripting language. The error messages I am getting, not so much error messages but messages, when I do a netstat on the html machine state that alot of the sql connections are time_wait or close_wait. This should cause no problem I here you say but when the majority of the html server connections are on time_wait or close_wait then the site starts to slow right down. And eventually cause database server busy errors for users. On the SQL server the netstat results appear to be fine with the majority of them being Established. Can any shed some light on this problem or even tell me of a way to fix it. If any questions about the problem need to be asked I will try and answer them. Thanks in advance. Drew Andrew Toussaint Richardson-Shaw Pty Ltd [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] newbie question
Hi Lisa, Can search engines index any HTML pages that have .php as its extension (any .php pages without a '?' or '' in the URL) ? For example: http://www.blablabla.com/blabla.php Thanks, Lisa E yes they can, but my experience is, that most search engine robots do _not_ index pages ending in .php and .php3 due to their dynamic nature (please correct me or give me a hint how to change this). We had to change the extensions to .html to avoid being not indexed by search engines. Hope this helps Victor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Remote Oracle Connection
Am I blind? Or is there no support with the regular oracle functions to connect to a database that is hosted on another machine? The manual has this: $conn = Ora_Logon(username, password); but I don't see anywhere to put the host string. - Doug Schasteen
Re: [PHP-DB] db2 with php
Well, if it says that it's looking for it in /etc/httpd/modules then it's obviously not looking in /home/db2inst1/sqllib/lib, eh? Try a symlink... "ln -s /home/db2inst1/sqllib/lib/libdb2.so.1 /etc/httpd/modules/libphp4.so/libdb2.so.1" Or copy the library. Or I think you can add a line into /etc/ld.so.conf too. -Szii At 11:08 PM 2/4/2001 -0500, Chris Book wrote: Hello, I've installed db2 and created the default instance at /home/db2inst1/. PHP is compiled with the --with-ibm-db2 option, however when I try to start apache I get the message: "Cannot load /etc/httpd/modules/libphp4.so into server: libdb2.so.1: cannot open shared object file: No such file or directory" when I try to load the php4 module. libdb2.so.1 exists in /home/db2inst1/sqllib/lib/ so I'm not sure why php can't find it. Can anyone help me with this? Thanks, Chris Book [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] RESEND - php class to C struct interface possible?
Hi all, Thought I would try sending this again - didn't get a reply last time - guess I'll give up if this attempt doesn't get a reply . . I've just subscribed and haven't even got any mail from the list yet so I hope this isn't a dumb question . . The php xBase interface is very basic so: We have an existing (Linux RH6.2) system that has some conventional dumb terminal C programs that have access to a set of CodeBase (xBase) tables through a set of functions that I have written (eg putDBFcchq, getDBFmclm, topDBFest, etc). The applications pass the address of a conventional C struct and the functions do their job talking to the tables and pass back data in the struct. The question is . . can I make use of these functions somehow from my html/php setup? eg Could I produce a little C program that would accept input of a class address from php somehow and then use the appropriate C function to talk to the tables and then pass data back to the php class? Any other way of doing what I want? Thanks, Phil. - Philip Rhoades Pricom Pty Limited (ACN 003 252 275) GPO Box 3411 Sydney NSW 2001 Australia Mobile: +61:0411-185-652 Fax: +61:2:8923-5363 E-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]