在ASP.NET中,我用OleDb方式连接ORACLE,但是在测试查询中出错:
ora-00936 :missing expression

解决方案 »

  1.   

    SQL语句错误,把SQL语句贴出来看看~!
      

  2.   

    <html xmlns="http://www.w3.org/1999/xhtml" >
    <head runat="server">
        <title>无标题页</title>
    </head>
    <body>
        <form id="form1" runat="server">
        <div>
            <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString3 %>"
                ProviderName="<%$ ConnectionStrings:ConnectionString3.ProviderName %>" SelectCommand="SELECT [SBID], [SBCNAME] FROM [SCM_SUPPLIERBASE]">
            </asp:SqlDataSource>
        
        </div>
        </form>
    </body>
    </html>
      

  3.   

    <add name="ConnectionString" connectionString="Provider=MSDAORA;Data Source=xxxxxx;Persist Security Info=True;Password=xxxxx;User ID=xxxxxx"
       providerName="System.Data.OleDb" />