|
 |
asp_databases thread: Active Server 2.0 database problem
Message #1 by markc@w... on Wed, 26 Jul 2000 12:36:59
|
|
> ----------
> From: mike@i...[SMTP:MIKE@I...]
> Sent: Tuesday, July 25, 2000 6:28:22 AM
> To: support@w...; mike@i...
> Subject: Active Server 2.0 database problem
>
i've been working on your active server pages 2.0. i am on chap 13 & 14.
everything i do with the Contact.mdb give me this message
Message in the browser:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
/mikeaspbook/Moving.asp, line 19
this is my line 19:
' now open it
objRec.Open "Contact", strConnect, adOpenKeyset, _
adLockReadOnly, adCmdTable
I have even taken the _ out and still get this message. I have asked a
couple of programmers and they tell my my code is correct and that there
is some kind of lock on the database. can you please tell me what is
going on. i am on a mac so i don't have Access to open this file up.
thank you very much
--
Mike Moore
mike@i...
Message #2 by "Marco Voegeli" <marco.voegeli@m...> on Wed, 26 Jul 2000 14:04:00 +0200
|
|
Hello Mark
I don't know now what kind of lock there could be on the
database. If the database is version 97 of access and
it is not a too large file, then you could give me a link to the
database. I'll download it and check it. Maybe I could find
the reason. nly if you want.
By
Marco
----- Original Message -----
From: <markc@w...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, July 26, 2000 12:36 PM
Subject: [asp_databases] Active Server 2.0 database problem
> > ----------
> > From: mike@i...[SMTP:MIKE@I...]
> > Sent: Tuesday, July 25, 2000 6:28:22 AM
> > To: support@w...; mike@i...
> > Subject: Active Server 2.0 database problem
> >
> i've been working on your active server pages 2.0. i am on chap 13 & 14.
> everything i do with the Contact.mdb give me this message
>
> Message in the browser:
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Not a valid password.
>
> /mikeaspbook/Moving.asp, line 19
>
>
> this is my line 19:
> ' now open it
> objRec.Open "Contact", strConnect, adOpenKeyset, _
> adLockReadOnly, adCmdTable
>
> I have even taken the _ out and still get this message. I have asked a
> couple of programmers and they tell my my code is correct and that there
> is some kind of lock on the database. can you please tell me what is
> going on. i am on a mac so i don't have Access to open this file up.
>
> thank you very much
>
> --
> Mike Moore
> mike@i...
>
Message #3 by "Ken Schaefer" <ken.s@a...> on Thu, 27 Jul 2000 10:49:06 +1000
|
|
Perhaps the database has a password on it for the default Admin account...
If you are going to use ODBC, then you need to put the UserName (Admin) and
the Password (whatever it is) either in the DSN definition, or in the
Connection.open method.
Can you tell us what strConnect is, and we could modify that to incorporate
the userid and password (if you can find out what the password is)
Cheers
Ken
> > ----------
> > From: mike@i...[SMTP:MIKE@I...]
> > Sent: Tuesday, July 25, 2000 6:28:22 AM
> > To: support@w...; mike@i...
> > Subject: Active Server 2.0 database problem
> >
> i've been working on your active server pages 2.0. i am on chap 13 & 14.
> everything i do with the Contact.mdb give me this message
>
> Message in the browser:
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Not a valid password.
>
> /mikeaspbook/Moving.asp, line 19
>
>
> this is my line 19:
> ' now open it
> objRec.Open "Contact", strConnect, adOpenKeyset, _
> adLockReadOnly, adCmdTable
>
> I have even taken the _ out and still get this message. I have asked a
> couple of programmers and they tell my my code is correct and that there
> is some kind of lock on the database. can you please tell me what is
> going on. i am on a mac so i don't have Access to open this file up.
>
> thank you very much
>
> --
> Mike Moore
> mike@i...
>
Message #4 by mike@i... on Thu, 27 Jul 2000 08:32:05 -0500
|
|
I got the database from the WROX website for the Active Server Pages 2.0,
so I don't know what the password is on that. I have followed the book
examples. I am trying the Connection.openMethod, the server I am using is
not mine so I can't create a DSN definition(I was trying to get around
that) , the strConnect is:
<%
strConnect = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\wwwroot\inex023\mikeaspbook\contact.mdb"
%>
If you need more info about the coding let me know.
Thanks For The Help
Mike
Ken Schaefer wrote:
> Perhaps the database has a password on it for the default Admin account...
>
> If you are going to use ODBC, then you need to put the UserName (Admin) and
> the Password (whatever it is) either in the DSN definition, or in the
> Connection.open method.
>
> Can you tell us what strConnect is, and we could modify that to incorporate
> the userid and password (if you can find out what the password is)
>
> Cheers
> Ken
>
> > > ----------
> > > From: mike
> > > Sent: Tuesday, July 25, 2000 6:28:22 AM
> > > To: support@w...; mike@i...
> > > Subject: Active Server 2.0 database problem
> > >
> > i've been working on your active server pages 2.0. i am on chap 13 & 14.
> > everything i do with the Contact.mdb give me this message
> >
> > Message in the browser:
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >
> > [Microsoft][ODBC Microsoft Access Driver] Not a valid password.
> >
> > /mikeaspbook/Moving.asp, line 19
> >
> >
> > this is my line 19:
> > ' now open it
> > objRec.Open "Contact", strConnect, adOpenKeyset, _
> > adLockReadOnly, adCmdTable
> >
> > I have even taken the _ out and still get this message. I have asked a
> > couple of programmers and they tell my my code is correct and that there
> > is some kind of lock on the database. can you please tell me what is
> > going on. i am on a mac so i don't have Access to open this file up.
> >
> > thank you very much
> >
> > --
> > Mike Moore
> > mike@i...
> >
>
Message #5 by Ian Nutt <iann@w...> on Thu, 27 Jul 2000 15:47:23 +0100
|
|
Mike,
>>I got the database from the WROX website for the Active Server Pages 2.0,
There's no username and password set on the database you downloaded, unless
you've since added one yourself (and it sounds like you haven't).
I don't know about ODBC getting into Access files on a mac. Does anyone
know if that's likely to behave oddly?
Cheers, Ian
-----Original Message-----
From: mike@i...
Sent: Thursday, July 27, 2000 2:32 PM
To: ASP Databases
Subject: [asp_databases] Re: Active Server 2.0 database problem
I got the database from the WROX website for the Active Server Pages 2.0,
so I don't know what the password is on that. I have followed the book
examples. I am trying the Connection.openMethod, the server I am using is
not mine so I can't create a DSN definition(I was trying to get around
that) , the strConnect is:
<%
strConnect = "Driver={Microsoft Access Driver (*.mdb)};
DBQ=C:\Inetpub\wwwroot\inex023\mikeaspbook\contact.mdb"
%>
If you need more info about the coding let me know.
Thanks For The Help
Mike
Ken Schaefer wrote:
> Perhaps the database has a password on it for the default Admin account...
>
> If you are going to use ODBC, then you need to put the UserName (Admin)
and
> the Password (whatever it is) either in the DSN definition, or in the
> Connection.open method.
>
> Can you tell us what strConnect is, and we could modify that to
incorporate
> the userid and password (if you can find out what the password is)
>
> Cheers
> Ken
>
> > > ----------
> > > From: mike
> > > Sent: Tuesday, July 25, 2000 6:28:22 AM
> > > To: support@w...; mike@i...
> > > Subject: Active Server 2.0 database problem
> > >
> > i've been working on your active server pages 2.0. i am on chap 13 & 14.
> > everything i do with the Contact.mdb give me this message
> >
> > Message in the browser:
> > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> >
> > [Microsoft][ODBC Microsoft Access Driver] Not a valid password.
> >
> > /mikeaspbook/Moving.asp, line 19
> >
> >
> > this is my line 19:
> > ' now open it
> > objRec.Open "Contact", strConnect, adOpenKeyset, _
> > adLockReadOnly, adCmdTable
> >
> > I have even taken the _ out and still get this message. I have asked a
> > couple of programmers and they tell my my code is correct and that there
> > is some kind of lock on the database. can you please tell me what is
> > going on. i am on a mac so i don't have Access to open this file up.
> >
> > thank you very much
> >
> > --
> > Mike Moore
> > mike@i...
> >
>
|
|
|
View Cart
