Dreamweaver ASP.net create connection

Aleks
Aleks used Ask the Experts™
on
I am creating my first ASP.net website.
I created my first page and now trying to connect to my database but i keep getting an error.

Attached is the screenshot of the error.

I dont know what I should check as far as making sure there is a testing server. I have classic ASP websites on the same machine and the websites run just fine, so in that sense this being an asp.net what do i have to check ?  

AND

the _mmServerScripts/MMHTTPDB.asp  does not exist inside my website, how is that created ?  it wasnt created when i tried creating the connection ... where does the file comes from ?
connection.gif
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Paul MacDonaldDirector, Information Systems

Commented:
Something's not right here.  You got a 404 error trying to set up an OLEDB connection?  That doesn't make sense...

Author

Commented:
Ok ... we do know something is not right. I created the website like any other ASP classic website, is there something else i need to know ?
Also, it does not use an ODBC connection to connect to the database, as it appears .net connects directly somehow.
Paul MacDonaldDirector, Information Systems
Commented:
.Net has more connectivity options than classic ASP did.  You can still use the classic method, but most people embed their connection information in the web.config file and pull a reference to it from there.

Here's some information that describes how to embed the connection string and how to read it:
http://msdn.microsoft.com/en-us/library/system.configuration.connectionstringssection.aspx
...virtually identical:
http://msdn.microsoft.com/en-us/library/ms178411.aspx
...and a non-Microsoft page:
http://stackoverflow.com/questions/5642474/setting-up-connection-string-in-asp-net-to-sql-server
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Author

Commented:
None of the above help. I actually found the folder above and it is in my root, so thats OK. The problem is that inside that folder the file:  MMHTTPDB.asp

Does not exist. How can I create such file ?
Commented:
Seems to be a 'common' issue, but no resolution to it at least on this thread.

http://forums.adobe.com/thread/3307
Commented:
As it turns out it may be a CS6 issue, i opened the site in CS4 and CS5 and the necessary files were created, now I can open the page in CS6 ... go figure !
Paul MacDonaldDirector, Information Systems
Commented:
Glad you found a solution, and thanks for sharing it.  You almost certainly saved some future person a great deal of aggrevation.

Author

Commented:
I found the solution by testing and doing research along with pointers from the experts.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial