Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 10 of 10
  1. #1
    owo
    owo is offline
    New to the CF scene
    Join Date
    Apr 2006
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How Can I Manage Microsoft Sql Database Of My Website On The Host Sever

    I am a young and a new website develper, using MACROMEDIA DREAM WEAVER, JAVASCRIPT, MACROMEDIA FLASH AND PRESENTLY LEARNING ASP.
    I am a new member to codeforum.

    I need your advice on a database website. I WANT TO KNOW, AFTER I PUBLISH THE
    WEBSITE ON AN HOST SERVER, HOW CAN I MANAGE THE DATABASE ON THE WEBSITE??

    I have not publish any website in dreamweaver before, but very soon I will publish a database driven website with asp pages in dreamweaver.

    thanks in advance.

    Yours Faithfully
    owo

  • #2
    Senior Coder angst's Avatar
    Join Date
    Apr 2004
    Location
    Toronto, Ontario
    Posts
    2,114
    Thanks
    15
    Thanked 122 Times in 122 Posts
    this would depend on your host. and the type of data base server they are running.

    other then that, I'm not exactly sure how to mean "HOW CAN I MANAGE THE DATABASE ON THE WEBSITE" what exactly do you want to manage?

  • #3
    owo
    owo is offline
    New to the CF scene
    Join Date
    Apr 2006
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I use MICROSOFT SQL SEVER, I just want to know after I have attach my data base on my website,then I publish it to the host server, runnig microsoft sql server for databses. Apart for designing an admin system on my website, how I can manage all the data stored in the database that I have attach to my websites.

    That is how can I directlly access the data base using my normal SQL SELECT STATEMENT, and perform normal database administrative task on all my saves data in the database.


    PLS I NEED YOUR ADVICE AND EXPLANATIONS.

    THANKS IN ADVANCE.

  • #4
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,169
    Thanks
    19
    Thanked 65 Times in 64 Posts
    To do what you want to do (ie manage your database without building an administration site) you would need access to Microsoft Enterprise Manager on your server. Or configure your own copy of Enterprise Manager to access your hosts sql server
    Last edited by NancyJ; 04-21-2006 at 12:50 PM.

  • #5
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    or use one of the many sql server administration sites which are for free available. pure ASP or ASP.NET versions are there out in the wild.
    I am the luckiest man in the world

  • #6
    owo
    owo is offline
    New to the CF scene
    Join Date
    Apr 2006
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Nancy,
    Thanks for your reply, please teach me how I can configure my copy of Enterprise Manager to access my hosts sql server. I will like to know the process and the explanation of how it can be done.

    I am just a beginer.

    THANKS IN ADVANCE.

  • #7
    owo
    owo is offline
    New to the CF scene
    Join Date
    Apr 2006
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    HI Roelf,
    Thanks for your reply, please could you give the list of some websites
    that have sql server administration which are for free available. pure ASP.


    THANKS IN ADVANCE.

  • #8
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    Quote Originally Posted by owo
    HI Roelf,
    Thanks for your reply, please could you give the list of some websites
    that have sql server administration which are for free available. pure ASP.


    THANKS IN ADVANCE.
    http://www.hotscripts.com/Detailed/22574.html
    I am the luckiest man in the world

  • #9
    Senior Coder
    Join Date
    Nov 2002
    Location
    North-East, UK
    Posts
    1,265
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Dreamweaver can handle basic admin. You can list, insert, update and delete records.

    Enterprise Manager and Query analyzer are run from the server. Unless you download a front end then you will need access to the server.

  • #10
    owo
    owo is offline
    New to the CF scene
    Join Date
    Apr 2006
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thaks For All Reply And Assitance


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •