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 4 of 4
  1. #1
    Senior Coder
    Join Date
    Apr 2003
    Location
    England
    Posts
    1,192
    Thanks
    5
    Thanked 13 Times in 13 Posts

    database solution

    i am looking for a database system that is portable and not ms access or mysql but still works in ASP3 (php and asp.net are also enabled on my server but these dont really matter)

    i know someone who made a small utility to get the database passwords out of any ms access database so this is no longer a viable solution, whats the point of putting a password on an encrypted database if someone can just read the password

    i do not want to use mysql for various reasons that i would not like to get into here so please do not just tell me to use that

    what else is there? i have heard of oracle but havnt looked into it really and dont know if it is what im looking for or there is a better solution

    i would prefer it if i could just change my ms access database connect line and keep the lines such as
    rsWhatever = objConn.Execute("SELECT * FROM table")

    but i dont know whether this is possible

    im using windows server 2003 by the way

  • #2
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Well the most obviousl choice would be MSSQL.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #3
    Senior Coder
    Join Date
    Apr 2003
    Location
    England
    Posts
    1,192
    Thanks
    5
    Thanked 13 Times in 13 Posts
    ok, and what does that involve?

  • #4
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by ghell
    ok, and what does that involve?
    that you change your connectionstrings, and that's all.

    MsServer is the bigger brother of MsAcess and uses the same SQL version (Jet SQL) so your app will keep on runing.

    I don't think your initial post makes any sense. Password are exactly encrypted to make them unreadable if someone can get into your db. I'll take on 'someone' any day of the week and give him full access to my db to let him crack my hashed passwords.
    MsServer isn't more secure then MySQL or Oracle or DB2 or PostGres or whatever.
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html


  •  

    Posting Permissions

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