Wrox Programmer Forums
|
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8
This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 by Chris Hart, John Kauffman, David Sussman, Chris Ullman; ISBN: 9780764588501
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 4th, 2007, 12:29 AM
Authorized User
 
Join Date: Apr 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Syntax question

Hello hopefully someone will know this. When I try to import an sql file (corresponding to the Login control in chapter 4) to a host sql server 2005 database, the tool I am using is claiming that the sql file contains a syntax error

Error -2147217900
  Incorrect syntax near 'END'.


I admit I know nothing about sql syntax, but I saw these strange things in the syntax could they be errors? What concerns me is the apostrof following the END. Most 'END' don't have an apostrof but some do. Could this be an error?

-------- sample 1 ---------
CLOSE c1
    DEALLOCATE c1
END'

-------- sample 2 ---------
INSERT dbo.aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate)
    VALUES (@ApplicationId, @UserId, @UserName, LOWER(@UserName), @IsUserAnonymous, @LastActivityDate)

    RETURN 0
END'

END

-------- sample 3 ---------
    RETURN @ErrorCode

END'
END

 
Old May 4th, 2007, 09:54 AM
Authorized User
 
Join Date: Apr 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well I got an explanation to this. Even though godaddy.com web page says "Database version 2005" it is actually SQL Server 2000 servicepack 4, according to the customer service individual I contacted. Usually customer service at godaddy would not know what SQL is, so I am still a little suspicious he is mistaking it for the windows version of the server (which is one reason I am asking questions here instead). But all I can do is take his word for it.

Well I guess I need to find out how to convert SQL 2005 .sql file into a SQL 2000 .sql file, if that is possible at all.

 
Old May 6th, 2007, 12:32 AM
Authorized User
 
Join Date: Apr 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, you can equally easy use the Database Publishing Wizard to generate an SQL 2000 sql file instead. However, exactly the same thing happens.

Godaddy Database Manager does not like to import anything it seems.

 
Old May 7th, 2007, 12:14 AM
Authorized User
 
Join Date: Apr 2007
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well I talked to godaddy customer support and I was informed that it is not SQL server 2000 service pack four they are using, it was actually SQL server 2005. However, it does not matter in any case, it does not work either way.

Well I think it is time that I stop talking to myself and end this thread.

 
Old May 7th, 2007, 01:25 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Have you tried a simple SQL test script? E.g. one that creates a simple table? Or even easier, one that only inserts a single record in a table?

I worked with the Database Publishing Wizard once or twice and it has worked fine for me.

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Another newb syntax question mean34dean Access VBA 4 April 4th, 2008 07:45 AM
syntax question Tachyon Beginning PHP 4 July 14th, 2004 07:40 PM
sql access syntax question using "LIKE" katie456 SQL Server 2000 3 October 10th, 2003 05:49 PM
Syntax question please. savoym VBScript 2 August 12th, 2003 12:41 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.