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 6 of 6
  1. #1
    New to the CF scene
    Join Date
    Dec 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need help for mssql web based client shell

    Hello,
    I am new here and don't know about asp. But I was searching/learning for a web base SQL client which will allow me to execute/supply any SQL query if i supply valid username and password. I don't find any clue .

    If you have any such a script please let me know.

    Thanks

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,919
    Thanks
    79
    Thanked 4,423 Times in 4,388 Posts
    It's not hard to create such a thing. Almost trivial, in fact. But I don't know of any already-written product like this.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #3
    New to the CF scene
    Join Date
    Dec 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Old Pedant View Post
    It's not hard to create such a thing. Almost trivial, in fact. But I don't know of any already-written product like this.

    Thanks for reply. Can give any hint , link for getting started please? I got a complex script but too many error .. Don't find any clue for fixing it.

    Here :http://pastebin.com/i1YbQMF2

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,919
    Thanks
    79
    Thanked 4,423 Times in 4,388 Posts
    Try looking here:
    http://www.codango.com/asp/dir/webapps/database/

    There are a couple of apps listed that look like they do what you want. I see at least one free one, "dbList".
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #5
    New to the CF scene
    Join Date
    Dec 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Old Pedant View Post
    Try looking here:
    http://www.codango.com/asp/dir/webapps/database/

    There are a couple of apps listed that look like they do what you want. I see at least one free one, "dbList".
    Many scripts file for it i see. And perhaps it is only works if .mdb is in local computer. But i need to connect from 10.101.101.10 to 10.10.101.11 (It is load balancing)

    Actually i was searching for more simple than that. Such as 5 form. Example:

    1. Target Server: IP
    2. username : administrator
    3. password : administrator
    4. Run query : select * from master
    5. output: All out put will be here for "select * from master"

    I think it is very simple...

    There is another example: http://www.w3schools.com/ado/showasp...e=demo_query_1
    So if it allow me to connect to remote database and execute own sql query then will do too.
    it will be like conn.Open(Server.Mappath("10.10.101.11/northwind.mdb")) instead conn.Open(Server.Mappath("/db/northwind.mdb"))

    I am n00b at asp
    Last edited by lost-coder; 12-17-2011 at 07:50 AM.

  • #6
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,919
    Thanks
    79
    Thanked 4,423 Times in 4,388 Posts
    No, not at all.

    You can't connect to remote Access databases.

    You can only connect to ".mdb" files that are on the same computer or on the same LAN.

    And even when they are on the same LAN, you need to apply special file permissions to the ".mdb" file.

    And, finally, you can't use Server.MapPath with files on a LAN. That only works for files on the same computer.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Posting Permissions

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