473,385 Members | 1,655 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

MSDE/SQL Server Problem

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?
Nov 21 '05 #1
8 1074
Hi,

Server name is probably wrong.

Ken
-----------------
"Arsalan" <ar***********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
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?

Nov 21 '05 #2
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.

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:ON*************@TK2MSFTNGP09.phx.gbl...
Hi,

Server name is probably wrong.

Ken
-----------------
"Arsalan" <ar***********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
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?

Nov 21 '05 #3
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.

"Arsalan" <ar***********@hotmail.com> wrote in message
news:#u**************@TK2MSFTNGP15.phx.gbl...
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?

Nov 21 '05 #4
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" <ar***********@hotmail.com> wrote in message
news:ey**************@TK2MSFTNGP09.phx.gbl...
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.

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:ON*************@TK2MSFTNGP09.phx.gbl...
Hi,

Server name is probably wrong.

Ken
-----------------
"Arsalan" <ar***********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
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?


Nov 21 '05 #5
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" <sh******@online.excite.com> wrote in message
news:u2**************@TK2MSFTNGP12.phx.gbl...
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.

"Arsalan" <ar***********@hotmail.com> wrote in message
news:#u**************@TK2MSFTNGP15.phx.gbl...
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?



Nov 21 '05 #6
Unfortunately, instance name cannot be changed without uninstalling and
installing.

"Arsalan" <ar***********@hotmail.com> wrote in message
news:O2**************@tk2msftngp13.phx.gbl...
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" <sh******@online.excite.com> wrote in message
news:u2**************@TK2MSFTNGP12.phx.gbl...
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.

"Arsalan" <ar***********@hotmail.com> wrote in message
news:#u**************@TK2MSFTNGP15.phx.gbl...
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?


Nov 21 '05 #7
What does (local)\NetSDK refers to ?? Is it LocalComputerName\NetSDK ??

"Shiva" <sh******@online.excite.com> wrote in message
news:uM**************@TK2MSFTNGP12.phx.gbl...
Unfortunately, instance name cannot be changed without uninstalling and
installing.

"Arsalan" <ar***********@hotmail.com> wrote in message
news:O2**************@tk2msftngp13.phx.gbl...
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" <sh******@online.excite.com> wrote in message
news:u2**************@TK2MSFTNGP12.phx.gbl...
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.

"Arsalan" <ar***********@hotmail.com> wrote in message
news:#u**************@TK2MSFTNGP15.phx.gbl...
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?



Nov 21 '05 #8
Yes.

"Arsalan" <ar***********@hotmail.com> wrote in message
news:u5***************@TK2MSFTNGP09.phx.gbl...
What does (local)\NetSDK refers to ?? Is it LocalComputerName\NetSDK ??

"Shiva" <sh******@online.excite.com> wrote in message
news:uM**************@TK2MSFTNGP12.phx.gbl...
Unfortunately, instance name cannot be changed without uninstalling and
installing.

"Arsalan" <ar***********@hotmail.com> wrote in message
news:O2**************@tk2msftngp13.phx.gbl...
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" <sh******@online.excite.com> wrote in message
news:u2**************@TK2MSFTNGP12.phx.gbl...
> 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.
>
> "Arsalan" <ar***********@hotmail.com> wrote in message
> news:#u**************@TK2MSFTNGP15.phx.gbl...
> 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?
>
>
>




Nov 21 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Igor Solodovnikov | last post by:
Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I have two instances of sql server under Windows...
10
by: noname | last post by:
MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install...
3
by: *no spam* | last post by:
I want to move my Access 2K database into MSDE. The Access Upsizing Wizard crashes (a known bug wi A2K), so I'm using the following suggested method: Access --> New --> Project (Existing...
2
by: Mark | last post by:
Hi - I have a rather unreliable host just now - but they offer .net, sql server and SSL for a reasonable price. Problem is, the domain is hosted on a shared server - and it keeps going down...
1
by: Markus Graf | last post by:
Hi all I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation was not the problem, but if i would connect with a client like dbamgr2k or the MS Enterprise client, the client...
2
by: Rosy Moss | last post by:
I am in the process of cleaning up a database that our company uses to track jobs, time and expense, and customer information. We are running Windows 2000 Server with approximately 20 terminals...
41
by: NB | last post by:
Hi I have been developing on MS Access / Jet / VBA platform for about 2 years. The current project I am working on for a small business is built on Access 2002. It has about 53 tables in 2...
9
by: Piedro | last post by:
Hi Group, I haven written a program on a win 2000 pc and sql server 2000, in the sql server there're about 40 tables with data and now I'm deploying my project on a test pc with windows xp...
11
by: HC | last post by:
I posted this in one of the VB forums but I'm starting to think it might be more appropriate to have it here, since it really seems to be a SQL server (MSDE/Express 2005) problem: Hey, all, I...
9
by: HC | last post by:
Hello, all, I started out thinking my problems were elsewhere but as I have worked through this I have isolated my problem, currently, as a difference between MSDE and SQL Express 2005 (I'll just...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.