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

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...

Hi there,
thanks a lot for the code... have a good one.
newvbguy

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.