ODBC Driver For Oracle That Executes Multiple Statements

[demanaz]

I am writing a VB2010 app that reads a SQL command file that contains multiple SQL statements. I've tried multiple ODBC drivers but can't find one that executes multiple statements. Does anyone have any ideas? Am I going down the wrong path?

Sample Code:

' Define variables:
Dim dbORA As New OdbcConnection
Dim rsORA As New OdbcCommand("", dbORA)
Dim srORA As StreamReader

' Create connection string & open connection:
dbORA.ConnectionString = "Driver={Oracle in OraClient11g_home1};Dbq=dbname;Uid=username;Pwd=password;"
dbORA.Open()

' Create streamreader to read SQL statements and store statements in ODBC command variable:
srORA = New StreamReader("C:\statements.sql")
rsORA.CommandText = srORA.ReadToEnd
srORA.Close()

' Execute SQL statements:
rsORA.ExecuteNonQuery()

' Error message:
ERROR [HY000] [Oracle][ODBC][Ora]ORA-00922: missing or invalid option

The error message is misleading because the SQL statements are valid and can be run via SQL Developer or another Oracle utility

[dunfiddlin]

It's nothing to do with the drivers. VB.Net doesn't do multiple SQL statements as a single command. You must set up an array or list of commands and execute them in turn.

[demanaz]

I can execute multiple SQL statements against SQL Server in one command statement. Is this a limitation of VB & Oracle?

[dunfiddlin]

VB yes. Oracle probably not although I've never used it so I can't be definitive about that.