<div>
hi &nbsp;prederso<br />
<br />
Use This:<br />
<br />
&nbsp; &nbsp;Dim connString As String<br />
&nbsp; &nbsp; Dim conn As OleDb.OleDbConnection<br />
conn=new OleDb.OleDbConnection<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; connString = &quot;Provider=sqloledb;Data Source=localhost;User Id=sa;Initial Catalog=Pubs;&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; conn = New OleDbConnection<br />
&nbsp; &nbsp; &nbsp; &nbsp; conn.ConnectionString = connString<br />
&nbsp; &nbsp; &nbsp; &nbsp; conn.Open()<br />
<br />
<br />
<br />
Regards<br />
<br />
Anil Poonia
</div>


<div>
But can I use Data Source = localhost when i need to access the database on a network?
</div>


<div>
Hi prederso,<br />
<br />
Just drag a sqlconnection from the toolbox onto your form and fill in the wizard. You can than look in the windows generated code if you are interested in the complete code.<br />
<br />

</div>


<div>
here is a great site, I use it all the time.<br />
<br />
<a href="http://www.connectionstrings.com/" rel="ugc">http://www.connectionstrings.com/</a>
</div>


<div>
<div class="content wysiwyg-content">
I have just started looking into VB.NET but are having problems making a database connection. The connection I used in VB6 looked like this:<br />
<br />
Set Cn = CreateObject(&quot;ADODB.Connec<wbr />tion&quot;) <br />
Cn.Open(&quot;driver={SQL Server};Server=serv1;netwo<wbr />rk=ps;uid=<wbr />ts;pwd=ts;<wbr />database=t<wbr />elesales&quot;)<wbr /> <br />
<br />
What would that connection looke like in .NET??
</div>
</div>


I have just started looking into VB.NET but are having problems making a database connection. The connection I used in VB6 looked like this:

Set Cn = CreateObject("ADODB.Connection") 
Cn.Open("driver={SQL Server};Server=serv1;network=ps;uid=ts;pwd=ts;database=telesales") 

What would that connection looke like in .NET??

hi  prederso

Use This:

   Dim connString As String
    Dim conn As OleDb.OleDbConnection
conn=new OleDb.OleDbConnection

        connString = &quot;Provider=sqloledb;Data Source=localhost;User Id=sa;Initial Catalog=Pubs;&quot;
        conn = New OleDbConnection
        conn.ConnectionString = connString
        conn.Open()



Regards

Anil Poonia

But can I use Data Source = localhost when i need to access the database on a network?

Hi prederso,

Just drag a sqlconnection from the toolbox onto your form and fill in the wizard. You can than look in the windows generated code if you are interested in the complete code.



here is a great site, I use it all the time.

http://www.connectionstrings.com/

Connection from VB6 to .NET

I have just started looking into VB.NET but are having problems making a database connection. The connection I used in VB6 looked like this:

Set Cn = CreateObject(&quot;ADODB.Connection&quot;) 
Cn.Open(&quot;driver={SQL Server};Server=serv1;network=ps;uid=ts;pwd=ts;database=telesales&quot;) 

What would that connection looke like in .NET??

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,