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 |
|
cutepraba
Yak Posting Veteran
53 Posts |
 Posted - 2009-05-30 : 03:43:19
|
| can anyone please give me connectin string for conecting sql server over static ip.connect sql server in visual basicSQL SERVER INSTALLED CPU ->STAITIC IP CPU(connected with LAN)->CLIENT CPU VB Program.My only probelm is static ip and sql server installed in different machines. I can do it in asp, but unable to do in visual basic.EDIT: I tried with connectionstrings.com no use____________Praba |
|
|
paramu
Posting Yak Master
151 Posts |
Posted - 2009-05-30 : 04:19:38
|
| Dim ConStr As String = "Data Source=1.1.1.1; initial Catalog=My_database_Name; User Id=Prabha; Password=cute"dim StrCmd as string="Insert into MyTable (Emp_name) Values ('CutePrabha')con.connectionstring=ConStrcon.open()dim cmd as new sqlcommand(StrCmd,con)cmd.executeNonquery()con.close()Paramu @ PARANTHAMAN |
 |
|
|
|
|
|
Connect sql server via static ip