[Typo3] Experience with odbc_connect, odbc_exec, etc.

[Dmitry Dulepov]

Hi!

Are you sure you need Access? It will be much faster if you export data
from access database and import it to MySQL. If Access database contains
only static data, this is the best solution.

Dmitry.

Nick Weisser wrote:
> Dmitry Dulepov wrote:
> 
>> Firsts, try the page with "?&no_cache=1" appended because you will not
>> see results of "die" due to typo3 caching. Even "$this->pi_USER_INT_obj"
>> will not help because it disallows caching only for this extension. For
>> debugging you can call $GLOBALS['TSFE']->set_no_cache() but make sure to
>> remove it for production :)
>>
>> Secondly, with the given code you will not get content (if odbc_connect
>> succeeds) because you did not assign anything to $content :)
> 
> 
> Thanks for your feedback, Dmitry. That is very helpful information!
> 
> Yes, it's true that $content has no content, because I deleted the rest
> from the script for the sake of simplicity. I was actually only trying
> to trigger an error error message from my odbc_connect function.
> 
>> Do you run both your script and typo3 on the same machine? Your local
>> machine is probably Windows. ODBC might work there. What OS your typo3
>> system has? If it is linux, you need to check that ODBC is compiled into
>> PHP.
> 
> 
> I sucessfully tried on my local machine with xampp (wamp), but on the
> live server it is a lamp environment. ODBC is actually compiled into
> PHP, but I'm not sure if this is enough.
> 
> I found an interesting article about "Microsoft Access Database using
> Linux and PHP" at http://bryanmills.net:8086/?s=mdb
> 
> I've been trying to install the necessary packages under SuSE 9.3, but
> both the rpm installation and the installation directly from the sources
> ended in a dependency frustration.
> 
> That's why I tried to do it without a DSN connection. I'll write another
> mail if I'm successful :-)
> 
> Cheers,
> Nick