#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    1
    Rep Power
    0
    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
  2. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15

    <<
    Now I find out that although my ISP supports ASP they do not support Access databases
    directly but use this thing called mySQL??.
    >>

    since your ISP has mysql installed then you don't have to worry.

    you can transfer data from your msaccess database to mysql.you can find out the details from this forum searching "data transfer from msaccess to mysql".

    i think ODBCconnectivity would be very easy with Mysql.Your ISP must have installed proper drivers.
    i haven't used mysql with asp.so i can't say too much.








    ------------------
    SR -
    shiju.dreamcenter.net

    "The fear of the LORD is the beginning of knowledge..."
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    2
    Rep 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
  6. #4
  7. No Profile Picture
    BrainFreeze
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Location
    London
    Posts
    318
    Rep Power
    14
    I use PHP and MySQL, very easy to connect. I use a web based admin tool to control my MySQL database called PHPmyAdmin, go to www.mysql.com and get all the info there. I am surprised the hosting company uses Mysql with ASP bu find a nice web interface and things hsould be a little clearer. You can also port access to SQL Dump, and then upload this into the admin tool on the web and the tables will be replicated.

Similar Threads

  1. Multipart/form-data and Perl
    By bullet in forum Perl Programming
    Replies: 4
    Last Post: February 1st, 2004, 10:09 AM
  2. Javascript: I need to add value of radio button to total
    By Spewer999 in forum JavaScript Development
    Replies: 1
    Last Post: December 24th, 2003, 01:23 PM
  3. multi dimension array sort
    By corrupted_wise in forum Perl Programming
    Replies: 7
    Last Post: November 12th, 2003, 02:40 AM
  4. How to calculate the total price using javascript
    By SBUH in forum JavaScript Development
    Replies: 0
    Last Post: August 19th, 2003, 10:59 AM

IMN logo majestic logo threadwatch logo seochat tools logo