Re: [PHP-DB] Connectivity to AS/400

2001-02-04 Thread Marios Moutzouris

 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

2001-02-04 Thread szii

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?

2001-02-04 Thread Steve Farmer

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

2001-02-04 Thread 75423000

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!

2001-02-04 Thread drew

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

2001-02-04 Thread Victor Foitzik

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

2001-02-04 Thread Doug Schasteen

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

2001-02-04 Thread szii

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?

2001-02-04 Thread Phil Rhoades

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]