Re: [PHP-DB] IBM DB2 connectction problems

2001-04-06 Thread Dan Scott 

I think it's more likely that you haven't sourced the 
/home/db2inst1/sqllib/db2profile script in whatever wrapper script starts 
up Apache for you. Add the following line to the top of 'apachectl' or 
'/etc/rc.d/init.d/httpd' to set up the DB2 environment variable before you 
start your webserver:

. /home/db2inst1/sqllib/db2profile

Dan

ManieQ wrote:

 OK, here are some important details about my system:
 
 1. Linux (Mandrake 7.2)
 2. Apache 1.3.14 (from distribution)
 3. jre118 (rpm, IBM version)
 4. IBM DB2 V7.1
Installed with default logins, directories, etc.
 5. Added '/usr/IBMdb2/V7.1/lib' to '/etc/ld.so.conf'; 'ldconfig' executed
 6. PHP 4.0.3pl1
From source rpm, but compiled manually (not rpm build).
I used '--with-ibm-db2' option and also some others like
 '--with-apxs --with-ldap' etc.
 7. Modified apache conf to use PHP.
 
 I'm sure libdb2.so is used, because when I remove (5) line from
 'ld.so.conf' I cannot start apache (missed library). Also tried
 '/home/db2inst1/sqllib/lib'
 - no result. Tried to start apache as db2inst1 user (http.conf - User)  -
 still
 nothing.
 
 So, I still think about DB2 version incompatibilities.
 
 
 
 


-- 
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] IBM DB2 connectction problems

2001-03-13 Thread Chris Book 

If you're running off a unix platform, did you bind your database to CLI?
I'm assuming you're trying to connect with CLI and not ODBC (ie you compiled
with --with-ibm-db2)

Chris

-Original Message-
From: ManieQ [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 7:07 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] IBM DB2 connectction problems


hello,

 $i = odbc_connect( "sample", "db2inst1", "ibmdb2" );
I changed, but got same (= none) result.

 Please provide more detailed information on the SQL error and SQL state.
 Otherwise it is not really easy to tell, what the problem is.
Well, as I posted, my SQL error is null and state is random/accidental
string.

I wonder if it is a version problem (I use db2 v7.1 - perhaps some api
changes
were made in this release?).

ManieQ




-- 
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] IBM DB2 connectction problems

2001-03-13 Thread ManieQ 

OK, here are some important details about my system:

1. Linux (Mandrake 7.2)
2. Apache 1.3.14 (from distribution)
3. jre118 (rpm, IBM version)
4. IBM DB2 V7.1
   Installed with default logins, directories, etc.
5. Added '/usr/IBMdb2/V7.1/lib' to '/etc/ld.so.conf'; 'ldconfig' executed
6. PHP 4.0.3pl1
   From source rpm, but compiled manually (not rpm build).
   I used '--with-ibm-db2' option and also some others like
'--with-apxs --with-ldap' etc.
7. Modified apache conf to use PHP.

I'm sure libdb2.so is used, because when I remove (5) line from 'ld.so.conf'
I cannot start apache (missed library). Also tried
'/home/db2inst1/sqllib/lib'
- no result. Tried to start apache as db2inst1 user (http.conf - User)  -
still
nothing.

So, I still think about DB2 version incompatibilities.




-- 
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] IBM DB2 connectction problems

2001-03-12 Thread Helmut Tessarek 

Hi,

It should read:

$i = odbc_connect( "sample", "db2inst1", "ibmdb2" );

Please provide more detailed information on the SQL error and SQL state.
Otherwise it is not really easy to tell, what the problem is.

ManieQ wrote:

 $i = odbc_connect ("PROTOCOL=TCPIP; SERVERNAME=jajo.tpi.pl;
 SERVICE=50002; DATABASE=SAMPLE", "db2inst1", "ibmdb2" );

 I receive:

 Warning:  SQL error: , SQL state czen?L@Polaczen in SQLConnect in
 /home/manieq/web/db21.php on line 5

--

--- Helmut NoCarrier Tessarek --- [EMAIL PROTECTED] ---

  IBM Certified Solution Expert
 Microsoft Certified Systems Engineer  (MCP, MCP+I, MCSE)
 Karmarschgasse 53/1/3/11, A-1100 Vienna, Austria

- http://www.evermeet.cx -



--
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]