TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
0
)
Change OLE Link Path in Word Documents
DataGrid accessing and Excel 11.0 Object Library