0

Hi there,
I'm new to this sqlserver package. Is VB6 can able to work with this package like connectivity issues?. Can somebody advice me about this because my previous experience is purely on ms access database as backend front end vb6. thnx in advance..

newvbguy

2
Contributors
2
Replies
3
Views
11 Years
Discussion Span
Last Post by NewVBguy
0

Hi there,
I'm new to this sqlserver package. Is VB6 can able to work with this package like connectivity issues?. Can somebody advice me about this because my previous experience is purely on ms access database as backend front end vb6. thnx in advance..

newvbguy

Option Explicit

Dim dbCn As String
Dim Cn As ADODB.Connection

dbCn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dbEvaluation;data source=jeff1;Workstation ID=jeff"

Set Cn = New ADODB.Connection
Cn.Open dbCn

for connection to sql...

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.