Connecting to SQL Sever - Tilted Forum Project Discussion Community

Lord Humungus · 05-25-2004, 11:08 AM

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!

f00sion · 05-25-2004, 04:06 PM

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..

Dilbert1234567 · 05-25-2004, 05:10 PM

Query Analyzer too

Tuna911 · 05-25-2004, 06:19 PM

Yup Enterprise manager...

Fallon · 05-25-2004, 08:15 PM

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.

Lord Humungus · 05-25-2004, 09:24 PM

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

intecel · 05-26-2004, 05:58 AM

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

Lord Humungus · 05-26-2004, 08:42 AM

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

twister002 · 05-26-2004, 11:44 AM

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

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

cliche · 05-26-2004, 11:48 AM

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!

Lord Humungus · 05-26-2004, 07:37 PM

Quote:

Originally posted by twister002
Check out this http://www.microsoft.com/downloads/d...displaylang=en

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

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

twister002 · 05-27-2004, 05:32 AM

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.

bobd123 · 06-06-2004, 06:11 PM

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

jkub2003 · 06-08-2004, 12:36 AM

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

Lord Humungus · 06-08-2004, 11:10 AM

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

bobd123 · 06-12-2004, 10:00 PM

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

Choose to install only the client tools.

Jesus Pimp · 06-14-2004, 08:02 AM

If you work with php, phpmyadmin works very well.

twister002 · 06-19-2004, 07:19 AM

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

Lord Humungus · 06-19-2004, 09:53 AM

sweet! thanks!

Quote:

Originally posted by twister002
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

05-25-2004, 11:08 AM	#1 (permalink)
Lord Humungus Addict Location: The Outer rim of HELL	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! __________________ I am still searching for the movie this quote was in... "Make you strong, like bull", said in a russian accent Post here if you know anything...PLEASE!

05-25-2004, 04:06 PM	#2 (permalink)
f00sion Tilted Location: So. Cali	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.. __________________ Tell me what we’re fighting for— I don’t remember anymore, only temporary reprieve. And the world might cease if we fail to tame the beast; from the faith that you release comes an atheist peace.

05-25-2004, 05:10 PM	#3 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	Query Analyzer too __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

05-25-2004, 06:19 PM	#4 (permalink)
Tuna911 Tilted	Yup Enterprise manager... __________________ Tuna

05-25-2004, 09:24 PM	#6 (permalink)
Lord Humungus Addict Location: The Outer rim of HELL	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 __________________ I am still searching for the movie this quote was in... "Make you strong, like bull", said in a russian accent Post here if you know anything...PLEASE!

05-25-2004, 08:15 PM	#5 (permalink)
Fallon Junkie Location: RI	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.

05-26-2004, 05:58 AM	#7 (permalink)
intecel Psycho	mySQLFront is a great program... It's the best we've found here at work.

05-26-2004, 08:42 AM	#8 (permalink)
Lord Humungus Addict Location: The Outer rim of HELL	yea...trying to find something for SQL though... what a pain __________________ I am still searching for the movie this quote was in... "Make you strong, like bull", said in a russian accent Post here if you know anything...PLEASE!

05-26-2004, 11:44 AM	#9 (permalink)
twister002 Crazy	Check out this http://www.microsoft.com/downloads/d...displaylang=en It's a web based SQL server administration app from Microsoft.

05-26-2004, 11:48 AM	#10 (permalink)
cliche Rookie Location: Oxford, UK	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! __________________ I can't understand why people are frightened of new ideas. I'm frightened of the old ones. -- John Cage (1912 - 1992)

05-27-2004, 05:32 AM	#12 (permalink)
twister002 Crazy	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.

06-06-2004, 06:11 PM	#13 (permalink)
bobd123 Upright	You can also download the trail version of mssql from Microsoft and just install the client tools from it.

06-08-2004, 12:36 AM	#14 (permalink)
jkub2003 Upright	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

06-08-2004, 11:10 AM	#15 (permalink)
Lord Humungus Addict Location: The Outer rim of HELL	anybody know where I can find a download of Enterprise Manager? Even a demo. I need the GUI to connect a SQL database. __________________ I am still searching for the movie this quote was in... "Make you strong, like bull", said in a russian accent Post here if you know anything...PLEASE!

06-12-2004, 10:00 PM	#16 (permalink)
bobd123 Upright	http://www.microsoft.com/sql/evaluat...al/default.asp Choose to install only the client tools.

06-14-2004, 08:02 AM	#17 (permalink)
Jesus Pimp The Original JizzSmacka	If you work with php, phpmyadmin works very well. __________________ Never date anyone who doesn't make your dick hard.

06-19-2004, 07:19 AM	#18 (permalink)
twister002 Crazy	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