RE: Informix 7.24/ODBC read-only error

Posted in 1999

Buchholz, David — Tue, 27 Apr 1999 19:54:59 -0400 — source: Informix-list mailing list archive (1991-1998)

Is this VB 5? If so, try changing your database access method. Use the remote database object (rdo) rather than the database access object (dao). The VB Help on this should give you the details. Here is an example: To connect: Set gsConn = New rdoConnection With gsConn .Connect = "uid=<uid>;pwd=<password>;dsn=<datasource name>" .EstablishConnection rdDriverNoPrompt, False End With To get data: qystring = "SELECT column1,column2 FROM tab1" Dim qy As New rdoQuery Dim rs As rdoResultset Set qy = New rdoQuery Set qy.ActiveConnection = gsConn qy.SQL = qystring Set rs = qy.OpenResultset Then go through the result set. HTH. -Dave David A. Buchholz Senior Database Administrator Cendant Incorporated david.buchholz@hit.cendant.com Voice: 602.220.5853 Fax: 602.220.5877 -----Original Message----- From: billiam904@aol.com [mailto:billiam904@aol.com] Sent: Monday, April 26, 1999 5:20 PM To: informix-list@iiug.org Subject: Informix 7.24/ODBC read-only error I'm trying to write a Visual Basic program to update Infromix tables and I'm getting the error that my table or object is read-only. I checked my rights and I have full access rights to the Informix database. Anyone have any ideas?