Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mlawton40
Starting Member
15 Posts |
 Posted - 2008-03-16 : 08:51:29
|
Hello,I am using the web blog at http://weblogs.asp.net/scottgu/archive/2007/01/11/tip-trick-how-to-upload-a-sql-file-to-a-hoster-and-execute-it-to-deploy-a-sql-database.aspxto deploy an SQL script on my database. The sql script is named aspnetdb.sql and is placed in my main directory.Now using the file RunSQL.aspx which is also placed in the main directory (www.genealogy-prototype.com/RunSQL.aspx) I have changed the parts in the file which need changing: // Url of the T-SQL file you want to run string fileUrl = "http://genealogy-prototype.com/aspnetdb.SQL"; // Connection string to the server you want to execute against string connectionString = @"Server=genealogy-prototype.com;User ID=marko;Password=</span> <span lang=EN>123;Initial Catalog=aspnetdb"; but when I go to my page genealogy-prototype.com/RunSQL.aspx I am getting an error. However I'm not sure what this error is as it says I need to change custom errors to off in web.config, i have done this but it still says i have it on...I'm guessing it must be something to do with the connection string i have given or the file url. My hosting company is freezone.co.uk, my database name is aspnetdb my username for this database it marko and there is no password. Is the connection string i have given wrong?I have been trying this for over a week, any help would be great!!Thank you, Mark |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-16 : 17:02:59
|
| What was the error? |
 |
|
|
|
|
|
RunSQL.aspx Connection