Unanswered: Web application reading/writing to Pervasive database
Hello, I am a newbie so please excuse me if this is a dumb question. I have been reading and trying for two days now but I don't even think I have started
I want to make a web application where people can fill in a form. I want to connect over the internet to a remote PC where Pervasive.SQL V8.7 is running, and put the data of the form into the database. I also want to be able to read from the database and return this info to my web application, so I can show it on a page.
I hoped to put XML on the machine where Pervasive is running. But I think it is not possible.
Can I use ODBC to connect to a remote machine too?
I'm am sorry again for this stupid question for I am normally not working with databases or ODBC or remote computers
Thank you for your answer. I will properly read the document, I have just viewed it shortly now. It comes to my attention it is always ASP or .NET, while I work in PHP. I would like to know if it is possible in PHP for me, as I am a normal web devloper and not guru, and not all technical English text is clear to me.
If you think, it is impossible or very hard in PHP, I think about other options but I prefer PHP.
Thank you for you answer, mirtheil. I have been speaking to a colleague who thinks it is not possible to write to the Pervasive database with ODBC. He says the best solution, is to make an application that will convert between Pervasive and my web application. Maybe a Pervasive<->XML<->Pervasive translation, made in VB or Delphi, so that this Windows application can talk to my website using XML files that I transfer with FTP.
I just wish there was an example where a PHP script does a easy query on a remote Pervasive database!