
June 4th, 2000, 08:08 AM
|
|
Junior Member
|
|
Join Date: Jun 2000
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by Steve Wiggins:
I am totally new to mySQL. So some expert advice would be a god send.
I have just developed a web site that uses
ASP pages to connect to an Access database via a DNS-less ADO connection. Now I find out that although my ISP supports ASP they do not support Access databases directly but use this thing called mySQL??.
I want the owner of the web site to just be able to modify and upload a database to the web site.
My problem is that I have not got a clue as to how to go about this using mySQL.
Do I need to convert my Access database to a mySQL format or can mySQL interface directly with such a database?
If I do need to convert my database...how do I do it? Also how does the web site owner then easily modify the contents of this database (in a nice easy interface such as Access)?
How do I connect to the databse on my ASP page (I understand I need to use ODBC??)?
So many questions and so little time!!
Any pointers in the right direction would be very much appreciated.
If you got this far then thanks for reading!
Regards
Steve Wiggins[/quote]
I am also new to this and just about in the same position as you except that I am using a Unix server. From what I understand so far is that we cannot connect directly to our MySql but have to export to our web server our database in .txt then import via MySql. I am sure there must be an easier way. As for connecting your web pages to MySql, I am unable to help you since I use a unix server and use Perl in the CGI folder. (PS - If it sounds like I know what I am talking about, your wrong. I am also in your position becuase although I can connect to my database via Telnet, I am still unable to figure out how to connect to MySql via Perl or any other fashion. I know that this is not much help but to tell you you are not alone. I hope someone else can help us. Keep me posted.)
------------------
Robert Zimmerman
AMPM Transport
|