This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I use the following connection string as context.ConnectionString and that works fine: server=localhost\\SQLEXPRESS; database=ConsoleApplication1; Integrated Security=SSPI; However if I use the LightSpeed Model designer and use this string as "Connection String", the connect fails. So I removed the second backslash and set this string:server=localhost\SQLEXPRESS; database=ConsoleApplication1; Integrated Security=SSPI; When I use "Update database" from model, I get the "Update Database" popup dialog asking "Apply updates to: server=localhost\SQLEXPRESS;....". but when I press OK I get the following exception:Mindscape.LightSpeed.Generator.Model.GenerationException: No server name could be identified. If using a connection string parameter, have you quoted the connection string? Do you know of a solution to this problem? Best regards, Tomislav |
|
|
|
|
Hi Tomislav, This is a bug which will be fixed in nightlies numbered 20080708 and above, available from http://www.mindscape.co.nz/Products/LightSpeed/nightlybuilds.aspx (Express edition) or the store (Standard and higher editions) from about 1800 GMT. A workaround is to use the other format of SQL Server connection string: DataSource=localhost\SQLEXPRESS;Initial Catalog=ConsoleApplication1; Integrated Security=SSPI; Thanks for letting us know about this issue. |
|
|
|
|
Hi Ivan, Thank you for the update in the new nightly build, I have tried it and managed to Update the database, but unfortunately, only once. Now, each time I do Update database, I get the message: System.NullReferenceException In the stack trace I see among others: at Mindscape.LightSpeed.Generator.Integration.LightSpeedModelCommandSet.PerformUpdate This does not seem to be model related, I get this even with a model of only one table... Tomislav |
|
|
|
|
Hi Tomislav, Just to clarify, you created a model entity and successfully updated the database? So you can now see a corresponding table in the database, right? But if you add a second entity to the model, and do an Update Database, you get the NullReferenceException, is that correct? Would it be possible for you to post your .lsmodel file (you can attach files via the Options tab) and to describe the steps you took that led to the exception, e.g. "dragged entity from toolbox, renamed it to MyEntity, added column Title, right-clicked background and chose Update Database"? If you are able to extract the schema (the create script) of your SQL Express database then that would also be really useful; failing that a screenshot of the Update Database dialog would be handy. Thanks! Thanks for your patience and for helping us to track this down! |
|
|
|
|
[quote user="tomt@applify.com"] Now, each time I do Update database, I get the message: [/quote] A short update: I have started working on a new model file (from scratch) and now the error does not appear anymore... Tomislav |
|
|
|
