Visual Basic 5 with Informix CLI 2.5
Posted in 1998
Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing
I am trying to edit a field in an ODBC data source using Informix CLI 2.5 from a snippet of code written in Visual Basic 5.0. The problem I am running into is that every attempt I make to insert, or edit a field, I receive an error that the database is read-only. I do know I have insert & edit permissions with this user, as I can manually make changes from within MS Access 97 using the same ODBC datasource and user name. Any ideas? Sub newpassword(password As String) Dim trend As Database, trend_member_key As Recordset informix$ = "ODBC;DSN=maestro;UID=user1;PWD=user;DATABASE=trend;" Set trend = Workspaces(0).OpenDatabase("", False, False, informix$) Set trend_member_key = trend.OpenRecordset("select * from member where loginname='JOHN DOE';", dbOpenDynaset) trend_member_key.MoveLast trend_member_key.MoveFirst trend_member_key.Edit trend_member_key![password] = password trend_member_key.Update trend_member_key.Close trend.Close End Sub Jason Bramble jbramble@trendmls.com