[Typo3] Experience with odbc_connect, odbc_exec, etc.

[Nick Weisser]

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