p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

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

> >

>


  Return to Index