problem with passwrd protect DB and using ASP

[jaberwocky]

Help!
I password protected an ACCESS DB. However now when i try to access an
of my .asp pages that link to the database i am getting the followin
error.
Code
-------------------
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.

-------------------

Obviously it is looking for a password before it accesses my database
Is there anyway around this? I would like to keep my DB passwor
protected, unless someone can suggest some other form of security wher
i can keep users out of the actual database itself (ie. not able t
open it in Access), but still allow them to enter and view data via m
asp pages

 

[dandgard]

In your ASP code you should be creating a connection object. Withi
that connection object there should be a parameter for you to set th
password

 

[jaberwocky]

OK, i understand the concept, but how would i code in a password below.
Sorry my coding abilities are still rather novice. I am using a DS
connection

Code
-------------------

<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "attendance2004","",""
sql = "SELECT [staff].[fullname], [staff].[employeeno] FROM [staff] ORDER BY [staff].[fullname];"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
%

 

[dandgard]

I no longer work with ASP code. But below is an example created b
Visual Interdev of a connection string. When you do the conn.open, on
of the parameters is the connection string. 90 per cent of what i
below can be defaulted.

I would suggest if you have more questions that you get a book on AS
development, or if you have access to Visual Interdev or some othe
client/server development program that you look at their help files.



"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Dat
Source=\\Coho\develop\Code50Range\RangeExercise.mdb;Mode=Share Den
None;Extended Properties="""";Jet OLEDB:System database="""";Je
OLEDB:Registry Path="""";Jet OLEDBatabase Password="""";Je
OLEDB:Engine Type=4;Jet OLEDBatabase Locking Mode=0;Jet OLEDB:Globa
Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:Ne
Database Password="""";Jet OLEDB:Create System Database=False;Je
OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale o
Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Je
OLEDB:SFP=False;

 

[dandgard]

You know, you say that you had this working before you added th
password protection. if so then you had to have a connection strin
enbedded in one of your .asp files (or in Global.asa). Look throug
your files and see if you can find the old connection string and updat
it

 

[nassim hamana]

spreak you french?

Hello!

I no longer work with ASP code. But below is an example created by
Visual Interdev of a connection string. When you do the conn.open, one
of the parameters is the connection string. 90 per cent of what is
below can be defaulted.

I would suggest if you have more questions that you get a book on ASP
development, or if you have access to Visual Interdev or some other
client/server development program that you look at their help files.



"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
Source=\\Coho\develop\Code50Range\RangeExercise.mdb;Mode=Share Deny
None;Extended Properties="""";Jet OLEDB:System database="""";Jet
OLEDB:Registry Path="""";Jet OLEDBatabase Password="""";Jet
OLEDB:Engine Type=4;Jet OLEDBatabase Locking Mode=0;Jet OLEDB:Global
Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New
Database Password="""";Jet OLEDB:Create System Database=False;Jet
OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on
Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False;"