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