View Full Version : database solution

08-06-2004, 03:09 PM
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

08-06-2004, 09:10 PM
Well the most obviousl choice would be MSSQL.

08-06-2004, 09:18 PM
ok, and what does that involve?

08-06-2004, 10:07 PM
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.