Solved

Mecromedia Dreamwear MX Connectivity Error:

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

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 …
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

830 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