Solved

Mecromedia Dreamwear MX Connectivity Error:

Posted on 2007-03-20
5
169 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Editing PHP within Adobe DreamWeaver 11 184
Replace Dreamweaver with what? 8 162
DW UserID Session from Login 1 109
.dwt files not viewable in browser - why? 2 75
For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

895 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

15 Experts available now in Live!

Get 1:1 Help Now