I have both SQL Server 2000 & 2005 installed on my development PC. The default instance is SQL 2000. When I run the Winform sample app against SQL 2000 everything work fine, with the exception that ObjectMapper is not showing dropdowns for Events. When I run the sample app against SQL 2005 I’m able to map the SQL 2005 tables to the objects in ObjectMapper but when I run the app I get a SQL connection error when I try to browse any of the tables.  I’m wondering if there is something in the data access layer that’s failing to process connection strings for named SQL instances correctly.

 

For example my connection string for SQL 2000 is

 

server=hra11938;user id=sa;password=mypassword;

 

For SQL 2005 the connection string is

 

server=hra11938\sql2005;user id=sa;password=mypassword;

 

I've got the combo boxes fixed and they'll be in the next install, probably today or tomorrow. What's the error message you're getting when you try to connect to the SQL Server 2005? You can post a screen shot of the red error window you get or copy the text from it... doesn't matter.