Tables not listed in database connection

[Bren]

Hi All

I am finally dipping my toe in the ASP.NET pond so I am trying to work
through the tutorial in DWMX.

I have set up the connection to the test Access DB (trio.mdb) and when I
click the test connection button the connection is succesfull.
BUT! when I go to create a dataset, I choose the connTrio as the connection
and in the table drop down list it just says "no tables" also when I try to
view the tables in the database panel it just says none.

I try the connection in a classic ASP site and everything is fine.

Am I being a k*nob? and if I am please tell me how.

TIA
Bren

[Paul Whitham TMM]

Have a look at this technote and see if it applies

[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19515[/url]

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Bren" <bren@dontbothertoreply.com> wrote in message
news:d5ttn1$3kq$1@forums.macromedia.com...

> Hi All
>
> I am finally dipping my toe in the ASP.NET pond so I am trying to work
> through the tutorial in DWMX.
>
> I have set up the connection to the test Access DB (trio.mdb) and when I
> click the test connection button the connection is succesfull.
> BUT! when I go to create a dataset, I choose the connTrio as the

connection

> and in the table drop down list it just says "no tables" also when I try

to

> view the tables in the database panel it just says none.
>
> I try the connection in a classic ASP site and everything is fine.
>
> Am I being a k*nob? and if I am please tell me how.
>
> TIA
> Bren
>
>

[The HEdge]

I also had exactly the same problem, followed the tech note, installed the
extension, but now the 'test connection' fails every time. It doesn't matter
what I specify in the connection string either (ie its not even getting as far
as validating the path).

I've checked the _mmServerScripts dir and it has the INC, JSP and ASP files.
I've rebuilt the site from scratch, reinstalled the extension but still doesn't
work.. I presume its all to do with SP2.

Can ANYbody help please..??:confused;

[Bren]

Hi All

It looks like it is something to do with .NET Framework 2.0. I have
installed the web express beta 2 from Microsoft and the problems started
from there.
I have tried the site on a separate PC which hasn't been touch with the evil
that is .NET 2.0 and everything is fine.
I am still trying to resolve the issue but as a workaround I am just hand
writing the SQL code in the dataset, insert record dialogues and the pages
still work.

Any other suggestions appreciated.

Regards
Bren

[Bren]

Unistalled and re-installed DW everything fine now.

[FSchmitthammer]

Bren,

I uninstalled and reinstalled also however I did not get it to work. Was there anything else you did?

Fred

[FSchmitthammer]

Bren,

I uninstalled and reinstalled also however I did not get it to work. Was there anything else you did?

Fred

[JohnTIII]

Thank you! The technote helped. I was able to get the tables to populate
after removing the three files as mentioned in the "Database connectivity fails
with local ASP.NET and ASP servers" topic.

I can't tell you how much this will simplify my development.