473,668 Members | 2,330 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PHP with sybase or postgresql


I was wondering how to connect to postgresql and sybase databases.

I'm assuming that I need to recompile php with the flags for both

Do I also need to install sybase and postgresql themselves first?
I know that mysql support is built in, at least into php 4.

could anyone point me to a good source of info on this

Thanks
Jul 17 '05 #1
3 2140
Ilya Knizhnik schrieb:
I was wondering how to connect to postgresql and sybase databases.

I'm assuming that I need to recompile php with the flags for both

Do I also need to install sybase and postgresql themselves first?
I know that mysql support is built in, at least into php 4.

could anyone point me to a good source of info on this


The official documentation at http://www.php.net/manual/en/ref.pgsql.php
and http://www.php.net/manual/en/ref.sybase.php should explain
everything you need.

Regards,
Matthias
Jul 17 '05 #2
ljb
il***@red.seas. upenn.edu wrote:

I was wondering how to connect to postgresql and sybase databases.

I'm assuming that I need to recompile php with the flags for both

Do I also need to install sybase and postgresql themselves first?
I know that mysql support is built in, at least into php 4.

could anyone point me to a good source of info on this


For PostgreSQL, you need the pgsql extension included in PHP plus the
PostgreSQL client library libpq, the source of which is included in the
PostgreSQL distribution.

For Sybase, you have a few options, none as easy as PostgreSQL. The one I
use is FreeTDS, which provides the low-level library, along with the PHP
sybase_ct extension which is included in PHP. Others have used ODBC or some
Sybase-provided client libraries instead.
Jul 17 '05 #3
Ilya Knizhnik wrote:

I was wondering how to connect to postgresql and sybase databases.

I'm assuming that I need to recompile php with the flags for both

Do I also need to install sybase and postgresql themselves first?
I know that mysql support is built in, at least into php 4.

could anyone point me to a good source of info on this

Thanks


You might consider using a wrapper or abstraction layer to give you some
flexibility. I've had great success with ADODB
http://adodb.sourceforge.net/

Al

Adams-Blake Company, Inc.
***
JAYA123 - the web-based total-office system for the
small biz. Order entry, billing, bookkeeping, etc. for $14.95
a month. See :http://www.jaya123.com
***
Jul 17 '05 #4

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

Similar topics

0
1541
by: Josh Close | last post by:
I'm getting these errors almost every time I use sybase. I'm using it with mssql. I build it like so: python setup.py build_ext -D WANT_THREADS -D HAVE_FREETDS -U WANT_BULKCOPY python setup.py install and I'm getting these errors: Traceback (most recent call last): File "./check_mx.py", line 69, in ?
18
6752
by: David Rysdam | last post by:
What module is most recommended for accessing Sybase from Python? This one: http://www.object-craft.com.au/projects/sybase/sybase/ ? Also, is there any module that provides a generic DB API and can be hooked to both Sybase and postgresql? This (http://www.python.org/peps/pep-0249.html) looks pretty old.
0
1222
by: Dave Cole | last post by:
WHAT IS IT: The Sybase module provides a Python interface to the Sybase relational database system. It supports all of the Python Database API, version 2.0 with extensions. NOTES: This release contains a number of small bugfixes and patches received from users.
2
2897
by: eight02645999 | last post by:
hi i am writing a CGI to process some database transactions using the Sybase module. so in my CGI script, i have: .... import Sybase import cgitb; cgitb.enable(display=1 , logdir="/tmp/weblog.txt") .... ....
1
8322
by: db2sysc | last post by:
All, We have listed out the INBUILT Function differences between Sybase and DB2. Kindly provide your feedback or corrections and for CHANGES - DO WE NEED TO CODE our own UDFs?
0
1710
by: Jean-Christian Imbeault | last post by:
Does anyone know of any recent comparisons of postgres vs, Sybase ASE 12.5? I've looked around but can't find anything useful. Thanks, -- Jean-Christian Imbeault
3
3603
by: Alex Murphy | last post by:
As title, Thanks
0
1379
by: =?ISO-8859-1?Q?S=E9bastien_Sabl=E9?= | last post by:
WHAT IS IT: The Sybase module provides a Python interface to the Sybase relational database system. It supports all of the Python Database API, version 2.0 with extensions. The module is available here: http://downloads.sourceforge.net/python-sybase/python-sybase-0.38pre2.tar.gz
0
1482
by: =?ISO-8859-1?Q?S=E9bastien_Sabl=E9?= | last post by:
WHAT IS IT: The Sybase module provides a Python interface to the Sybase relational database system. It supports all of the Python Database API, version 2.0 with extensions. The module is available here: http://downloads.sourceforge.net/python-sybase/python-sybase-0.39.tar.gz
0
8459
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8374
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8791
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
8575
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
8653
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7398
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...
0
4202
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...
2
2018
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1783
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.