[TYPO3-UG Spain] ORACLE 9i R2 CONNECTION

[Santiago Galindo Hidalgo]

Hi everybody…




I’m trying to connect to an oracle 9i R2 instance, so
I read the documentation and tried get access to my data base using the oci8
extension, but when I start apache appear this error: "The procedure entry point OCILobRead2 could not be located in the dynamic link library OCI.dll". I investigated and it seems that oci8 only work fine with
oracle 10g. So I thought about the ODBC driver.



I’m using the script below at localconf.php:



















$TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg']
= array (
 '_DEFAULT' => array (
  'type' => 'adodb',
  'config' => array(
   'driver' => 'odbc',
  )
 ),
); 




$TYPO3_CONF_VARS['EXT']['extList']
.= ',adodb,dbal'; 








$typo_db_username
= 'system';
$typo_db_password
= 'system';
$typo_db_host
= 'AREAS_DSN';                    //here I
put the Data Source Name (I’m not sure if it’s OK)
$typo_db
= 'AREAS';



With this I achieved connect to the database
successfully but there are 1631 tables in my database generated by oracle,
because I didn’t create any table.



Then I clicked on “COMPARE” and here I had the first
problem, appears the next warning and error:



Warning:
Invalid argument supplied for foreach() in C:\typo3\htdocs\typo3wamp\typo3\sysext\dbal\class.ux_t3lib_db.php
on line 1731



Fatal
error: Maximum execution time of 60 seconds exceeded in
C:\typo3\htdocs\typo3wamp\typo3\sysext\adodb\adodb\drivers\adodb-odbc.inc.php
on line 420



I went to this file and commented the line 420 because
I couldn’t find how to increase the maximum execution time.



/*if
(empty($qid)) $qid = odbc_columns($this->_connectionID);*/



I tried again clicking “COMPARE” but this time the
warning above appears so many times and at the end I have the following error:



DBAL
fatal error: No handler found in handler_getFromTableList() for:
"AQ$INTERNET_USERS" (SQL engine parse ERROR: No table name found as
expected in parseFromTables()!: near "AQ$INTERNET_USERS ")



At this time I don`t have any idea how to resolve the
problem, I’m frustrated because I have tree weeks reading a lot of
documentation to trying to connect to oracle 9i but I have no result.



PLEASE… if you know how to connect and use a database
oracle 9i R2 to work with typo3 let me know, because is something really important  for me to be able to do this...



Thanks in advance
_________________________________________________________________
Tecnología, moda, motor, viajes,…suscríbete a nuestros boletines para estar a la última
http://newsletters.msn.com/hm/maintenanceeses.asp?L=ES&C=ES&P=WCMaintenance&Brand=WL&RU=http%3a%2f%2fmail.live.com