I am setting up the classifieds starter kit and I am getting the error "Incorrect syntax near '='. Must declare the scalar variable "@DateApproved"."
when executing the SQL script to setup the classifieds DB.
I followed the help posted on this forum (thanks
darkknight187), but I am still getting this error.
I am using Go Daddy for hosting
IIS 7.0 (in classic mode)
I created both DBs, then deleted the tables, views, and procedures from the classifieds DB
Modfied the "@DateCreated smalldatetime = NULL" text in the sql file as reco'd
I do not understand your error. But there are two big things I learned.
Select 'classic pipeline' (as you did)
And no matter what I did, I had to use the database publisher function in VisualStudio 2005 to get
my sites to work. I never figured out why the database publisher thing would not work in Visual Studio
2008, I just went back and used the scripts from 2005. The errors I am talking about here happen when
trying to run the scripts on the godaddy database.
If you have not gotten a lot of work into your site yet, then do what I did on one of mine...
I canceled the hosting account, then set it up again but this time with IIS 6.
Since you are using godaddy hosting, you will also find that you have a great deal of trouble with the
site sending emails. There are many threads on that subject here on this forum that I suggest you read.
Marked as answer by Myersra on Mar 17, 2010 08:01 PM
II found information taht it may be the file encoding saved out of notepad (used to edit SQL file) so I changed it to UTF-8 and still had the error. I then used the original SQL file (no edit for the @DateCreated text) and it worked fine.
Myersra
Member
15 Points
13 Posts
Error running SQL script file to set up Classifieds DB
Mar 13, 2010 03:46 PM|LINK
I am setting up the classifieds starter kit and I am getting the error "Incorrect syntax near '='. Must declare the scalar variable "@DateApproved"." when executing the SQL script to setup the classifieds DB.
I followed the help posted on this forum (thanks darkknight187), but I am still getting this error.
I am using Go Daddy for hosting
IIS 7.0 (in classic mode)
I created both DBs, then deleted the tables, views, and procedures from the classifieds DB
Modfied the "@DateCreated smalldatetime = NULL" text in the sql file as reco'd
SQL server classified ads starter kit Classified's starter kit scalar variable
cnranasinghe
Star
8899 Points
1800 Posts
Re: Error running SQL script file to set up Classifieds DB
Mar 14, 2010 11:35 AM|LINK
Better submit the code.
racer184
Member
104 Points
34 Posts
Re: Error running SQL script file to set up Classifieds DB
Mar 16, 2010 12:15 AM|LINK
I do not understand your error. But there are two big things I learned.
Select 'classic pipeline' (as you did)
And no matter what I did, I had to use the database publisher function in VisualStudio 2005 to get
my sites to work. I never figured out why the database publisher thing would not work in Visual Studio
2008, I just went back and used the scripts from 2005. The errors I am talking about here happen when
trying to run the scripts on the godaddy database.
If you have not gotten a lot of work into your site yet, then do what I did on one of mine...
I canceled the hosting account, then set it up again but this time with IIS 6.
Since you are using godaddy hosting, you will also find that you have a great deal of trouble with the
site sending emails. There are many threads on that subject here on this forum that I suggest you read.
Myersra
Member
15 Points
13 Posts
Re: Error running SQL script file to set up Classifieds DB
Mar 17, 2010 08:07 PM|LINK
II found information taht it may be the file encoding saved out of notepad (used to edit SQL file) so I changed it to UTF-8 and still had the error. I then used the original SQL file (no edit for the @DateCreated text) and it worked fine.
Thanks for th ereplies
Notepad SQL creation