I had the crazy idea of building a site using asp.net and SQL Server via Dreamweaver.!!!! To help me on my way I decided to build a tiny test site just to establish the connections. However, try as I might I can’t make a connection to a database and am now rapidly loosing the will to live due to the quite unbelievable time I have spent trying to sort this out. Now this post is my last best chance.
I am trying to connect to either of the databases that come with the freebee SQL Server package (Is it called express or something?). They are pubs and Northwind.
I am using Dreamweaver 8, XP Professional with the .Net framework v2.0
The connection string reads
"Data Source=[Computer Name]\SQLEXPRESS;
However, I get a choice of two different error messages depending on my computer’s mood (I don’t change ANYTHING) The first is the beautifully succinct and entirely unhelpful “an unidentified error has occurred”. The second reads:
1) There is no testing server running on the server machine
2) The testing server specified for this site does not map to the http://localhost URL
despite the fact that there quite clearly is a testing server running.
After more hours trawling the net for answers, than I care to admit to I decided in desperation to try out the Dreamweaver tutorial that deals with these things (Café Townsend) to see if it offered any clues. However, when attempting to connect to the database (tutorial.mdb) I get the same two error messages, again dependent on my computer’s mood.
Ok. I could give you a blow by blow account of all the things I have tried but this post is too long already. Suffice to say that there IS a testing server running and everything maps to where it should…I am uncertain about the connection string!
Any help in the right direction would be appreciated more than you can imagine.