Orlando Robles
|
Posted: 11/26/2002, 4:40 PM |
|
I've had no help from Code Charge. Been trying to rectify this thorny
problem for quite awhile: Database Connection:
The db I'm using is Access: the file's name is crfTemplates2.mdb it is
located
under c:\MicroAtlas\fpdb\ directory "c:\MicroAtlas\fpdb\crfTemplates2.mdb
I've created four sites, and integrated them. As suggested by CC, copied all
tables from internet & intranet
database to "crfTemplates2.mdb"
Whether it is Portal, Task Manager, I get the some default error in the
browser:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file
'C:\MicroAtlas\fpdb\crfTemplates2.mdb'.
It is already opened exclusively by another user, or you need permission to
view its data.
/MicroAtlas/K_Management/Common.asp, line 198
It is not opened, and the permission is already set to admin.
what is at line 198 at Common.asp:
"Sub Open()
objConnection.Open ConnectionString, User, Password
End Sub"
What precedes this code is " Private Sub Class_Initialize()
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User
ID=Admin;Data
Source=C:\MicroAtlas\fpdb\crfTemplates2.mdb;Mode=ReadWrite|Share Deny
None;Persist Security Info=False"
User = "Admin"
Password = ""
DateFormat = Array("mm", "/", "dd", "/", "yyyy", " ", "HH", ":",
"nn", ":", "ss")
BooleanFormat = Array("true", "false", Empty)
Set objConnection = Server.CreateObject("ADODB.Connection")
Set Errors = New clsErrors
End Sub"
Can someone please share some light as to what I ought to be doing to
trouble shoot this problem. Would very much appreciate it.
Orlando
|
|
|
|