ADawn
Registered: 05/17/09
Posts: 13
|
|
|
Reply with quote | #1 |
When creating my ISD application, as my Database Server, I select one of the items from the drop-down list that ISD provides me. In this case,
I select the Microsoft SQL Server instance named D9WWC542\MAKSERVER.
I click [Test Connection] all is good, however, the correct spelling of this instance is D9WWC542 \MAKSERVER with a space in it. So, I edit the instance with the space, but now ISD says it doesn't exist and the test connection fails. At this point, I proceed with what ISD assumes is correct,
D9WWC542\MAKSERVER without the space.
Moving on, I select NEXT to go to create pages. After about thirty seconds, my D9WWC542\MAKSERVER (without the space) appears in the right column (... for these 0 tables) and no tables are present for me to select from.
Trust me: When I look at the server instance name in MS SQL Server Management Studio, D9WWC542 \MAKSERVER appears with the space in it.
If I test the connect within MS SQL Server Management Studio it works find, however, if I remove the space in MS SQL Server Management Studio the connection fails.
Is ISD removes spaces when it is gathering items for the drop-down list when it looks for instances?
Any thoughts.
ADawn
|
| |
timt
Iron Speed MVP
Consulting Organization
Registered: 08/06/05
Posts: 1,113
|
|
|
Reply with quote | #2 |
Hi
Spaces.... The bain of all programmers! As a general piece of advice avoid where possible in names of any kind, they just always come back to bite you.
I would edit the web.config and correct the connection string by hand and try again. (Reload ISD after making the change)
HTH
__________________
Tim Titchmarsh
UK Iron Speed MVP
Dot Net Architect
+44 (0)1621 857758
http://www.dotnetarchitect.co.uk
timt@dotnetarchitect.co.uk |
| |
ADawn
Registered: 05/17/09
Posts: 13
|
|
|
Reply with quote | #3 |
It was done by accident, the [space] that is!
What is mean by (Reload ISD after making the change)? I'm a Newbie, thanks.
ADawn
|
| |
timt
Iron Speed MVP
Consulting Organization
Registered: 08/06/05
Posts: 1,113
| |
ADawn
Registered: 05/17/09
Posts: 13
| |
RSS(.NETCodeGenerationIsHere).gif)
