I am having huge trouble connecting MX to ASP.NET (& SQL server on ASP.NET pages) that resides on another server.
I can see the databases in the 'build connection' window but when I try and test the connection to an SQL database I get the error message
'Access Denied. The file may not exist or there is a permission problem'
And I cannot select any table

This is my first ASP.NET site and I am not sure if I have delpoyed the files to the right places etc.
Could anyone give us a rundown of where ASP.NET files (web.config etc) are uploaded to, or any connection tips.

The root of the folder is configured like:

/www

_mmserverscripts (not sure about this folder - haven't used it)
_notes (empty)
htdocs (contains site files & currently contains web.config)
bin (currently contains dreamweaverctrls.dll)
connection (used for existing asp pages connection to SQL::working)
private (not used)
scriptlibrary (aspupload)

The site is on windows2003 server with iiS6 and .NET framework installed.
I can connect with no difficulty on .ASP pages to the SQL server

Any help would be greatly appreciated as a deadline is looming fast

Andy

running SP2?
Have you applied the dreamweaver patch?
www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19515#aspnet_db

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
running SP2?
Have you applied the dreamweaver patch?
www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19515#aspnet_db

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I have the same problem and i did patch with the extension patch from Macromedia. Still not working and hopefully someone can help me on this one because it's supposed to be easy but it's not! Lets start, when i put my connection string in MMX dialog for OLEDB Access database, i put it like this:
<pre id=code><font face=courier size=2 id=code>Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=/db/datas.mdb;
User ID=admin;
Password=; </font id=code></pre id=code>

and what happends when i do that , i receive an error message saying this:

C:\db\datas.mdb is not a valid path ....

i tried so many ways to put the Data Source string (even with server.mappath("/db/datas.mdb" that was originally working with Visual Studio Net and now it doesn't want to work at all. Am i missing something? Can someone help me on this one? I do not work locally, my database is on the Server and all the pages i work directly on the server.

Second, when i went to download the patch, i TRIED to follow the instructions by Macromedia on how to fix the problem with the BUILD button but the only thing they say is to create a text file and to rename the extension with .UDL but they do not say where is the UDL file supposed to be when i hit the BUILD button. I tried on putting a UDL file in the main directory of the site but it doesn't work, i tried to put it inside the database (db) folder and nothing happends there neither. So, where am i supposed to put that file for the BUILD button to find it?

Please help!!!! It's been already 3 days that i am on this problem! and i cannot continue without my database!

Thank you guys!

William!

Just for reference, DMXzone has a .NET premium article <b>ASP.NET Configuration</b> (www.dmxzone.com/showDetail.asp?TypeId=28&NewsId=5431) which covers <i>machine.config</i> and <i>web.config</i>.

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>