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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 want a connection string with real ip not static

Author  Topic 

miroman2006
Starting Member

9 Posts

Posted - 2011-03-07 : 03:24:04
can i make a connection string with real ip not with static ip if that's right i want it now plz

but you must know i make a remote connection before but in local network
_-_-_-> by this
<add name="ConnectionString" connectionString="Data Source=172.16.100.8,1433;Initial Catalog=Rsms_9_5_2009_amir;Integrated Security=True"providerName="System.Data.SqlClient" />

if you can i want it work with real ip of the server on the internet not static ip

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-07 : 13:19:55
Why not just use the server name instead of the IP address?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

miroman2006
Starting Member

9 Posts

Posted - 2011-03-08 : 02:56:04
I mean the ip of the computer on the internet not in LAN

plz help me if you can
Go to Top of Page

miroman2006
Starting Member

9 Posts

Posted - 2011-03-08 : 03:00:41
and if u can to make aconnection string to remote server with its name on the internet not on the lan send it to me
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-03-08 : 03:18:52
quote:
Originally posted by miroman2006

and if u can to make aconnection string to remote server with its name on the internet not on the lan send it to me



Yes you can. Use DNS name


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

miroman2006
Starting Member

9 Posts

Posted - 2011-03-08 : 03:32:19
PLZ can you send the text of this connection string because i tried more and more

thanks
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-03-08 : 04:28:49
what do you mean ?

you only just replace the IP Address with the DNS name of your server in your connection string.


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

miroman2006
Starting Member

9 Posts

Posted - 2011-03-08 : 05:05:51
ok

thank you alot
Go to Top of Page
   

- Advertisement -