Day 9: sql error 4064… What the $*&#
March 25, 2010Can I just say to Microsoft… SERIOUSLY?????
So I went in to start creating the login page today, and I ran into a stinking weird error. The database wouldn’t let me connect to it. I don’t mean just in the code, but literally, through Web Developer Express, I couldn’t connect. Well, I did some research online (thank you Google), and nothing that I found either: A) made any sense to me as a novice, B) helped with the problem. So I took a stab in the dark. Here is what you can do to get around the problem:
- Delete the connection string out of your database (go to the database explorer, right click on the database, click delete)
- Go into the physical folder where the database is stored and make a copy of the file.
- Delete the old database, and rename the copy with a 2 before the extension
- Now go into your web config file in the solution explorer of visual web developer and find the connection string to the original database connection string.
- Finally, change the name of the database to connect to so that it also has the 2 before the extension.
That solved the problem, but needless to say it set me back a little bit from getting the login form working. That is coming soon.
The Question For You:
Have you run into weird issues while working with .net or MS-SQL? If so, what did you do to deal with it.
The Call For Help:
If anybody has any resources, suggested links, or tutorial locations you would suggest please send them my way. I will be created a resources page to include all of your suggestions.
