Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Mamatha
Posting Yak Master
102 Posts |
Posted - 2005-04-27 : 21:54:49
|
Hi ,I have to develop an application such that i have to use the port number in the sql connection string in asp.net.How to specify the string plz help me out.Regards,Mamatha.Mamatha |
|
jhermiz
3564 Posts |
Posted - 2005-04-27 : 22:27:46
|
quote: Originally posted by Mamatha Hi ,I have to develop an application such that i have to use the port number in the sql connection string in asp.net.How to specify the string plz help me out.Regards,Mamatha.Mamatha
One way to do it is to connect via the IP address."Data Source=122.122.122.122,1433;Network Library=DBMSSOCN;Initial Catalog=Northwind;User ID=YourUser Password=YourPassGoesHere;" (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))Here's a great site for more info:http://www.connectionstrings.com/ Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|