wwwddd

wwwddd

  • NA
  • 1
  • 0

error in Access 2000

Jun 15 2004 12:13 PM
error with long integer type in Access 2000 in recordset on Win 2000 with SP4 and MDAC 2.8 (andWin 98 too) has type of adInteger already known in earlier versions http://dbforums.com/t859726.html no errors on Win XP and Access 2003 need to get this running! exception text ?ex.ToString "System.Runtime.InteropServices.COMException (0x80020008): Falscher Variabletyp. at ADODB.Field.set_Value(Object pvar) at LongAccessTest.frmTest.btnSave_Click(Object sender, EventArgs e) in E:\projekte\LongAccessTest\frmTest.vb:line 89" VB.NET code example: cnn.Open(strPrvdr) rs.ActiveConnection = cnn rs.Open("select field1 from t1", cnn, ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockOptimistic, ADODB.CommandTypeEnum.adCmdText) Dim lngNr As Long = Convert.ToInt64(txtInput.Text) Try rs.AddNew() rs.Fields("field1").Value = lngNr ' this is where the exeption is thrown because of recordset adInteger despite setting db field to long integer rs.Update() Catch ex As Exception Debug.WriteLine(ex.ToString) End Try how to solve this? didnĀ“t find any update to fix DLL error, thanks for help