[subdivizion]

i don't expect to get many responses about this but here it goes:

is it possible to access an SQL Server 2000 Desktop Engine database from another computer in a network? if so, when you're trying to connect from within VB.NET using the Server Explorer, what would be the server name i enter? (assume the sql instance is named "SCFJ")

thanx for your help

[HoLoCroN]

Here is the deal, since MSDE 2000 is free and designed to be used as a background service, support is limited and it is only done via a command prompt.

You should be able to create a utility that maps to the MSDE by providing the machine name, catalog info and using the Osql.exe utility that comes with MSDE. Check out this link with the command switches that will be needed.

The good thing is that .NET will work almost effortlessly with MSDE, you might have to look a little deeper if there are any scripts available though.

http://support.microsoft.com/default...;EN-US;q325003

[subdivizion]

yea of course. the problem was connecting to the database from another computer on the network but thanks to the link you gave me, i browsed around and figured out what i had done wrong.


when i installed database, network protocols were disabled and i didn't use Mixed Mode so i can also authenticate within SQL Server. so i reinsstalled and it's all working like a charm. thanks a million!

[HoLoCroN]

Awesome!

You did that pretty quick good job!!

Just curious, what kind of application are you using the MSDE for anyway?

[BlazingWolf]

I'm making a VB .NET/SQL Server 2000 program for a hosting company.

And You can get full SQL Server 2000 with Enterprise manager and everything from the mircosoft website, along with these huge help books, and no I didn't get it off Kazaa I got it from the Mircosoft website.

[subdivizion]

I'm making a database application for a company who'll be using SQL Server 2000 Standard Edition and they have 150 licenses but only 12 PC's (could use one license for myself) but since i'm building the application with the rest of my group in my home, i needed something basic to build the code on.

BlazingWolf, yes, you can get Enterprise Manager and the Books for free but the only version of SQL Server you can download for free is the MSDE (Desktop Engine).