SQL Connection Issue


Author
Message
Larry Caylor
Larry Caylor
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K

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;

 

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search