-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: THESOFTWAREARCHITECT
Message 2 in Discussion
Hi Akshay, All you need to access SQL Server remotely is just by knowing the
remote server's IP address and port number. the default instance port number
is 1433. For example: Your connection string would be VB Try Dim cn as
New SQLConnection("data source="123.34.2.1:1433;userid="Your SQL User ID or
Windows ID";password="Your Password";Database="Northwind") Catch
msgBox(SQLException) End Try C# Try SQLConnection cn = new
SQLConnection("data source="data source="123.34.2.1:1433;userid="Your SQL User
ID or Windows ID";password="Your Password";Database="Northwind"); Catch
string str ="Error"; MessageBox.Show(str).ToString(); Hope this helps :)
Best Regards
Anil Mahadev
http://anilm001.myfreewebs.net/index2.php
http://www.dotnetmonster.com/CS/blogs/db2dotnetczar/default.aspx
http://www.db2india.org
Be not afraid of greatness:
some are born great, some achieve greatness, and some have greatness
thrust upon them.
William Shakespeare
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
