Page 1 of 1

SQL question

Posted: Tue Mar 09, 2004 11:49 am
by claudia
This may be a dumb question but does anyone know how to log into an existing SQL database and make changes. I am proficient in PHP and MySQL, I usually just telnet into the server I am working on and access the MySQL database that way. Is it done the same way for SQL or is there certain software that I need to use?

Posted: Tue Mar 09, 2004 11:51 am
by patrikG
If you're using PHP 4.* the mysql functions are inbuilt (or bundled).
Have a look at: http://uk2.php.net/mysql

Should be a piece of cake for you :)

For general maintainance, I'd suggest http://www.phpmyadmin.net (PHPMyAdmin) - a very powerful mysql admin tool.[/url]

Posted: Tue Mar 09, 2004 11:55 am
by claudia
I am not using PHP. I am using ASP. All the ASP is completed as well as the SQL database on the SQL server. I just need to remotely connect to the SQL server to access the database and make some updates to the database itself. I just don't know how to connect to the actual database itself directly. Can I just telnet into the server or do I need certain Microsoft specific software being that the database is SQL.

Posted: Tue Mar 09, 2004 11:57 am
by patrikG
Hmm...not sure where to find a good ASP forum out there, but I am sure someone there would definitely know the answer.

Posted: Tue Mar 09, 2004 11:59 am
by claudia
THANKS! I'll look around.