ASP Login Failure - Database Password

[N. Graves]

Thank you for taking your time to read my question... please offer
your knowledge it will be appreciated!

I'm writing a ASP Web page to access a Access Database that has a
Database Password set. If I remove the password I'm able to read and
work with the database.

Here is the code that I have to open the connection to the Database:

Set objDB = Server.CreateObject("ADODB.Connection")

sDBName = "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Request.ServerVariables("APPL_PHYSICAL_PATH") &
"fpdb\plogons.mdb;" & _
"Uid=admin;" & _
"Pwd=test"

Open sDBName

Here is the error that is returned:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
The database password is "test"

[Eric Schittlipz]

"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:cb********************************@4ax.com...

Thank you for taking your time to read my question... please offer
your knowledge it will be appreciated!

I'm writing a ASP Web page to access a Access Database that has a
Database Password set. If I remove the password I'm able to read and
work with the database.

Here is the code that I have to open the connection to the Database:

Set objDB = Server.CreateObject("ADODB.Connection")

sDBName = "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Request.ServerVariables("APPL_PHYSICAL_PATH") &
"fpdb\plogons.mdb;" & _
"Uid=admin;" & _
"Pwd=test"

Open sDBName

Here is the error that is returned:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
The database password is "test"

Don't confuse the two types of password you can have. You can have one
using JET user-level security where you have an account comprising username
and password - this is what you have coded for. Alternatively, you can have
the simplest password where everyone has the same.
see the following for details: http://support.microsoft.com/kb/191754
Both passwords are easily cracked, but the second one is almost worthless,
particularly if the database is being held on a web server anyway.

[N. Graves]

Eric your the man!

I did not understand the difference in the passwords and you where a
big help. I know about the security issue too.

This Web page that I'm working on is my own and will reside only on my
PC. This application is to keep up with the many passwords and logins
I have to maintain.

Thanks again for you help!
On Thu, 27 Jan 2005 15:16:57 +0000 (UTC), "Eric Schittlipz"
<er**@schittlipz.com> wrote:

"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:cb********************************@4ax.com.. .

Thank you for taking your time to read my question... please offer
your knowledge it will be appreciated!

I'm writing a ASP Web page to access a Access Database that has a
Database Password set. If I remove the password I'm able to read and
work with the database.

Here is the code that I have to open the connection to the Database:

Set objDB = Server.CreateObject("ADODB.Connection")

sDBName = "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Request.ServerVariables("APPL_PHYSICAL_PATH") &
"fpdb\plogons.mdb;" & _
"Uid=admin;" & _
"Pwd=test"

Open sDBName

Here is the error that is returned:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
The database password is "test"

Don't confuse the two types of password you can have. You can have one
using JET user-level security where you have an account comprising username
and password - this is what you have coded for. Alternatively, you can have
the simplest password where everyone has the same.
see the following for details: http://support.microsoft.com/kb/191754
Both passwords are easily cracked, but the second one is almost worthless,
particularly if the database is being held on a web server anyway.

[N. Graves]

Eric or anyone following this note:

OK I was able to get past the password issue but now I have another
issue. Hopefully I can explain my issue clearly

I was using a Driver instead of the Provider to connect to the
database. When the database did not have a password I could use
SELECT, DELETE UPDATE AND INSERT. Now that I'm using the Provider
with the password I'm only able to use SELECT.

Here is the error for using "Delete from tbl_Logons"

Microsoft JET Database Engine error '80004005'
Could not delete from specified tables.

Are there limitation to using the Provider to connect to the Database
or am I doing something else wrong?

I would appreciate you help and knowledge

Thanks
N. Graves
On Thu, 27 Jan 2005 10:41:36 -0500, N. Graves
<ng*****@REMOVEyahoo.com> wrote:

Eric your the man!

I did not understand the difference in the passwords and you where a
big help. I know about the security issue too.

This Web page that I'm working on is my own and will reside only on my
PC. This application is to keep up with the many passwords and logins
I have to maintain.

Thanks again for you help!
On Thu, 27 Jan 2005 15:16:57 +0000 (UTC), "Eric Schittlipz"
<er**@schittlipz.com> wrote:

"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:cb********************************@4ax.com. ..

Thank you for taking your time to read my question... please offer
your knowledge it will be appreciated!

I'm writing a ASP Web page to access a Access Database that has a
Database Password set. If I remove the password I'm able to read and
work with the database.

Here is the code that I have to open the connection to the Database:

Set objDB = Server.CreateObject("ADODB.Connection")

sDBName = "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Request.ServerVariables("APPL_PHYSICAL_PATH") &
"fpdb\plogons.mdb;" & _
"Uid=admin;" & _
"Pwd=test"

Open sDBName

Here is the error that is returned:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
The database password is "test"

Don't confuse the two types of password you can have. You can have one
using JET user-level security where you have an account comprising username
and password - this is what you have coded for. Alternatively, you can have
the simplest password where everyone has the same.
see the following for details: http://support.microsoft.com/kb/191754
Both passwords are easily cracked, but the second one is almost worthless,
particularly if the database is being held on a web server anyway.

[Eric Schittlipz]

"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:2i********************************@4ax.com...

Eric or anyone following this note:

OK I was able to get past the password issue but now I have another
issue. Hopefully I can explain my issue clearly

I was using a Driver instead of the Provider to connect to the
database. When the database did not have a password I could use
SELECT, DELETE UPDATE AND INSERT. Now that I'm using the Provider
with the password I'm only able to use SELECT.

Here is the error for using "Delete from tbl_Logons"

Microsoft JET Database Engine error '80004005'
Could not delete from specified tables.

Are there limitation to using the Provider to connect to the Database
or am I doing something else wrong?

I would appreciate you help and knowledge

Thanks
N. Graves

The choice of connection string is the choice between using Jet OLE DB 4.0
driver instead of an ODBC driver. The former is the newer technology but
perhaps you have a compelling reason to use the other. Anyway, both should
work, but you need some error handling and if an error occurs, you need to
delve into the Errors collection of the connection object and inspect the
SqlState of the error before you can find out what's going on. Database
Engine error '80004005' does not help much, does it?
As this is really an ASP question you might be better off in another
newsgroup, or I could send you a demo of this to your e-mail if it's valid -
mine isn't.

[N. Graves]

Thanks Eric. I would like to see your code! I have been using and
developing code to access SQL and Access Database for several years
and with a lot of success. This Database password has presented new
challenges for me to say the least.

My Email is ng*****@REMOVEYahoo.com ... Remove the REMOVE for the
correct address.

On Fri, 28 Jan 2005 16:17:59 +0000 (UTC), "Eric Socialize"
<er**@schittlipz.com> wrote:

"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:2i********************************@4ax.com.. .

Eric or anyone following this note:

OK I was able to get past the password issue but now I have another
issue. Hopefully I can explain my issue clearly

I was using a Driver instead of the Provider to connect to the
database. When the database did not have a password I could use
SELECT, DELETE UPDATE AND INSERT. Now that I'm using the Provider
with the password I'm only able to use SELECT.

Here is the error for using "Delete from tbl_Logons"

Microsoft JET Database Engine error '80004005'
Could not delete from specified tables.

Are there limitation to using the Provider to connect to the Database
or am I doing something else wrong?

I would appreciate you help and knowledge

Thanks
N. Graves

The choice of connection string is the choice between using Jet OLE DB 4.0
driver instead of an ODBC driver. The former is the newer technology but
perhaps you have a compelling reason to use the other. Anyway, both should
work, but you need some error handling and if an error occurs, you need to
delve into the Errors collection of the connection object and inspect the
SqlState of the error before you can find out what's going on. Database
Engine error '80004005' does not help much, does it?
As this is really an ASP question you might be better off in another
newsgroup, or I could send you a demo of this to your e-mail if it's valid -
mine isn't.

[Br]

N. Graves wrote:

Eric or anyone following this note:

OK I was able to get past the password issue but now I have another
issue. Hopefully I can explain my issue clearly

I was using a Driver instead of the Provider to connect to the
database. When the database did not have a password I could use
SELECT, DELETE UPDATE AND INSERT. Now that I'm using the Provider
with the password I'm only able to use SELECT.

Here is the error for using "Delete from tbl_Logons"

Microsoft JET Database Engine error '80004005'
Could not delete from specified tables.

Are there limitation to using the Provider to connect to the Database
or am I doing something else wrong?

I would appreciate you help and knowledge

Thanks
N. Graves
Perhaps you need to set the cursor type or something when you open the
recordset?

Br@dley


On Thu, 27 Jan 2005 10:41:36 -0500, N. Graves
<ng*****@REMOVEyahoo.com> wrote:

Eric your the man!

I did not understand the difference in the passwords and you where a
big help. I know about the security issue too.

This Web page that I'm working on is my own and will reside only on
my PC. This application is to keep up with the many passwords and
logins I have to maintain.

Thanks again for you help!
On Thu, 27 Jan 2005 15:16:57 +0000 (UTC), "Eric Schittlipz"
<er**@schittlipz.com> wrote:

"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:cb********************************@4ax.com...
Thank you for taking your time to read my question... please offer
your knowledge it will be appreciated!

I'm writing a ASP Web page to access a Access Database that has a
Database Password set. If I remove the password I'm able to read
and work with the database.

Here is the code that I have to open the connection to the
Database:

Set objDB = Server.CreateObject("ADODB.Connection")

sDBName = "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Request.ServerVariables("APPL_PHYSICAL_PATH") &
"fpdb\plogons.mdb;" & _
"Uid=admin;" & _
"Pwd=test"

Open sDBName

Here is the error that is returned:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
The database password is "test"

Don't confuse the two types of password you can have. You can have
one using JET user-level security where you have an account
comprising username and password - this is what you have coded for.
Alternatively, you can have the simplest password where everyone
has the same.
see the following for details:
http://support.microsoft.com/kb/191754
Both passwords are easily cracked, but the second one is almost
worthless, particularly if the database is being held on a web
server anyway.