Nathan
Sun Dec 07 01:59:52 CST 2003
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.CreateObject("ADODB.Connection")
Set rs=Server.CreateObject("ADODB.Recordset")
connectstring="Driver={SQL
Server};Server=NJS;Database=pubs;Trusted_Connection=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_Connection" . 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
njsokalski@hotmail.com
"TJS" <nospam@here.com> wrote in message
news:vt5ge88qe9b8de@corp.supernews.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" <njsokalski@hotmail.com> wrote in message
> news:u18posCvDHA.1576@TK2MSFTNGP11.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.CreateObject("ADODB.Connection")
> > Set rs=Server.CreateObject("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
> > njsokalski@hotmail.com
> >
> >
>
>