472,983 Members | 2,211 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,983 software developers and data experts.

Need a database connector in PHP? Might not need to recompile.

I just found out from someone named Frank M. Kromann in one of the
other PHP forum websites that I don't have to recompile PHP on Linux
in order to add a database connector. I've been pulling my hair out on
this issue for several days now, so I wish to publicly thank Frank M.
Kromann, whereever he is. He didn't leave a valid reply email to me,
but he's alright in my book.

Let's say you have a beautiful Linux and PHP install. Everything is
working just right for you with PostgreSQL and MySQL, and now you have
some request from management to connect something like MSSQL, but you
find out that your install of Linux doesn't come with that connector.
My install, RH9, didn't. I had already written several pages of code
with my PHP, and I didn't want to risk it by reinstalling PHP and

So, I got FreeTDS downloaded, installed properly, and connected via
its tsql test tool (/usr/bin/tsql) to my MS SQL Servers. Now all I had
to do was make Apache and PHP recognize it.

Frank said that all I need to do is download the PHP source, then do:

../configure --with-mssql,shared

This creates an mssql.so file, he said. Then, he said to copy this to
the PHP extension dir. To find out where that is, just look for
mysql.so or pgsql.so on your hard drive if you already have PHP
connecting to MySQL or PostgreSQL. Or, look for imap.so.

Next, he said I have either the choice of editing my PHP.INI file, or
use the dl() function at the top of a page in order to mount this .so
file when I need it, making the mssql_* API available within PHP.

And that's it. Now all I have to do is test his process out. I'm going
to need to get the source for PHP version 4.2.2 (that's what I have
and rely on right now with RH9)...stay tuned...
Jul 17 '05 #1
0 2741

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

Similar topics

by: lawrence | last post by:
I've been bad about documentation so far but I'm going to try to be better. I've mostly worked alone so I'm the only one, so far, who's suffered from my bad habits. But I'd like other programmers...
by: Ruud vd Velden | last post by:
Hello, We're using Office XP on Windows 2000 SP4. After installing the Oracle Connector for Outlook the following problem occurs: Emails sent by Outlook, in HTML format, do have a strange...
by: Sam Malone | last post by:
I am trying to get details from a database. I really want to use only native VS.NET managed code "stuff" (just cuz I want to) and avoid any interop stuff. So, I'm trying to do this without using...
by: JJ | last post by:
Looking for a database for the backend to my e-commerce web site that doesn't cost the earth. Planned on using mySQL but I gather that there is no connector compatible with asp 2.0 available...
by: mike | last post by:
I help manage a large web site, one that has over 600 html pages... It's a reference site for ham radio folks and as an example, one page indexes over 1.8 gb of on-line PDF documents. The site...
by: mike.hudson | last post by:
I'm looking for an example of how to call a SAP RFC from within a C# program. If I have a function called "MyFunction" and it takes 1 input parameter and returns one output parameter (a table) how...
by: arasub | last post by:
ep 20, 2007 11:25:57 AM org.apache.catalina.core.AprLifecycleListener lifecycleEvent INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found...
by: eggy524 | last post by:
Hi, I am quite new to C# an am wanting to build a small database application. The database will be stored remotely in MySQL and the program will just be able to perform simple querys to the...
by: yoach | last post by:
i dont the prpopties file withe db2 is this ok:? # The target database platform. torque.database = db2 # The target package to put the generated classes in. torque.targetPackage =...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

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.