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? 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?
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?
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?
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?
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?
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?
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?
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? > > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
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...
|
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
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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,...
|
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,...
|
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...
| |