asked on

Mecromedia Dreamwear MX Connectivity Error:

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

dodge20

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;

aib_it

ASKER

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;

aib_it

ASKER

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"%>

<%
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;
%>

ASKER CERTIFIED SOLUTION

dodge20

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

aib_it

ASKER

Thanks i got it, it was the same problem.