Dreamweaver MX 2004 - Connected to Access DB, but unable to expand

[slakker]

hey guys.. i'm using DWMX2004 and have an ASP page working with MS Access DB.. I create the connection, but after i save/exit page and come back in, i still see the DB in the Databases tab (Applications) palet on the right side, but I can't expand the Table anymore.. it says NONE where the fields are.. DB is actually OK, seems like DW keeps loosing connection to it.. any thoughts?

Also, i posted this in ASP forums, but couldn't find how to move my topic here after i realized that..

 

[Cheech]

What type of connection are you using?

Cheech

[Peace][Pipe]
If you don't stand up for something, you'll fall down. Toke it Easy.
Howard Marks.

 

[lebisol]

Cheech:
here is my 25 cents that we are talking ODBC connection!
ODBC on the WEB = public WC

> need more info?
:: don't click HERE ::

 

[slakker]

I either put this one in myself:

Driver={Microsoft Access Driver (*.mdb)}; DBQ=database.mdb

Or dreamweaver creates a Connections folder with databasename.ASP for me automagically with this content:

<%
' FileName=&quot;Connection_ado_conn_string.htm&quot;
' Type=&quot;ADO&quot;
' DesigntimeType=&quot;ADO&quot;
' HTTP=&quot;false&quot;
' Catalog=&quot;&quot;
' Schema=&quot;&quot;
Dim MM_db3_STRING
MM_db3_STRING = &quot;Driver={Microsoft Access Driver (*.mdb)}; DBQ=database.mdb&quot;
%>

I can work with the database via the Applications panel on the right, but if i save and exit then try again, forget it, it won't open any tables.. says NONE

 

[lebisol]

try DSN-less Jet driver:

MM_db3_STRING = &quot;Provider=Microsoft.Jet.OLEDB.4.0; Data Source=&quot; & Server.MapPath(&quot;/folder/DB.mdb&quot & &quot;


All the best!

> need more info?
:: don't click HERE ::

 

[slakker]

Thanks lebisol.. I was able to make the connection and see the DB in the right panel, but when expanding Tables, it says NONE right away.. doesn't even try to load it

 

[lebisol]

consider:
-the string type ur using
-if it needs updating (ODBC or the MDB driver...)
-if u have the rights to view tables(DB rights and

http://www folder.file

rights)
-if your DW is updated
-if u have created any tables before u attemtped to connect
-if u have any software -firewalls blocking the access....

try -redefining the site and using the connection I gave u...
All the best!

> need more info?
:: don't click HERE ::

 

[slakker]

Thanks again, do I have to have tables in order for the connection to work?

 

[Cheech]

&quot;Thanks again, do I have to have tables in order for the connection to work?&quot;

I thought that was the problem, you couldnt expand to table view. If there are no tables it will say &quot;None&quot;

Cheech

[Peace][Pipe]
If you don't stand up for something, you'll fall down. Toke it Easy.
Howard Marks.

 

[lebisol]

hm....yes

> need more info?
:: don't click HERE ::

 

[slakker]

Well.. it looks like it was a connection problem in DWMX2004.. I found an extension on their site that has a wizard (with loads of options) that creates any type of a connection you want.. and OLE connection..

It works perfectly now.. everytime.. all tables/fields available..

Here is my connection string.. using MS Access DB:

&quot;Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=newdb.mdb;
Persist Security Info=False&quot;