sql coonection help

[giramala]

machanla udawak ona

kohomada vb6 walin network workgroup ekekak tiyana sql server connect karanne

 

[Kasun k]

Uba ahanne Remote server akakata connection aka hadagannada???

 

[giramala]

machan mama sql server eka install kara computer ekaka eka network karala tiyenne workgruop hetiyata server ekak vidiyata newei mekata vb6 walin link ekakk hadaganne danne neha mama BIT karanawa project ekakata

 

[kosandpol]

Whats the SQL server version ? connection string changes depending on the SQL server version.

 

[Kasun k]

Ko balanna ube connection string aka deepan

 

[rosharavinda]

Shared connstring As String = "data source=Localhost\SQLEXPRESS; initial catalog=master; integrated security=true"

Dim conn As New SqlConnection(connstring)

 

[Mesozoic]

Change the Connection String that's all then you can proceed with rest of codes

http://www.connectionstrings.com/sql-server-2008

 

[Kasun k]

Shared connstring As String = "data source=Localhost\SQLEXPRESS; initial catalog=master; integrated security=true"

Dim conn As New SqlConnection(connstring)

Machan, Uba remote machine akaka DB aka thiyenawa nam connectionstring ake localhost kiyala danna baha. Ara machine aka e IP akai danna ona..

 

[kosandpol]

Shared connstring As String = "data source=Localhost\SQLEXPRESS; initial catalog=master; integrated security=true"

Dim conn As New SqlConnection(connstring)

connstring="Data Source =WINS_NAME_OF_SERVER_OR IP_OF_SERVER; Network Library =DBMSSOCN; Initial Catalog =NAME_OF_DATABASE; User ID =USERNAME; Password =PASSWORD;"

Replace WINS_NAME_OF_SERVER_OR_IP_OF_SERVER with either the server's name on the workgroup or the IP address.
The SQL Server must have tcp/ip enabled and the server must have the firewall configured to allow incoming connections on port 1433