'3027' Error problems with ODBC Database connections 
Author Message
 '3027' Error problems with ODBC Database connections

I am writing a simple interface to retrieve data from a Personal
Oracle Database. I can connect and query  fine but I have not been
able to write any data to the database with AddNew or trying to
Update.
I looked at Microsoft's answer:

http://www.***.com/
but it was no help. I have full access to the database, but no matter
what I do, I always end up with Read-Only access. Anyone have any
ideas.

Thanks
Bob

Option Explicit
Dim sConnect As String
Dim dbExample As Database
Dim rsExample As Recordset
Dim wsExample As Workspace
Dim sSQL As String

--------------------------------------------------------------------------------------------------------------

Private Sub Get_Data_Click()

Set wsExample = DBEngine.Workspaces(0)

sConnect = "ODBC;DATABASE=BEQ-LOCAL;UID=SCOTT;PWD=TIGER;DSN=Oracle7"

Set dbExample = OpenDatabase("", dbDriverNoPrompt, False, sConnect)

Set rsExample = dbExample.OpenRecordset("BOOKS", dbOpenDynaset, 0,
dbOptimistic)

Text1.Text = rsExample.Fields("Title").Value
Text2.Text = rsExample.Fields("Author").Value
Text3.Text = rsExample.Fields("Type").Value

End Sub

--------------------------------------------------------------------------------------------------------------

Private Sub Update_Click()

wsExample.BeginTrans

     With rsExample
        .Edit
        !Title = "TEST"
        .Update
     End With

wsExample.CommitTrans

End Sub

--------------------------------------------------------------------------------------------------------------

Private Sub Add_Click()

With rsExample
        .AddNew
        !Title = Text4.Text
        !Author = Text5.Text
        !Type = Text6.Text
End With

End Sub



Fri, 09 Nov 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Run time Error: 3027: Can't update database or object is readonly

2. Problem with Error 3027 (long - I've included a lot of code)

3. Error 3027 w/ ODBC connection

4. can't update 3027

5. ODBC--connection to 'Database' failed

6. Odbc error following 'odbc components error'

7. Error '3027' Can't Update...

8. VB6.0 ODBC Error 3027 SQL Server 7.0

9. VB6.0 ODBC Error 3027 SQL Server 7.0

10. VB6.0 ODBC Error 3027 SQL Server 7.0

11. VB6.0 ODBC Error 3027 SQL Server 7.0

12. Error with ASP Connection - error '80004005'


 
Powered by phpBB® Forum Software