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 |
|
ram02455
Starting Member
3 Posts |
 Posted - 2007-12-04 : 08:38:36
|
| hiii..I have developed a application using VB.NET(windows application) as front end and sql server 2000 as backend..Now can you tell me that what will be sql connection string to connect to a sql server which is located in another computer from my application.All the computers r connected via LAN. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-12-04 : 08:43:51
|
| www.connectionstrings.comMadhivananFailing to plan is Planning to fail |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
|
|
ram02455
Starting Member
3 Posts |
Posted - 2007-12-04 : 09:25:13
|
| Hi.. Thanks for the reply.Can you please tell me that how to connect to a server located in another sytem connected on LAN.By your previous post i can see that there is only server address in the connection string,how am i suppose to know the instance of the server running on that machine.Thanks |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-04 : 09:29:03
|
| Don't you to which SQL Server instance you are going to connect?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
ram02455
Starting Member
3 Posts |
Posted - 2007-12-04 : 09:42:49
|
| Am using SQL server 2000 professional edition.My application is Client Server one.I hope you understand.I have SQL server running on a machine connected to a LAN.I have installed my application in all the machines connected to that LAN.Now the Problem is that when i try to connect to that SQL server Via LAN i get an error listed as "Server not found".The connection string am currently using is given below:Dim str as Stringstr = "Server=" & servername & ";Database="Database name";uid="user id";pwd="password";Network Address=" & networkadd & ";" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-04 : 10:06:50
|
Are you sure the network address matches the server name?Drop the network address part!
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Please help me.....
Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"