Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 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 November 20th, 2007, 11:49 AM
Authorized User
 
Join Date: Nov 2007
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
Default flixon generator against sql server 2000

has anyone run the generator successfully against server 2000? i keep getting a

'an exception has been thrown by the target of an invocation. could not find stored procedure '_$_2cff6......'

error. thanks for any help.

 
Old November 20th, 2007, 12:27 PM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

forumuser - hi there. that is a procedure that i create on the fly (and then destroy). it's used to find the related secondary indexes. obviuosly, some of the 'in built' sp's that it uses aren't supported by 2000. i'd suggest that you revert back to the official site.generator.data.dll and the problem should disappear.

sorry 'bout that....

jimi

http://www.originaltalent.com
 
Old November 20th, 2007, 01:04 PM
Authorized User
 
Join Date: Nov 2007
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi jimi. thanks for that. i might actually try running it against a copy of the database on sql server 2005. that will give me the same data structures...

 
Old November 20th, 2007, 01:06 PM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

Quote:
quote:Originally posted by forumuser
 hi jimi. thanks for that. i might actually try running it against a copy of the database on sql server 2005. that will give me the same data structures...
yes, then you'll get the best of both worlds!!

jimi

http://www.originaltalent.com
 
Old November 20th, 2007, 02:47 PM
Authorized User
 
Join Date: Nov 2007
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
Default

cool. thanks and have a good time in laaaandaaan! ;)

 
Old December 14th, 2007, 09:18 AM
Authorized User
 
Join Date: Nov 2007
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
Default

is there any reason why the flixon generator should work against some tables and not against others? i get an 'exception has been thrown by the target of an invocation... object reference not set etc....' error when running against a few tables. no other info is available unfortunately.
this is when the generator is iterating through BLL_Class.cs.tpl
 
Old December 14th, 2007, 10:44 AM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

forumuser - check that every foriegn key also has a secondary index on it. likewise, make sure there are indexes in child tables which are linked to the parent table (i.e. the child table should have an index on the parentID column).

other than that, can't think of anything else that i've come across.

jimi

http://www.originaltalent.com
 
Old December 17th, 2007, 05:31 AM
Authorized User
 
Join Date: Nov 2007
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks jimi. i checked all that. i even dropped the table, recreated it, called it something slightly different and again, the same error. very strange.

 
Old December 17th, 2007, 05:58 AM
Authorized User
 
Join Date: Nov 2007
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
Default

got it. the generator seems to iterate through all tables, regardless of which ones have been selected. and if it sees a column with a name matching a pk in another table, it assumes that there should be a relationship. is this the case?

 
Old December 18th, 2007, 09:11 AM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 488
Thanks: 2
Thanked 11 Times in 10 Posts
Default

forumuser - yes. guess i missed a trick there and should have had an in() list criteria section. might revise that at some point but prolly not until the new year as i'm otherwise distracted at the moment. hope it doesn't cause you too many hassles and hope things are going well otherwise.

seasons greetings and will be back with more presence in '08


jimi

http://www.originaltalent.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Conflict in SQL Server 2000 and SQL Server 2005 ayan.mukherjee SQL Language 0 June 30th, 2008 03:34 AM
Flixon Site Generator jimibt BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 3 February 14th, 2008 11:33 AM
SQL Server 2000 and SQL Server 2000 CE dparsons SQL Server 2000 1 July 31st, 2006 12:59 PM
looking for access 2000 to sql server 2000 sql/que method SQL Server 2000 0 July 7th, 2005 12:46 PM
SQL SERVER 2000 AND ACCESS 2000 ckentebe SQL Server 2000 3 June 17th, 2004 08:50 PM





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