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 Guys, I'm getting this error when tryng to connect to SQL server 2000 db, Mindscape.LightSpeed.Generator.Model.GenerationException: Unsupported Server Explorer connection type 'System.Data.OleDb.OleDbConnection' Am i being thick, i'm sure i have done this before? Thanks Again, Josh |
|
|
By the way i'm trying to drag and drop tables onto the lightspeed model. |
|
|
Hmm more over in Visual Studio 2008 I can use the .Net Framework Provider for SQL server where as in VS 2010 that provider only supports SQL Server 2005+. Could this be the issue ? Upgrading the DB is not really an option, do you guys know any work arounds? |
|
|
Connecting the designer up to SQL Server 2000 is a slightly manual exercise. You need to click the model background, go to the Properties window, and manually enter the connection string and select the SqlServer2000 data provider. Otherwise LightSpeed will try to use the 2005 provider. Also, to support dragging you must be using a Server Explorer connection that is set up to use the native (ADO.NET) provider rather than OLE DB. |
|
|
This approach works fine in VS2008 but VS2010 I can't connect to a SQL Server 2000 DB anything but the OLE DB connection. |
|
|
I have added a workaround so that if you drag on a table from a SQLOLEDB connection the designer will treat it as SQL Server 2000. In order to do this I am having to pull apart the OLE DB connection string and rebuild it as an ADO.NET connection string. This should work fine for the data source and initial catalog, but at the moment I am only handling "Integrated Security=SSPI" for the security settings. If you are using username/password authentication then please let me know (and ideally provide me with an anonymised version of your connection string, because I don't have a username/password testbed) so I can add support for this. This feature will be in the 16 Sept nightly. As always, please let us know if you run into any issues. |
|
|
I'm impressed, thanks Ivan, were using Windows Authentication for development but when we go to production it is pulling usernames and passwords out of config. So for this to work will i simply need to reference the nightly build DLL's or will I have to reinstall LightSpeed on my machine? Thanks Again, Josh |
|
|
The OLEDB workaround is used *only* during the dragging of tables from Server Explorer onto the designer -- it is *not* invoked at runtime -- so we don't need to worry about it supporting the production database, only the dev database. Sounds like what I've done should be enough (and if not I'm sure you'll let me know!). Yes, you will need to reinstall LightSpeed. |
|
|
Hi Ivan, I'm just trialling NHibernate Designer and have had exactly the same issue. I know that "officially" NHibernate Designer doesn't support SQL Server 2000 but is there any chance of the above LightSpeed workaround also being added to NHibernate Designer or are there too many other issues that I haven't come across yet? Thanks, Callum |
|
|
Hi Callum, We've updated the NHibernate designer with the OLE DB workaround and you should be able to get the latest version from the Visual Studio Gallery (check the Updates tab in Extension Manager, though this can be a bit slow). Let us know if you run into any problems! |
|
|
Perfect, thank you very much! I'm very impressed with your support by the way! Callum |
|