.NET OLE DB Connection

[Barry Young]

I am using the following code to insert a row in an Oracle Database.

strConnection = "Provider=OraOL EDB.Oracle;Data Source=MYDATABA SE;User
Id=SYSTEM;Passw ord=******"

Dim strMessage As String

Dim objConnection As New OleDb.OleDbConn ection(strConne ction)

Dim objCommand As OleDb.OleDbComm and


objConnection.O pen()

objCommand = New OleDb.OleDbComm and(strSQL, objConnection)

objCommand.Exec uteNonQuery()

objConnection.C lose()



Now the strSQL string inserts a row when I cut and paste it in to PLSQL
(SQL+). But when I execute the above code with the same SQL string, I get
an Invalid Character Error. ORA-00911.



Any Ideas??