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?

    SQL.....? PosgreSQL? MySQL? MSSQL? Oracle? Firebird? Other?

      The requires a client. You can see the php requirements for it on the [man]MSSQL[/man] manual page.

        It sounds to me that a client is required if I am trying to use Microsoft SQL server on a UNIX machine. But the server software is already installed on a Windows NT machine and ASP is being used to access the database. All I want to do is remotely log into the server from my computer which is running Windows XP, access the existing database, and make a couple of changes. I just need to update a couple of the entries in the database. If I were using a MySQL database I would just telnet into the server and log into the database and make the changes, very simple. But I have tried logging into the server without any success so I am wondering if I need certain software to log into a SQL server.

          I'm 99% sure that it comes with a gui (at least the trial version did a few years back)....If not, you could install this and look at the info over the web kinda like phpmyadmin (I assume).

            If all you need to do is run a couple queries on it (DML and DDL statements included), you can just use an all-around client like WinSQL to connect through ODBC to do the queries.

              Write a Reply...