D
deacon
How can i create a database on my IIS Server?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Thomas A. Rowe
Use Access or visit:
http://dev.mysql.com/downloads/mysql/4.1.html
and scroll down to the Windows section
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
http://dev.mysql.com/downloads/mysql/4.1.html
and scroll down to the Windows section
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
D
deacon
If I wanted to use Access, I would have to buy it, right?
Is there a program similar to PHP MyAdmin that would allow me to set up the
tables in the MySql datatbase if I download from
http://dev.mysql.com/downloads/mysql/4.1.html and get it installed in IIS?
Is there a program similar to PHP MyAdmin that would allow me to set up the
tables in the MySql datatbase if I download from
http://dev.mysql.com/downloads/mysql/4.1.html and get it installed in IIS?
B
Bob Lehmann
T
Thomas A. Rowe
No/Yes.
No if you create a form in FP and then let FP create the database for you from the form.
Yes, if you want to have control over field type, etc.
I can't provide any additional help related to using PHP, as I only use ASP.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
No if you create a form in FP and then let FP create the database for you from the form.
Yes, if you want to have control over field type, etc.
I can't provide any additional help related to using PHP, as I only use ASP.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
B
Bob Lehmann
What's wrong with PHP MyAdmin if you're using MySQL?
Bob Lehmann
Bob Lehmann
D
deacon
Hi Bob, I am trying to use Windows XP with my IIS server to setup an ASP
database. The database would require that I use tables. I am hosted on a
linux server and can do all of this on my host server using their MySql
database, PHP and MyAdmin but would like to learn how to do it using ASP. It
appears as though Access is the program that I would need to administer MySql
in order to create these tables. Is this correct?
database. The database would require that I use tables. I am hosted on a
linux server and can do all of this on my host server using their MySql
database, PHP and MyAdmin but would like to learn how to do it using ASP. It
appears as though Access is the program that I would need to administer MySql
in order to create these tables. Is this correct?
T
Thomas A. Rowe
You can not use an Access database under Unix/Linux.
If you want to use ASP and Access, then you must be hosted on a Windows IIS server.
ASP and PHP can basically do the same thing, however I think it is best to learn one or the other
but not both, at least until have mastered the first choice.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you want to use ASP and Access, then you must be hosted on a Windows IIS server.
ASP and PHP can basically do the same thing, however I think it is best to learn one or the other
but not both, at least until have mastered the first choice.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
P
P C
You would have to buy Access if you want to use Access to work with
Access MDB files directly.
You don't need to buy Access for the machines that has IIS. IIS uses
MDAC (MS data access components), specifically JET to connect to MDB
files. You just need to put the MDB file on the server that runs IIS and
have your ASP page connect to it.
Take a look a this
http://www.genericdb.com/default.asp
....PC
Access MDB files directly.
You don't need to buy Access for the machines that has IIS. IIS uses
MDAC (MS data access components), specifically JET to connect to MDB
files. You just need to put the MDB file on the server that runs IIS and
have your ASP page connect to it.
Take a look a this
http://www.genericdb.com/default.asp
....PC
D
deacon
Thanks PC......this looks like what I want. Also thanks to all others who
posted replies.
posted replies.
R
Ronx
No. Not correct.
You would install PHP on your Windows XP and use MyAdmin to administer
the MySQL database (this is the easy way), else you would use SQL
queries in ASP to do the same thing. Access and MySQL are two
different databases and do not interact together.
You would install PHP on your Windows XP and use MyAdmin to administer
the MySQL database (this is the easy way), else you would use SQL
queries in ASP to do the same thing. Access and MySQL are two
different databases and do not interact together.