MSDE/SQL Server Problem

[Arsalan]

I've downloaded a couple of Microsoft sample source codes, but the problem
is that it says that MSDE or SQL server should be present to run the code.

I've SQL Server 2000 installed but for some reason its giving the error.
How do I solve it?

 

[Ken Tucker [MVP]]

Hi,

Server name is probably wrong.

Ken
-----------------
I've downloaded a couple of Microsoft sample source codes, but the problem
is that it says that MSDE or SQL server should be present to run the code.

I've SQL Server 2000 installed but for some reason its giving the error.
How do I solve it?

 

[Arsalan]

Server name is correct, its localhost, and even the Northwind table exists
there.
I dont know for some reason its not connection to the server.

 

[Shiva]

Perhaps the database is on a named instance and you are missing the instance
name when connecting? Also, check the user id/password used to connect.

I've downloaded a couple of Microsoft sample source codes, but the problem
is that it says that MSDE or SQL server should be present to run the code.

I've SQL Server 2000 installed but for some reason its giving the error.
How do I solve it?

 

[Greg Burns]

I've had problems using "localhost" in my connection string. Just
yesterday, I spent an hour trouble shooting why my machine was aparently
freezing when trying to connect. Not sure why that is happening, but using
"(local)" instead worked just fine.

And if that doesn't work, what username are you using? Or are you using
Trusted_Connection=true?

Greg

 

[Arsalan]

I've installed MSDE on a new machine, how do I change the Named instance
from XXX to
something else so that
"osql -E -S (local)\NetSDK -i InstNwnd.sql"
works without glitch.

The problem is that the source codes which I've downloaded has the above
named instance so, it would be easier for me to change the instance rather
than changing the whole code.

 

[Shiva]

Unfortunately, instance name cannot be changed without uninstalling and
installing.

I've installed MSDE on a new machine, how do I change the Named instance
from XXX to
something else so that
"osql -E -S (local)\NetSDK -i InstNwnd.sql"
works without glitch.

The problem is that the source codes which I've downloaded has the above
named instance so, it would be easier for me to change the instance rather
than changing the whole code.

 

[Arsalan]

What does (local)\NetSDK refers to ?? Is it LocalComputerName\NetSDK ??

 

[Greg Burns]

Yes.

What does (local)\NetSDK refers to ?? Is it LocalComputerName\NetSDK ??