Hi
I have a simple form with 2 adodc data controls on them. I have used ODBC data source name instead of connectionstring in both cases.
Can nayone tell me what is wroing in the following code? It works perfectly if I use connection string but if I use ODBC it wont!!!
Thank in advance


Private Sub Adodc1_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)

With Me.Adodc2
    .ConnectionString = Adodc1.ConnectionString
    If (pRecordset.EOF = True Or pRecordset.BOF = True) Then
        .RecordSource = "select * from Students where Klass_Number = 0"
    Else
        If (IsNull(pRecordset.Fields("Id").Value) Or IsEmpty(Adodc1.Recordset.Fields("Id").Value)) Then
            .RecordSource = "select * from Students where Klass_Number = 0"
        Else
            If (IsEmpty(pRecordset.Fields("Id").Value)) Then
                .RecordSource = "select * from Students where Klass_Number = 0"
            Else
                .RecordSource = "select * from Students where Klass_Number = " & pRecordset.Fields("Id").Value & " order by Last_Name"
            End If
        End If
    End If
    .CommandType = adCmdText
    .Refresh
    txtCA.Text = Round(CAv, 2)
    End With

    StudentDataGrid.Columns.Item(1).Width = 0
    Exit Sub

End Sub

Hi,

   I am a very beginning VB database coder, but an ODBC relies on the data source being configured on your machine beforehand, unless you create a system/file DSN earlier in your code. This is something I do with scripts I write that connect to databases using this method. That way I am sure the DSN is there, and I know what name to use to reference it.

   I hope this helps.

mmcdonal

Hi Friend..

I'm begginer for this field...
can you tell me sth that why should we use this procedure instead of
DSN. Does it has some advance feature.. Pls reply me





Dipu