Download the PHP package leaseweb/doctrine-pdo-dblib without Composer
On this page you can find all versions of the php package leaseweb/doctrine-pdo-dblib. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package doctrine-pdo-dblib
Deprecated
This repository is no longer being actively maintained. We encourage you to not use this code. If you rely on this code you might want to fork the repository to keep your systems from breaking, if we remove this repository in the future.
LswDoctrinePdoDblib
Doctrine 2 does support any method of connecting to SQL Server on a Linux box. Here's a simple driver that supports PDO DBlib. Many tests fail, but most are related to shortcomings of the PDODBlib driver. There is a patch in the PHP repo to add transaction and lastInsertId support, but this package has some minor work arounds.
This bundle requires the following:
- pdo_dblib
- FreeTDS
FreeTDS configuration
DBLib requires FreeTDS. We can't go into detail about configuring FreeTDS, but the connection configured should look something like following:
Setting up bundle in Symfony
In your Symfony2 project, modify your config.yml as follows to use the DBlib bundle and the server setup under FreeTDS:
And in your autoload.php register the new bundle:
Putting everything together
Getting everything together wasn't easy. You need to complete the following steps, checking each installation is successful by connecting with the appropriate tools:
- Install FreeTDS and configure a server connection
- Verify with
./tsql -S mssql_freetds -U yourusername -P yourpassword
- Verify with
- Install the PHP DBLib extension -- verify with PHP script containing
- Verify
$pdo = new PDO('dblib:host=mssql_freetds;dbname=yourdb', 'yourusername', 'yourpassword');
- Verify
- Install and configure the PDODblibBundle
- Verify Some kind of SQL against your database
FYI - PHP pdo_dblib patch
You can find a patch for some of the short-comings of pdo_dblib on SVN.
http://svn.php.net/viewvc/php/php-src/trunk/ext/pdo_dblib/dblib_driver.c?view=log
See: Revision 300647 - lastInsertId Revision 300628 - transaction support
FYI - Doctrine Test Suite
Doctrine2's test suite does not allow you to add database drivers on the fly. If you want to test this package, modify Doctrine/DBAL/Driver/DriverManager::$_driverMap as follows:
FYI - Generating Entities from database
It's possible, but not easy. Here's what I did:
- Map any non-compatible column types to string
- Hack the Doctrine core to skip any tables without primary keys
