Multiple SQL statement problem
From: evgenyv <evgenyv_at_yahoo.com>
Date: Tue, 20 Aug 2002 08:12:08 +0000
Message-ID: <1716024.1029831128_at_dbforums.com>
Date: Tue, 20 Aug 2002 08:12:08 +0000
Message-ID: <1716024.1029831128_at_dbforums.com>
Hi!
'm_sConnStr = "Provider=MSDAORA;Password=aaa;User ID=user;Data
Source=ds1"
A can't run the multiple sql statement with Oracle DB. I'm using ADO
2.7.
What is wrong in follow example?
m_sConnStr = "Provider=OraOLEDB.Oracle;Password=aaa;User ID=user;Data
Source=ds1"
m_Conn.Open m_sConnStr
m_Conn.CursorLocation = adUseClient
Dim str1 As String
Dim str2 As String
Dim str3 As String
str1 = "select * from test1 where id = 'www' ;" & vbCrLf
str2 = "select * from test2 where id = 'eee';"
str3 = str1 + str2
Set m_Rs = m_Conn.Execute( str3 ) - throw error "Invalid character" (
but this statement does run properly from Oracle SQL+ )
m_Rs.Close
BTW in MSSQL does work properly.
Thanks in advance
-- EvgenyV Posted via http://dbforums.comReceived on Tue Aug 20 2002 - 10:12:08 CEST