MS Access Connection problems with ASP.NET 1

[mikesh27]

I'm very new to ASP.NET and trying to contact an Access 2000 database in dreamweaver MX2004.

I am able to set up a DSN connection using ASP VBScript (although that brings up error when I try to view the asp page).

However, when I set up an OLE DB connection for ASP.NET VB and test the mdb file situated in c:\inetpub\

http://wwwroot\test

folder it finds it okay. But when I expand the connection in the Databases it shows none of the five tables or views or procedures.

I've been stuck on this for a while now and I am sure I am missing something really obvious.

I'd be grateful for any ideas.

Thanks,

Mike

 

[Ecreations]

if you are running windows XP sp2 you are out of luck with dreamweaver MX, its a bug Macromedia team knows about it and still *working* to resolve it.
This is a link from Macromedia's site with all bugs they need to fix in their application.

http://www.macromedia.com/support/service/servicepack2.html

i would recommend either using Visual Studio.net or Web matrix, you can find the later Here

good luck

The solution is simple, the problem is complex.

http://www.ecreationscanada.com

 

[mikesh27]

Thanks Ecreations.

Have tried on three PCs all running XP sp3.

Thanks again,

Mike

 

[Ecreations]

sp3?

The solution is simple, the problem is complex.

http://www.ecreationscanada.com

 

[mikesh27]

sorry typo! Busy studying web matrix.

Rgds

Mike

 

[Ecreations]

Thats okay, I thought i slept an through an extra Service pack

Good luck with Web Matrix



The solution is simple, the problem is complex.

http://www.ecreationscanada.com