Setting up MSDE 2000 Release A on Windows XP Professional

[Nathan Sokalski]

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

[Aaron Bertrand [MVP]]

> 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/

[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

[Nathan Sokalski]

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

[Kristofer Gafvert]

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

[Bob Barrows]

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"

[Jeff Cochran]

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