Solved

Mecromedia Dreamwear MX Connectivity Error:

Posted on 2007-03-20
5
165 Views
Last Modified: 2010-04-25
Hi,
   I am having problem in connectivity of Mecromedia Dreamweaver MX as I import the Access table in the page so I cannot see that in the explorer, okay let me tell you in detail.
1st:       I install the IIS from Start Menu--> Settings --> Control Panel --> Add or Remove Programs --> Add or Remove Windows Component  and i Checked the Internet Information Service (IIS) then --> Details and checked all.
2nd:       Now I opened the MS-Access and create a table there like Student Table and field were
               ID:
               FirstName:
               LastName:
               Age:
               Sex:
               Salery:
etc. Then I saved that table in c:\intpub\rootwww      I made a folder in the name of Index and saved Student Table there.

3rd:         Now I start the Mecromedia Dreamweaver MX and I defined a site in the name of Index as I made folder in that name okay that proccess completed as I made DNS connection from Application everything is working there like testing sever and the rest but as I import the Student Data table so it comes and shows in my page but as I try to view them in the Explorer so it say MS-Access driver couldn't find the page as I have defined in DNS connectioin the MS-ACCESS Driver but it is not working I am in great problem any one help me soon.
                         Thanks
0
Comment
Question by:aib_it
  • 3
  • 2
5 Comments
 
LVL 11

Expert Comment

by:dodge20
ID: 18756213
It sounds like either your site isn't setup correctly or your DNS connection isn't correct. What does your connection look like? Have you tried a non-DNS connection such as

Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\yourpath\mydatabase.mdb;

or

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\yourpath\mydatabase.mdb;
0
 

Author Comment

by:aib_it
ID: 18787357
yeah i tried :
Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\yourpath\mydatabase.mdb;

But not

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\yourpath\mydatabase.mdb;
0
 

Author Comment

by:aib_it
ID: 18807020
Coming error like this see:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/javed/Master Detail Page.asp, line 5


Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; InfoPath.1)

Page:
GET /javed/Master Detail Page.asp

AND IT IS MY PAGE CODING SEE:

<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/JRKdata.asp" -->
<%
var FamilyRecords = Server.CreateObject("ADODB.Recordset");
FamilyRecords.ActiveConnection = MM_JRKdata_STRING;                < - - COMING ERROR IN THIS LINE
FamilyRecords.Source = "SELECT * FROM dataTable";
FamilyRecords.CursorType = 0;
FamilyRecords.CursorLocation = 2;
FamilyRecords.LockType = 1;
FamilyRecords.Open();
var FamilyRecords_numRows = 0;
%>
<%
var Repeat1__numRows = 10;
var Repeat1__index = 0;
FamilyRecords_numRows += Repeat1__numRows;
%>
0
 
LVL 11

Accepted Solution

by:
dodge20 earned 500 total points
ID: 18807706
It sounds like your database doesn't have write permissions.

Here is a link
http://support.yessoftware.com/kb_article.asp?article_id=4
0
 

Author Comment

by:aib_it
ID: 18813626
Thanks i got it, it was the same problem.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now