I have to create an application in Yii that runs on an ibm db2 database. I had seen on posts in various places online that this was possible… but after trying with no success, I looked at the source of CDbConnection and see that there is no ibm or db2 drivers in the driver map (shown below).
public $driverMap=array(
'pgsql'=>'CPgsqlSchema', // PostgreSQL
'mysqli'=>'CMysqlSchema', // MySQL
'mysql'=>'CMysqlSchema', // MySQL
'sqlite'=>'CSqliteSchema', // sqlite 3
'sqlite2'=>'CSqliteSchema', // sqlite 2
'mssql'=>'CMssqlSchema', // Mssql driver on windows hosts
'dblib'=>'CMssqlSchema', // dblib drivers on linux (and maybe others os) hosts
'sqlsrv'=>'CMssqlSchema', // Mssql
'oci'=>'COciSchema', // Oracle driver
);
So… how can I get this working? Is there a different way to use the connection string? or perhaps I have the wrong connection string? Anyone know the proper way to do it?
Pretty lost and in need or serious help here. Anything is appreciated. Thank you all.
Yes, I had seen a lot of these posts before. I’ll have to give it all a swing. Is there any why this will allow for AR to be used?
I really had hoped there would be a connection string I could copy/paste or a working solution already in place… but this will give me a chance to dig deeper now. I’ll post my findings and anyone with some information to offer, it would be appreciated greatly.
I am hoping SOMETHING cuts it. There is a PDO_IBM driver for DB2 as well… may be a better option actually. I have another topic started to cover the creation of a DB2 schema - I’m working on it now.
I have a project on a linux machine with 6GB of RAM.
I believe this is an error connection failure caused by trying to access the DB2 database that is in VirtualBox with Linux with 2GB of RAM.
CDbException
CDbConnection failed to open the DB connection: [IBM][CLI Driver] SQL10007N Message "0" could not be retrieved. Reason code: "3". SQLCODE=-1390
I have not found a solution.
Meanwhile I was implementing the project within the same VM.