473,799 Members | 2,665 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

from PHP -> db2_connect() Undefined Function

I'm trying to access a Cloudscape/Derby database
via PHP and am using the IBM DB2 Lite client
which I have installed.

As soon as I call db2_connect(... ) in the
php code, I get a db2_connect Undefined function error message,
so it is not finding this function in the IBM DB2 stuff.

I've verified that the Apache Server, PHP
and DB2 and the config and ini files that go
with them are all set up OK.

I also made sure that my php.ini has a line that says
extension=php_i bm_db2.dll
and that the php_ibm_db2.dll exists
in the c:\php\ext directory
(I also copied php_ibm_db2.dll to
c:\windows\syst em32 just to be sure).

BUT.. I notice that in my c:\Program Files\
IBM\SQLLIB\
directory where DB2 lite client is installed,
there is NO include subdirectory.

Is that what I'm missing and if so,
how do I get it?

Thanks
Jim
Oct 31 '05 #1
3 15176
OK, I can connect to the database OK
after properly configuring my XP ODBC connection
from administrator tools - but
it only works if I use "odbc_conne ct" instead of
"db2_connec t".

Any attempt to use a function starting with db2_
fails with "undefined function" message.

Does this mean the PHP 5 that I installed
did not have support for DB2 compiled in?

or...

Can I tell from my php_info() if the PHP 5 that I installed
has compiled in support for db2??

Thanks
J
"Musashi" <mu*****@okogyo .net> wrote in message
news:7At9f.1293 2$gj1.713@fed1r ead05...
I'm trying to access a Cloudscape/Derby database
via PHP and am using the IBM DB2 Lite client
which I have installed.

As soon as I call db2_connect(... ) in the
php code, I get a db2_connect Undefined function error message,
so it is not finding this function in the IBM DB2 stuff.

I've verified that the Apache Server, PHP
and DB2 and the config and ini files that go
with them are all set up OK.

I also made sure that my php.ini has a line that says
extension=php_i bm_db2.dll
and that the php_ibm_db2.dll exists
in the c:\php\ext directory
(I also copied php_ibm_db2.dll to
c:\windows\syst em32 just to be sure).

BUT.. I notice that in my c:\Program Files\
IBM\SQLLIB\
directory where DB2 lite client is installed,
there is NO include subdirectory.

Is that what I'm missing and if so,
how do I get it?

Thanks
Jim

Nov 1 '05 #2
Ah yes... the setting in the apache .conf file
that says phpIniDir is at C:\PHP.

I should have known.

db2_ funcs working fine now.

J

"Musashi" <mu*****@okogyo .net> wrote in message
news:FGO9f.1308 7$gj1.3759@fed1 read05...
OK, I can connect to the database OK
after properly configuring my XP ODBC connection
from administrator tools - but
it only works if I use "odbc_conne ct" instead of
"db2_connec t".

Any attempt to use a function starting with db2_
fails with "undefined function" message.

Does this mean the PHP 5 that I installed
did not have support for DB2 compiled in?

or...

Can I tell from my php_info() if the PHP 5 that I installed
has compiled in support for db2??

Thanks
J
"Musashi" <mu*****@okogyo .net> wrote in message
news:7At9f.1293 2$gj1.713@fed1r ead05...
I'm trying to access a Cloudscape/Derby database
via PHP and am using the IBM DB2 Lite client
which I have installed.

As soon as I call db2_connect(... ) in the
php code, I get a db2_connect Undefined function error message,
so it is not finding this function in the IBM DB2 stuff.

I've verified that the Apache Server, PHP
and DB2 and the config and ini files that go
with them are all set up OK.

I also made sure that my php.ini has a line that says
extension=php_i bm_db2.dll
and that the php_ibm_db2.dll exists
in the c:\php\ext directory
(I also copied php_ibm_db2.dll to
c:\windows\syst em32 just to be sure).

BUT.. I notice that in my c:\Program Files\
IBM\SQLLIB\
directory where DB2 lite client is installed,
there is NO include subdirectory.

Is that what I'm missing and if so,
how do I get it?

Thanks
Jim


Nov 4 '05 #3

Musashi wrote:
Ah yes... the setting in the apache .conf file
that says phpIniDir is at C:\PHP.

I should have known.


Yes, the "Microsoft Way" says it "should be" on C drive.

But I say NO!

I have a method that installs Perl, PHP, Apache and mySQL on a PC in 20
minutes, backs up in 3 and restores in 5.

And not a single file in in the WINDOWS directory or C root or key in
the registry.

web.torres.ws/walters_way

If anyone is interested.

Walter

Nov 4 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
11311
by: Bhavin G | last post by:
Hi there , I am pretty new at javascripting and i am having this huge problem. I am using asp.net and C# webapplication. In my asp.net aspx file I have a place holder for taking an html table dynamically. I create a html table Time | Data1 | Data2 | Data3 type, in which the columns are not fixed, hence i am building it dynamically in c# code. now after i have the html table in the webpage, I want to give user to
13
3368
by: david | last post by:
Hi, I have some problems to link a simple hello world program using g++ (version 3.2.3 or 3.3) and dinkumware 402. //hallo world... #include <iostream> main () { std::cout << "bla" << std::endl; }
21
3993
by: Michael Bierman | last post by:
Please forgive the simplicy of this question. I have the following code which attempts to determine the color of some text and set other text to match that color. It works fine in Firefox, but does nothing in IE. I'd be greatful for any assistance. Also, if I will have problems the code on Opera or Safari, I'd appreciate any pointers--I don't have a Mac to test Safari. THanks very much, Michael
1
3331
by: john | last post by:
Relatively new to C coding, so any help would greatly be appreciated. I'm having problems try to return my string array from my parsing function. When I do a printf I am getting the correct value for my first element but my subsequent printf's will return garbage. Can someone let me know what I am doing wrong. Thanks in advance. -jlewis
17
3353
by: yb | last post by:
Hi, Looking for clarification of undefined variables vs. error in JavaScript code. e.g. <script> alert( z ); // this will be an error, i.e. an exception </script>
3
789
by: Michael Sgier | last post by:
Hi i get thousands of messages like below. How shall i resolve that? Thanks Mcihael Release/src/Utility/RawImage.o: In function `CMaskImage::CMaskImage(int, int, char const*)': RawImage.cpp:(.text+0x15dc): undefined reference to `popen(PFS*, char const*)'
45
4864
by: VK | last post by:
(see the post by ASM in the original thread; can be seen at <http://groups.google.com/group/comp.lang.javascript/browse_frm/thread/3716384d8bfa1b0b> as an option) As that is not in relevance to "new Array() vs " question or to the array performance, I dared to move it to a new thread. Gecko takes undefined value strictly as per Book 4, Chapter 3, Song 9 of Books of ECMA :-)
2
2094
by: merrittr | last post by:
I have a small program to read data from some data files , in it I use string types to build the data file name but when I try to compile it I get: (see code below error) root@rob-laptop:/home/rob/pankaj# gcc ptcllocate.cpp /tmp/ccg9j6Mi.o: In function `main':ptcllocate.cpp:(.text+0x99): undefined reference to `std::allocator<char>::allocator()' :ptcllocate.cpp:(.text+0xb9): undefined reference to `std::basic_string<char,...
148
5609
by: onkar | last post by:
Given the following code & variable i . int main(int argc,char **argv){ int i; printf("%d\n",i); return 0; } here i is allocated from bss or stack ?
2
9042
by: joelkeepup | last post by:
Hi, I made a change this morning and now im getting an error that says either "a is undefined or null" or "e is undefined or null" the microsoft ajax line is below, I have no idea how to figure this problem out. Any suggestions? thanks Joel
0
10495
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10269
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10248
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9085
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7573
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6811
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5469
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4148
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3764
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.