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
|
2 Things: 1) When choosing a database provider in the designer, I don't see an option for SqlServer2008. Is there a plan to support this in the designer anytime soon? 2) When I copy my database connection string into the 'Connection String' property, and then try to update the database, the program tells me 'Keyword not recognized'. This is a normal connection string that's copied from my Server Explorer. Any help would be appreciated. Thanks! |
|
|
|
|
1. The SqlServer2005 provider in the designer includes SQL Server 2008 support. (However, the runtime *does* distinguish between them -- that is, in your app.config or your LightSpeedContext initialisation code, you will need to specify SqlServer2008 if you want to access 2008-specific features like spatial data types.) 2. At what stage does the error occur -- before or after the "select updates to apply" dialog? Is there an exception trace or just a plain message? If there is an exception trace can you post it please? If the error occurs before the dialog, can you post the connection string please? Thanks! |
|
|
|
|
1) Thanks for clearing that up. 2) The error would occur right before the 'select updates to apply' dialog. It was just a plain error message, not an exception. To solve the problem, I did some reverse-mapping from the database and copied the generated connection string from the Lightspeed designer. Then I changed the database and pushed the model into another location. I then copied the connection string from the Visual Studio Server Explorer (same as before) and tested it again. It seems to work fine now. Perhaps there was just something wrong with the connection string in my environment the first time. Anyway, it's working great. Thank you for the response, and for your help. |
|
|
|
