CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Database Connection

Print topic Send  topic

Author Message
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


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.