Solved

Mecromedia Dreamwear MX Connectivity Error:

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

773 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