Problem with ODBC connection in multiple frames

MerelyMe

Hello,

I have built something with multiple frames, all of which use a ODBC connection to the same DSN (an Access database). The frameset is also in php.

It all works fine the first time I open the frameset. All frames show what they are supposed to. When I go to another page and then open the frameset a second time it crashes. The php engine is messed up, I get just half of the html code from then on. Really weird.

I've learned the using the same DSN in more than one function results in a shared use of the same connection but could that be the cause of this behaviour?

For now I have no clue how to solve this. I'll try to create three DSN's to the same database just to see if it has anything to do with this shared use.

Does anyone have a suggestion what else I could try?

Thanks.

MerelyMe

Nope, the workaround with three seperate DSN's didn't work. Now that I have removed the other two the corresponding php script give me an error of course but it doesn't hang up the system!!!

I don't know what else to try. Any suggestions? Anyone?

Sxooter

switch to a real database? Interbase and MySQL both run pretty well under windows and are both free. Access is more of a prototyping tool than a database.

MerelyMe

You think it's the database that's the problem? Could be, but unfortunately I'm accessing the databases from Visual Basic as well. Now you're probably going to say: use a real programming language and you're probably right but things do have a history.

There should be another solution ...

Sxooter

Nah, VB may suck as a language, but it's far more of a real language than access is a real database.

VB can talk ODBC, so either MySQL or Firebird should be able to work with it.

You might be able to put some sleep() statements in your code to make it run one script after the other instead of all three at once, and that might fix the problem for a little while, but going to a real database will definitely help you in the long run. Access just isn't built for multi-user high load access.

MerelyMe

Ok, so I may have to install MySQL on the server which is already having a hard time but we'll see.

Would it be possible to open a ODBC connection in one php page and then reuse that connection in another? Do I have to use pconnect in that case?