Yellow-Asterisk

Hi folks, i'm trying to find an open source app that can accomplish things done by the full version of MS SQL Server. I have a SQL server running on my local machine and need to get access to the data in it. I know nothing about SQL Server or even SQL. So i'm sorry if this question seems silly. Any help in even understanding what i am trying to do would be greatly appriciated.

__________________
http://lavos.ytmnd.com/

"The electric Yellow's got me by the brain banana!"

tuoply

Are you looking for a SQL client?

squirrel-sql on sourceforge

Or a free database server?

mysql.com

Yellow-Asterisk

I think i have a SQL Client. Squirrel, and i have a SQL server running locally, i think it is called MSDE or something. I just dont know how to get the SQl Client to talk to the server.

__________________
http://lavos.ytmnd.com/

"The electric Yellow's got me by the brain banana!"

ScratchMonkey

Cool, I'd never heard of Squirrel. YA, there's a link to their tutorial in the Overview section here:

http://squirrel-sql.sourceforge.net/

__________________

Banyan

Toad

http://www.toadsoft.com/

__________________
"In the land of predators, the lion never fears the jackal."
http://warhammermonkey.com/p/Banyan/
PLAYSTATIONŽNetwork "TrickyTerp"

tuoply

You just need to setup the driver in squirrel, you should already have the Microsoft MSSQL Server JDBC Driver selection, use it and create an 'alias'; point to your local copy of sql server (you can probably use 127.0.0.1 for the name) and add in your username and password. Should be pretty straightforward after that.

Yellow-Asterisk

Alright thanks, it turns out that i had Access to a copy of SQL Server 2000 Standard Edition. That did what i needed it to do. Thanks for your help anyway.

__________________
http://lavos.ytmnd.com/

"The electric Yellow's got me by the brain banana!"