[SOLVED] Having trouble with oracle db connection

[Alt_F4]

Hi all,

 

I am having trouble with the below code. It works fine when I use the same function to generate the connection object for mssql

 

i get the following errors:

 

Notice: Undefined variable: connection in C:\Program Files (x86)\Zend\Apache2\htdocs\www\Tasmania\o_database.php on line 12

 

Fatal error: Cannot access empty property in C:\Program Files (x86)\Zend\Apache2\htdocs\www\Tasmania\o_database.php on line 12

 

I can't work out what the issue is 

 

any help would be appreciated.

 

$database = new MSSQLDB;

class MSSQLDB
{
var $connection;         

function MSSQLDB()
{
	$odb = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_IP)(PORT = 1521)) ) (CONNECT_DATA = (SID = SID_NAME) ) )";
	$this->$connection = @oci_connect('user', 'pass', $odb) or die('Cannot connect: '.oci_error());
}
} 

 

[Alt_F4]

dont worry i sorted it out