.NET OLE DB Connection

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

strConnection = "Provider=OraOLEDB.Oracle;Data Source=MYDATABASE;User Id=SYSTEM;Password=******"

Dim strMessage As String

Dim objConnection As New OleDb.OleDbConnection(strConnection)

Dim objCommand As OleDb.OleDbCommand

objConnection.Open()

objCommand = New OleDb.OleDbCommand(strSQL, objConnection)

objCommand.ExecuteNonQuery()

objConnection.Close()

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?? Received on Mon Aug 18 2003 - 06:01:28 CEST