RE: How can i connect direct to SQL SERVER

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris Stransky (ChrisStransky_at_discussions.microsoft.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 10:23:02 -0700

The same code will work with the exception of changing UID to User Id

e.g.

aConn.ConnectString = "server=x;database=x;User ID=x;Pwd=x";

"Mis Dep." wrote:

> Dear all
>
> i use vb 6.0 connect to sql 2000 server like this code, but if i use
> vb.net 2003 connect direct to SQL server.
> How can i code in vb.net 2003 (look like same vb code)
>
> Brg
> TignN@ng
>
>
> Public Function ConnectServer(cServer, cUser, cPass, cDatabase) As String
> Dim cString As String
> cString = "DRIVER={SQL Server};" & _
> "SERVER=" & cServer & ";UID=" & cUser & ";PWD=" & cPass &
> ";DATABASE=" & cDatabase
> ConnectServer = cString
> End Function
>
>
>

Relevant Pages