| benmeiry webforumsuser@macromedia.com 2004-02-02, 12:29 pm |
| Silly me. I want to create a connection from a new asp.net vb page in DWMX 2004 to a the Northwind sample sql db connection. I can't get a connection string to test (via the application panel) without responding with "Unspecified Error". I have been googl
ing my eyes out reading about possible causes for this error. Note, I don't see any error number at all, and it's not an issue of "unfriendly error messages" in the browser, because I am not even at the point yet of creating a page, just an initial db con
nection. I made sure (as best I know how) to set all EM permissions properly. In the SQL admin, I can view the tables without a problem. I made sure to set the asp.net server model...
Here is the connection string that fails:
Persist Security Info=False;
Data Source=(LOCAL);
Initial Catalog=Northwind;
User ID=SA;
Password=;
The other weirdness I see that might be related is that my web.config file just has this:
<configuration>
<appSettings>
</appSettings>
</configuration>
and I also do not see any asax file in the project. I have even tried creating several new projects from scratch to see if somehow the project I am working on somehow got corrupted, but still no luck with above (related?) symptoms.
This seems like it should all be so straightforward. All I am trying to do is create master/detail view and edit pages. What am I missing???
Thanks for any help given!
|