Re: FN-FORUM: Is there a SQL Server equivalent of myPHPAdmin?

date posted 1st September 2006 15:33

On 31 Aug 2006 09:02:43 -0000, Graeme J Sweeney
[EMAIL REMOVED] wrote:
>
> On Thu, 31 Aug 2006, Ashley Howes wrote:
>
> > Alternatively, what is the regular way to access and manipulate tables
> > for a SQL server instance in a shared environment which does not allow
> > direct remote access? I come from a background of command line tools
> > with mySQL / PostgreSQL and so I'm used to ssh access and PHPmyAdmin.
>
> Do you have remote desktop access? Worst case, you use sqlcmd.

No remote desktop access.

> Which version of SQLServer?

SQL Server 2000.

Since emailing out this request, I have discovered that the shared
hosting provider offers remote access, but using a non-standard port.

I have managed to connect using Microsoft Visual Web Developer
Express, and can see the tables. Unfortunately, I can't edit them or
view rows, but that's an in-built limitation of the tool.

sqlcmd does not appear to be able to connect to a remote instance on a
non-standard port as using , or
: both result in error on connection.

Thanks all for your help.