Connecting to SQL Sever
 

Can anybody help? I am trying to connect to a SQL Server (Microsoft SQL Server 2000) and need a good app to access it. I am familiar with mySQL but haven't really played with SQL so Im not too sure of the process to connect to a SQL database or whats app is good. I know you can connect with ACCESS using the mySQL ODBC driver to a mysql database. Can you do the same with thing to a SQL database using the linked tables?
Any info would be helpful!

The only way I have been able to do it in the past is through Sql server enterprise manager... and the only place I ever been able to find it is on the sql cd... not sure if you can download it from microsoft or not..

Query Analyzer too

Yup Enterprise manager...

Look on www.download.com and look for a Database client. I use Navicat, but that might be only MySQL. I've also seen some other ones. I'm mostly used to MySQL/commandline connect, sorry.

fyi.. check out "mySQL front"... its bad-ass
i managed to use Access to connect to the SQL database but that will only let me run queries and such not modify them... worst I can do "alter" or "modify" queries i guess...was just lookin' for an app that could do it

mySQLFront is a great program... It's the best we've found here at work.

yea...trying to find something for SQL though... what a pain :(

Check out this http://www.microsoft.com/downloads/d...displaylang=en

It's a web based SQL server administration app from Microsoft.

Microsoft Access is pretty good with Microsoft SQL server - just use the 'Import/Link tables' manager in there and give it the details. I've set up a system like that recently (I have to point out it wasn't my choice to use MS SQL) and it works fine... Only problem is that Access likes to send your Windows logon username and password to the server if it gets the chance!

RAD!! I will give it a whirl! Thank you much!

Access lets me link up to everything however, there isn't a way to update/modify the stuff easily

It works pretty well, lets you modify tables, stored procedures, logins. It doesn't let you modify views or user defined functions and I couldn't get the Windows authentication to work correctly with any of my servers, including the localhost?! I had to enter a SQL Server login. That could have something to do with how I have the virtual web configured.

You can also download the trail version of mssql from Microsoft and just install the client tools from it.

Linked tables work, but take away the major benefit of SQL... speed. I'd use the Enterprise Manager if all you are looking for is a GUI... otherwise if you are developing a solution just connect with whatever language you are designing.

Jake

anybody know where I can find a download of Enterprise Manager? Even a demo. I need the GUI to connect a SQL database.

http://www.microsoft.com/sql/evaluat...al/default.asp

Choose to install only the client tools.

If you work with php, phpmyadmin works very well.

This download has been making it's way around the web. It's a freeware admin tool for SQL server. I haven't tried it yet.

http://www.visendo.com/en/sqladmin.aspx

sweet! thanks!