Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with adding new record to Oracle table Via VB5.0
On 8 May 1998 02:40:38 GMT, "G Vaidhyanathan" <root1_at_sprintmail.com> wrote:
>Hello:
>
>I have a problem adding new records to an Oracle table thro' a VB form.
>The recordset.addnew command gives an error saying that the recordset is
>opened as Read Only. Could someone help me give a solution for this?
>
>I really appreciate this help. I have used VB with MS Access a lot and I
>have not faced this problem.
>
>One more question. How to I avoid the entry of username and password when
>connection to Oracle from VB form. Oracle opens the login window even I
>specify userid and password in the connect string.
>
>Thanks in Advance
>-ganesh
ReadOnly can be caused by many things, the most frequent is failure to have a PK constraint on a column, (at least one column with a combination of UNIQUE and NOT NULL contraints). Received on Fri May 08 1998 - 00:00:00 CDT