Somebody please help. I've been searching for answers for 9 days now. I've looked practically everywhere, printed and read a ton of forums, help files, FAQ's, books and manuals. I can't seem to find answers to my questions below. There is so much documentation with a server side perspective but not the deisigner/developer's.
I know that my questions are a little lengthy but I thought that the more detailed I can be, then the better and more usefull your responses will be.
The easy part:
I need to create a website that will use a database to basically register end users as members. There is no need for online payments or anything of the sort. It would just be to gather their info, store it in a database, have them login when they return to grant them access to a restricted area and also retrieve and display their info by doing a search. Just one table.
The part I need help to understand:
The hosting company that I'm using is setup as a Unix box running MySql & PHP4 (for the purpose of running vBulletin Board). I've created simple data websites using Macromedia's Dreamweaver UltraDev (ASP) & Access before on NT hosted servers with no problems. I use a Win'98 machine. I create and then upload.
1. Can I use UltraDev (ASP or JSP) straight with the hosting co's MySQL server? If so, how? Macromedia's website says that its compatable but doesn't tell you how. Do I need any other software like ChilliSoft? Is MySQL ODBC the answer?
2. The hosting company tells me that they don't allow a direct (remote) connection to the MySQL server. They are the only ones that have access to the root (locally). They're in Alberta I'm in Toronto. What exactly does that mean? How do I connect to create my database?
I tried using MysqlFront, but because I don't have access rights, it doesn't work.
3. Do I need to install MySQL on my machine? If so, what software, MySQL server?
Signed,
Confused & tired but not ready to give up!!!!
I know that my questions are a little lengthy but I thought that the more detailed I can be, then the better and more usefull your responses will be.
The easy part:
I need to create a website that will use a database to basically register end users as members. There is no need for online payments or anything of the sort. It would just be to gather their info, store it in a database, have them login when they return to grant them access to a restricted area and also retrieve and display their info by doing a search. Just one table.
The part I need help to understand:
The hosting company that I'm using is setup as a Unix box running MySql & PHP4 (for the purpose of running vBulletin Board). I've created simple data websites using Macromedia's Dreamweaver UltraDev (ASP) & Access before on NT hosted servers with no problems. I use a Win'98 machine. I create and then upload.
1. Can I use UltraDev (ASP or JSP) straight with the hosting co's MySQL server? If so, how? Macromedia's website says that its compatable but doesn't tell you how. Do I need any other software like ChilliSoft? Is MySQL ODBC the answer?
2. The hosting company tells me that they don't allow a direct (remote) connection to the MySQL server. They are the only ones that have access to the root (locally). They're in Alberta I'm in Toronto. What exactly does that mean? How do I connect to create my database?
I tried using MysqlFront, but because I don't have access rights, it doesn't work.
3. Do I need to install MySQL on my machine? If so, what software, MySQL server?
Signed,
Confused & tired but not ready to give up!!!!