girish_327
Posts: 108
|
| Posted: 10/04/2005, 8:44 PM |
|
Hi,
I am have designed One Project in CCS with ASP and Access.
I want protect my Database so I have Set Password for Access Database but when I set password to database then CCS cant connect to Database it gives error
Invalid Password
so I have used following connection string
<%
' Declare our variables
Dim cnnPasswordTest
' Create our ADO Connection object
Set cnnPasswordTest = Server.CreateObject("ADODB.Connection")
' Open our connection as usual except we need to add the Access
' Jet OLEDB provider-specific Database Password property and
' set it equal to the value of the Access password you set
' from within Access.
cnnPasswordTest.Open "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\path\filename.mdb;" _
& "Jet OLEDB:Database Password=dbpass;"
' Do your database stuff here as you normally would.
' Closing and clearing the objects is always a good idea.
cnnPasswordTest.Close
Set cnnPasswordTest = Nothing
%>
It gives me error Work
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
Please HELP me how do I connect Password Protected Access File in CCS
_________________
Girish Baraskar
Web Designer/Developer
http://www.agnisdesigners.com
http://www.eindianpaintings.com
http://www.realestatekolhapur.com |
 |
 |
Edd
Posts: 547
|
| Posted: 10/05/2005, 6:31 AM |
|
Girish
Firstly refer to
http://support.yessoftware.com/kb_article.asp?article_id=4
Secondly
Your xonnection string looks incomplete / incorrect. Have a look in you common.asp file to see what is there. You at least need a user ID and password, which in provider string uses the short form UID=Admin;PWD=IMAGENIUS
Regards,
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
girish_327
Posts: 108
|
| Posted: 10/05/2005, 10:36 PM |
|
The Right Solution is
When your Access database has a password on it, you have to change the way you compose your connection string:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\somepath\mydatabase.mdb;Jet
OLEDB:Database Password=pass;
You may have to specify the system OLEDB database file in the string as well. This one should work in Windows 2000:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\somepath\mydatabase.mdb;Persist Security Info=False;Jet OLEDB:System database=C:\Program Files\Common Files\System\System.mdw;Jet OLEDB:Database Password=pass;
And this one should work in Windows NT 4:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\somepath\mydatabase.mdb;Persist Security Info=False;Jet OLEDB:System database=C:\winnt\system32\System.mdw;Jet OLEDB:Database Password=pass;
or Visit Following Link for more information
http://www.basic-ultradev.com/articles/ADOConnections/
_________________
Girish Baraskar
Web Designer/Developer
http://www.agnisdesigners.com
http://www.eindianpaintings.com
http://www.realestatekolhapur.com |
|
|
|
|
