471,122 Members | 1,148 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,122 software developers and data experts.

.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??
Jul 19 '05 #1
0 2512

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by G-Fit | last post: by
11 posts views Thread by pradeep_TP | last post: by
6 posts views Thread by Chris Szabo | last post: by
18 posts views Thread by Rob Nicholson | last post: by
35 posts views Thread by Eric Sabine | last post: by
3 posts views Thread by Martin B | last post: by
20 posts views Thread by fniles | last post: by
3 posts views Thread by fniles | last post: by
reply views Thread by Robert Avery | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.