VB.net help

[Laknath]

VB.net danna aya ennvanam help ekak dennako connection string eka hema PC ekakatama hariyana widihata hadane kohomda?

 

[Laknath]

koo danna karuwath nedda?

 

[Laknath]

bump

 

[kosandpol]

ask to enter the server name or server ip the first time the application is run and save it to the registry.

 

[Laknath]

pehedili madi banzz

 

[Blaster1234]

VB.net danna aya ennvanam help ekak dennako connection string eka hema PC ekakatama hariyana widihata hadane kohomda?

mokakda wenna one kiyala explain karapan

 

[Laknath]

den api database connect karhama ape PC eke pennwane ape severname ekane. eka wena PC walata demahamath weda karana widihata hadana kohomada?

connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"

 

[kosandpol]

den api database connect karhama ape PC eke pennwane ape severname ekane. eka wena PC walata demahamath weda karana widihata hadana kohomada?

connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"

Data Source=ServerName

servername වෙනුවට server IP,server port දාන්න. sql server එකේ tcp/ip enable කරන්න fixed port එකක් assign කරන්න.

 

[Laknath]

thnks try karala balannam

 

[Mihindu_Gajaba]

macho "." eka use karala balanna, without/q , but not if its running over a network , i mean if your using a standalone software ( 1 client software & the server is the same ) "." is correct , because "." mean that the local machine , so that it will work, but if your using more than one machine ,if your using a server to maintain the db and access it from client systems , then, yes you have to specify a IP Address ( Server IP ) , in your case i think your asking about a single instance so "." is correct