Stack Overflow
Stack Overflow

Questions tagged [mdb2]

A database abstraction layer for PHP.

At the time of this writing, the last stable version was released on 2007-05-03 and the last beta version on 2012-10-29.

A better alternative is –the native since PHP 5.1.0– PDO

PEAR MDB2 is a merge of the PEAR DB and Metabase php database abstraction layers.

It provides a common API for all support RDBMS.

Among other things MDB2 features:

  • An OO-style query API
  • A DSN (data source name) or array format for specifying database servers
  • Datatype abstraction and on demand datatype conversion
  • Portable error codes
  • Sequential and non sequential row fetching as well as bulk fetching
  • Ability to make buffered and unbuffered queries
  • Ordered array and associative array for the fetched rows
  • Prepare/execute (bind) emulation
  • Sequence emulation
  • Replace emulation
  • Limited Subselect emulation
  • Row limit support
  • Transactions support
  • Large Object support
  • Index/Unique support
  • Module Framework to load advanced functionality on demand
  • Table information interface
  • RDBMS management methods (creating, dropping, altering)
  • Full integration into the PEAR Framework
  • PHPDoc API documentation

Currently supported RDBMS:

  • MySQL
  • MySQLi (PHP5 only)
  • PostgreSQL
  • Oracle
  • Frontbase (unmaintained)
  • Querysim
  • Interbase/Firebird (PHP5 only)
  • MSSQL
  • SQLite
93 questions
0
votes
1 answer

MDB2 pear windows installation

I am looking for a guide for installing and using MDB2 pear on my system. i use iss7 and windows vista.... I read the manual but I didn't understand too much...
saeed
  • 81
  • 1
  • 4
0
votes
0 answers

Php MDB2 prepared statements not working

I am using Php MDB2 data abstraction layer and trying insert data into the MySql database using prepare/bind. …
Daksh B
  • 269
  • 1
  • 8
  • 45
0
votes
2 answers

error -2147467259 (80004005) .net mdb

I am calling a vb.net function of a dll from below VBA code in MDB. I am calling Get_GDW_data_final sub from immediate Window. Public Sub Get_GDW_data_final() Dim r As New Get_GDW_Data.GDW MsgBox r.DetailedWork() End Sub I have created…
rachit jani
  • 11
  • 2
0
votes
1 answer

JMS, MQ-Series, MQ-Queue, MDB

I started with learning EJB's and in sequence read: Session Beans, and MDB's. When i wanted to implement some programs for MDB's, I decided to google and download some open source software. However in this, i got lot of terminologies, and now i am…
CuriousMind
  • 8,301
  • 22
  • 65
  • 134
0
votes
1 answer

CakePHP migrate MDB2 error with no clue

I've downloaded a website that uses CakePHP 1.3.16 and have a bunch of .yml files for database creation and setting up. When I perform: $../cake/console/cake migrate I get a MDB2 ERROR but without any further clue so it's very difficult for me to…
theme
  • 1,097
  • 2
  • 9
  • 13
0
votes
1 answer

Pear MDB2 class and raiserror exceptions in SQL Server

in SQL Server it's possible to raise an error with raiserror(). I want to use a severity, which doesn't interrupt the connection. This error is raised in a stored procedure. In SQL Management Studio all is fine and I get my error code when executing…
user332194
  • 11
  • 3
0
votes
3 answers

MDB2, Pear, Mysql error

I have PEAR, MDB2 and Mysql Driver installed however I keep getting: Fatal error: Call to undefined function: MDB2_Driver_mysql::_isNewLinkSet(). in /home/********/PEAR/MDB2.php on line 1937. The Server is CentOS I am stuck, any help would be…
Kyle Hudson
  • 898
  • 1
  • 14
  • 26
0
votes
1 answer

OLEDB to MDB on shared location

Ok, this time I've created an app to write and update an MDB DB using OLEDB. the MDB reside in a shared folder on the network which my account has access to. every function works ok on my local machine when I test (add, edit and delete). But when I…
Ammar Ali
  • 77
  • 1
  • 3
  • 15
0
votes
1 answer

MDB2 With SQL Express 2008

So basically here's my problem. I'm looking for a solution to allow us to connect with SQL Express 2008, while still using MDB2 as our database abstraction layer. I need something like this, mainly because we still need to be able to use MySQL and…
Narcissus
  • 3,144
  • 3
  • 27
  • 40
0
votes
3 answers

Call to undefined method MDB2_Error::setFetchMode()

I am using PEAR's MDB2 to connect to my MySQL DB's. I have never had a problem before but this particular host is causing me problems. At first I thought it was the user credentials but I have tested on the same file with a standard MySQL code to…
Jamie Hutber
  • 26,790
  • 46
  • 179
  • 291
0
votes
1 answer

Complex SQL query... names of returned variables

Excuse me for what I'm sure is an elementary question for most of you, but I have an issue with table columns from separate tables having the same name as one another, and trying to select from both tables in the same query. Okay, so this is my…
Polyonymy
  • 21
  • 6
0
votes
1 answer

MDB2 prepare escaping colon

I'm using mdb2 prepare for creating a select query with date_format, and I need to receive datetime in format "%Y-%m-%d %H:%i:%s". When using such format with mdb2 query - there are no problems, but when i'm trying to prepare this query, I get a…
Voider
  • 11
  • 1
0
votes
1 answer

ownCloud app development, populate database table on installation of app

I'm creating two database tables for my ownCloud app in the "database.xml" file. This means it will automatically generate these two tables when you add/install the app, but they are obviously empty. I'm wanting to put some default entries in one…
stian-01
  • 23
  • 5
0
votes
0 answers

MDB2 Failure to Connect to MySQL on OSX Mavericks

Configuration: Mac OS X 10.9.3 PHP 5.4.24 (default) MySQL 5.6.17 pear list: MDB2 2.4.1 stable MDB2_Driver_mysql 1.4.1 stable PEAR 1.9.4 stable I have a database in place on localhost and it's accessible…
Andy Anderson
  • 51
  • 1
  • 3
0
votes
0 answers

UPDATE and INSERT | MDB2 Error: syntax error

My website has been moved on a new server, everything is working well, but I receive UPDATE and INSERT MDB2 Error: syntax error Here is my code: $sql = "UPDATE {$db_conf['db_name']}.{$this->db_table} SET "; foreach($attr as $key => $value) …
jbfelix
  • 1
  • 1
1 2 3 4
5
6 7