473,549 Members | 2,383 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Setting up MSDE 2000 Release A on Windows XP Professional

I recently downloaded and installed (hopefully correctly) MSDE 2000 Release
A. I previously, and still do, have the version of IIS that comes with XP
Professional installed on my computer. I wanted MSDE 2000 Release A so that
I could do database access using ASP from my websites, which are on my
computer. When I went to my first test website, I recieved the following
error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Neither DSN nor SERVER keyword supplied
/testDB.asp, line 26

The ASP code that I used on my web to connect to the database (which is
currently just an empty text file) is the following:

Set conn=Server.Cre ateObject("ADOD B.Connection")
Set rs=Server.Creat eObject("ADODB. Recordset")

connectstring=" Driver={SQL Server};" &_
"DBQ=" & Server.MapPath( "testDB")

conn.Open connectstring

The error, obviously, is in the last line I have shown. Because I am
somewhat new to server setup, I am not sure what I need to do to make this
work. If anyone would be willing to help me, I would greatly appreciate it.
Thanks.
--
Nathan Sokalski
nj********@hotm ail.com
Jul 19 '05 #1
6 5484
> connectstring=" Driver={SQL Server};" &_
"DBQ=" & Server.MapPath( "testDB")


You've mixed up SQL Server and Access connection strings. MSDE does not
have a file called "testDB" and even if it did, it would not live in the
same folder as your ASP page. See http://www.aspfaq.com/2126 for valid SQL
Server connection strings.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
Jul 19 '05 #2
TJS

for connection strings you can look here:

http://www.connectionstrings.com/
=============== =============== ==
http://www.ASPkey.net/
A Resource Site for Web Developers
*Free OnLine web Tools
*Free development services
=============== =============== ==
"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:u1******** ******@TK2MSFTN GP11.phx.gbl...
I recently downloaded and installed (hopefully correctly) MSDE 2000 Release A. I previously, and still do, have the version of IIS that comes with XP
Professional installed on my computer. I wanted MSDE 2000 Release A so that I could do database access using ASP from my websites, which are on my
computer. When I went to my first test website, I recieved the following
error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Neither DSN nor SERVER keyword supplied
/testDB.asp, line 26

The ASP code that I used on my web to connect to the database (which is
currently just an empty text file) is the following:

Set conn=Server.Cre ateObject("ADOD B.Connection")
Set rs=Server.Creat eObject("ADODB. Recordset")

connectstring=" Driver={SQL Server};" &_
"DBQ=" & Server.MapPath( "testDB")

conn.Open connectstring

The error, obviously, is in the last line I have shown. Because I am
somewhat new to server setup, I am not sure what I need to do to make this
work. If anyone would be willing to help me, I would greatly appreciate it. Thanks.
--
Nathan Sokalski
nj********@hotm ail.com

Jul 19 '05 #3
I think I am getting closer to my goal, but I am not sure where to go next.
My current error that I recieve is:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'NJS\IUSR_NJS'.
/testDB.asp, line 25

(line 25 in my code is conn.Open connectstring)
And my current code for opening the connection is:

Set conn=Server.Cre ateObject("ADOD B.Connection")
Set rs=Server.Creat eObject("ADODB. Recordset")

connectstring=" Driver={SQL
Server};Server= NJS;Database=pu bs;Trusted_Conn ection=yes;"

conn.Open connectstring

(NJS is the name of my computer, I figured that is what I was supposed to
put there)
I am not sure what I am supposed to do to fix this problem, since there are
no user or password fields/attributes in the connection string, as well as
the fact that there is an attribute called "Trusted_Connec tion" . I also do
not want the user (even though it will normally only be me, since I
primarily want this only for testing my websites) to have to enter a
username or password, so I do not really want there to be a login at all. If
anyone can help me, I would appreciate it. Thanks.
--
Nathan Sokalski
nj********@hotm ail.com
"TJS" <no****@here.co m> wrote in message
news:vt******** ****@corp.super news.com...

for connection strings you can look here:

http://www.connectionstrings.com/
=============== =============== ==
http://www.ASPkey.net/
A Resource Site for Web Developers
*Free OnLine web Tools
*Free development services
=============== =============== ==
"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:u1******** ******@TK2MSFTN GP11.phx.gbl...
I recently downloaded and installed (hopefully correctly) MSDE 2000

Release
A. I previously, and still do, have the version of IIS that comes with XP Professional installed on my computer. I wanted MSDE 2000 Release A so

that
I could do database access using ASP from my websites, which are on my
computer. When I went to my first test website, I recieved the following
error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Neither DSN nor SERVER keyword supplied /testDB.asp, line 26

The ASP code that I used on my web to connect to the database (which is
currently just an empty text file) is the following:

Set conn=Server.Cre ateObject("ADOD B.Connection")
Set rs=Server.Creat eObject("ADODB. Recordset")

connectstring=" Driver={SQL Server};" &_
"DBQ=" & Server.MapPath( "testDB")

conn.Open connectstring

The error, obviously, is in the last line I have shown. Because I am
somewhat new to server setup, I am not sure what I need to do to make this work. If anyone would be willing to help me, I would greatly appreciate

it.
Thanks.
--
Nathan Sokalski
nj********@hotm ail.com


Jul 19 '05 #4
As the error message tells you, you must grant IUSR_NJS logon rights to the
database.

--
Regards,
Kristofer Gafvert
Reply to newsgroup only. Remove NEWS if you must reply by email, but please
do not.
www.ilopia.com - FAQ and Tutorials for Windows Server 2003
"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:eI******** ******@TK2MSFTN GP09.phx.gbl...
I think I am getting closer to my goal, but I am not sure where to go next. My current error that I recieve is:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'NJS\IUSR_NJS'.
/testDB.asp, line 25

(line 25 in my code is conn.Open connectstring)
And my current code for opening the connection is:

Set conn=Server.Cre ateObject("ADOD B.Connection")
Set rs=Server.Creat eObject("ADODB. Recordset")

connectstring=" Driver={SQL
Server};Server= NJS;Database=pu bs;Trusted_Conn ection=yes;"

conn.Open connectstring

(NJS is the name of my computer, I figured that is what I was supposed to
put there)
I am not sure what I am supposed to do to fix this problem, since there are no user or password fields/attributes in the connection string, as well as
the fact that there is an attribute called "Trusted_Connec tion" . I also do not want the user (even though it will normally only be me, since I
primarily want this only for testing my websites) to have to enter a
username or password, so I do not really want there to be a login at all. If anyone can help me, I would appreciate it. Thanks.
--
Nathan Sokalski
nj********@hotm ail.com
"TJS" <no****@here.co m> wrote in message
news:vt******** ****@corp.super news.com...

for connection strings you can look here:

http://www.connectionstrings.com/
=============== =============== ==
http://www.ASPkey.net/
A Resource Site for Web Developers
*Free OnLine web Tools
*Free development services
=============== =============== ==
"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:u1******** ******@TK2MSFTN GP11.phx.gbl...
I recently downloaded and installed (hopefully correctly) MSDE 2000

Release
A. I previously, and still do, have the version of IIS that comes with XP Professional installed on my computer. I wanted MSDE 2000 Release A so

that
I could do database access using ASP from my websites, which are on my
computer. When I went to my first test website, I recieved the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Neither DSN nor SERVER keyword supplied /testDB.asp, line 26

The ASP code that I used on my web to connect to the database (which is currently just an empty text file) is the following:

Set conn=Server.Cre ateObject("ADOD B.Connection")
Set rs=Server.Creat eObject("ADODB. Recordset")

connectstring=" Driver={SQL Server};" &_
"DBQ=" & Server.MapPath( "testDB")

conn.Open connectstring

The error, obviously, is in the last line I have shown. Because I am
somewhat new to server setup, I am not sure what I need to do to make this work. If anyone would be willing to help me, I would greatly
appreciate it.
Thanks.
--
Nathan Sokalski
nj********@hotm ail.com



Jul 19 '05 #5
Nathan Sokalski wrote:
I think I am getting closer to my goal, but I am not sure where to go
next. My current error that I recieve is:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'NJS\IUSR_NJS'.
/testDB.asp, line 25

(line 25 in my code is conn.Open connectstring)
And my current code for opening the connection is:

Set conn=Server.Cre ateObject("ADOD B.Connection")
Set rs=Server.Creat eObject("ADODB. Recordset")

connectstring=" Driver={SQL
Server};Server= NJS;Database=pu bs;Trusted_Conn ection=yes;"

conn.Open connectstring

(NJS is the name of my computer, I figured that is what I was
supposed to put there)
I am not sure what I am supposed to do to fix this problem, since
there are no user or password fields/attributes in the connection
string, as well as the fact that there is an attribute called
"Trusted_Connec tion" . I also do not want the user (even though it
will normally only be me, since I primarily want this only for
testing my websites) to have to enter a username or password, so I do
not really want there to be a login at all. If anyone can help me, I
would appreciate it. Thanks.

How many times do we have to advise you not to use ODBC? Have you even
looked at the websites that have been cited?

The easiest way to connect to SQL Server is to use a SQL login. The user
does not have to see or know the login and password. You can supply those in
your connection string. So your first step is to use Enterprise Manager to
create a SQL login and password (say you use asp_acct/password) and grant
that account permissions to the database to which you are attempting to
connect. You should read up in SQL Books Online (BOL) all that is has to say
about SQL security.

Then, in ASP, do this:

connectstring = "Provider-SQLOLEDB;Data Source=NJS;" & _
"Initial Catalog=pubs;Us er ID=asp_acct;Pas sword=password"

That's it. You're done.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 19 '05 #6
On Sun, 7 Dec 2003 02:59:52 -0500, "Nathan Sokalski"
<nj********@hot mail.com> wrote:
I think I am getting closer to my goal, but I am not sure where to go next.
Limiting to a single appropriate newsgroup would be the smartest move.
Followups reste to just the inetserver.asp. db group. use it.
My current error that I recieve is:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'NJS\IUSR_NJS' .


And what part of "Login Failed" are you questioning?

Create a login for the IUSR_NJS user in your database. or better,
create a SQL user, with appropriate rights, and use an OLEDB provider
string with the account in the string. Use an Include to make this
easy.

Jeff
Jul 19 '05 #7

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

Similar topics

4
2826
by: Paul S | last post by:
I have a copy of MS Visual Studio 2002 Professional ACADEMIC which I understand is the same as the regular Professional version with the addition of a student CDROM. The installation program on the first CDROM only copies the MSDE to the harddrive and the copied setup file has to then be manually executed to complete the installation. Are...
1
3090
by: izzy | last post by:
I was wondering if any of you guys can kindly help me in finding all the different versions of MSDE 2000 that came out since it's first release. I expected to find something similar like Sun's archive (http://java.sun.com/products/archive/index.html) for MSDE 2000 too but failed to find after a few hours of browsing at the Microsoft Download...
5
8413
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 2000. One of them is full SQL Server, another is msde. When transaction log is full in full SQL Server error 9002 severity 17 state 2 is logged in...
3
1905
by: Stephen Bishop | last post by:
Hi everyone, In using the SQL Server Database Wizard in Access 2000 to create a new access project, I get two consecutive error messages and then the wizard shuts down. The first, which apprears immediately after starting the wizard is a message box stating something like "the property value is too large". After clicking through and filling...
10
3827
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 time. Install log shows installation successful.. Control Panel> Admin Tools> Services section shows SQL server instance running.
1
1886
by: DB developer | last post by:
Hello friends I am trying to create a deployment project to distribute my VB.NET application with MSDE database. I am using VS.NET with MSDE 2000 deployment toolkit (release candidate) to achieve this. I am facing the following problems I am deploying the database by copying to .MDF and .LDF files in destination folders using deployment...
9
246
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 professional SP2 and an msde database but the strange thing is, on my win 2000 sql server 2000 pc I've got a table which keeps the heighth of something...
3
1335
by: David Lozzi | last post by:
Howdy! I have a question for all you smarties... I have a ASP.Net application running on Windows 2000 Professional and MSDE, same box. While running the application, users will randomly receive a too many connections error or even a simple Page cannot be displayed. I know some of the limitations of MSDE and have managed to fudge my way...
0
2505
by: cmrhema | last post by:
Hello I have Windows XP Professional. This will not allow me to install MS SQL SERVER 2000 Developer Edition. It allows me to install only the Client Tool, which I did successfully. Thereafter I installed MSDE, which enables me to work. Now I use visual basic 6.0, vb.net as frontend. I follow all the tutorials (so far the basic ones) which...
0
7546
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7471
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7985
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7503
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7830
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
3496
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1962
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1082
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
784
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.