November 28, 2007 at 2:12 pm
I am designing an application that will use SQL Server Express, and I setup an alias on the server. In my application I create a database connection, and in the connection string I specify the alias. Do I specify the alias as part of the the data source, and furthermore, if I do that, how does the application know that my alias leads to a specific server. I guess what I'm asking is that if I use an alias to specify the server, how does my application even know where to look for the alias so that it can see where the real server is?
To reiterate: I connect using cn = New SqlConnection("Data Source=Jack;" ..., how does the application know what Jack is?
Please help alleviate my confusion.
November 28, 2007 at 2:44 pm
On the client it would not know what Jack is unless you create the alias on the client machine in some manner such as the host file, the registry or other method.
November 29, 2007 at 6:18 am
That makes sense. Thank you.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy