Enterprise Manager question

[JohnWise]

What is the best way to download this? And can it be used with Windows 98?
Thanks.

[wardbekker]

JohnWise,

You mean the Sql Server Enterprise Manager? It's part of the Sql Server software. Trail software is available at Microsoft's website. Only the personal and desktop can be used with 98

[JohnWise]

I see these three files available. sql2kasp3.exe.
sql2kdesksp3.exe.
sql2ksp3.exe.

These are all huge files. I am wondering if I need to download all three of these? All I want to be able to do is use Enterprise Manager to connect to a database.

Thanks very much.

[wardbekker]

JohnWise,

The filenames are from the servicepacks. Anyway, the trial download for sql server 2000 on [microsoft.com...] is temporarily removed due to the recent "Slammer" worm.

I'm afraid u need to buy it instead (did i hear somebody say kazaa? :) )

[JohnWise]

LOL. Yes. Don't want to buy. Think I will wait for my new OS to come, XP. I have W98 now. Then I should be able to use the Web Matrix tool from Asp.net.
Thanks.

[JohnWise]

Is there any other tool available for connecting to a SQL database? That is of the free variety. For a W98 OS?
Thank you.

[RossWal]

JohnWise,
I think you might be able to use Access. I haven't done it though. Maybe when you open a new project you can point it to SQL server? If SQL is not on your local machine, and it sounds like it's not, you'll need to figure out how to point Jet to it.

Also, depending upon how sophisticated you need it (or rather how unsophisticated) maybe you can write a little app to pass SQL straight through to SQL server? I did this once with DB2. For selects you can loop through the results row-by-row and within row display columns 0-n.

HTH,
Ross

[tomasz]

You can try MSDE, it can be installed on Win98.

MSDE 2000 is distributed on the CD with all editions of Microsoft Office that include Microsoft Access 2002, such as Microsoft Office XP Professional, Microsoft Office XP Developer, and Microsoft Office XP Premium.

just make sure to apply latest sevice pack.

[chameleon]

Is there any other tool available for connecting to a SQL database? That is of the free variety. For a W98 OS?

John,

I use a program called WinSQL Lite when I don't feel like waiting for Enterprise Manager to load (Yes, I'm that impatient!)

It's free, and it uses ODBC to connect to the database. It's a simple query tool that might be just what you need.

I will sticky mail you the URL.

[JohnWise]

Thanks much. Appreciated for sure.