i have a connection to a remote database server that runs mySQL 4.1.
when i connect to this database from my local web project, which runs in MS Visual InterDev on XP Pro using the bundled IIS server software, i can create temporary tables with no problem at all.
however, when i upload my web project to a remote server i do not seem to be able to create temporary tables even though i am using the exact same code and the exact same connection string.
it seems that all database operations are carried out perfectly with the exception of temporary table creation.
this is driving me absolutely nuts!!!
i'm assuming that it must have something to do with the remote server that my web project is hosted on, but i've no idea what the problem might be. i've tried messing around with the session.timout properties but to no avail.
do i need to use a particular 'type' of temporary table?
if anybody has any suggestions regarding the cause of this problem then i would be very grateful.