when using SqlDataSource and Oracle 11g data the SQL wizard generates the wrong code for oracle see below:
also when I drag and drop a table from the server explorer into an aspx page nothing happens. It should create a gridview and SqlDataSource for the table.
Why is VS generating code fo MSSQL / MSAccess ? Have I installed something wrong? This did work under 10g.
ODAC ver = 11.1.0.6.21
ODT ver = 11.1.0.6.20
Oracle Data ver = 11.1.0.7.0
web.config:
<connectionStrings>
<add name="IMODB" connectionString="DATA SOURCE=IMODB;PASSWORD=imomain123;PERSIST SECURITY INFO=True;USER ID=IMONET"
providerName="Oracle.DataAccess.Client" />
</connectionStrings>
default.aspx
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="DATA SOURCE=IMODB;PASSWORD=xxxpwd123;PERSIST SECURITY INFO=True;USER ID=IMONET"
DeleteCommand="DELETE FROM [MENU] WHERE [ITEM] = ? AND ((URL = ?) OR ([URL] IS NULL AND ? IS NULL)) AND (([PARENT] = ?) OR ([PARENT] IS NULL AND ? IS NULL)) AND (([TOOLTIP] = ?) OR ([TOOLTIP] IS NULL AND ? IS NULL)) AND (([SORT_ORDER] = ?) OR ([SORT_ORDER] IS NULL AND ? IS NULL)) AND (([TARGET] = ?) OR ([TARGET] IS NULL AND ? IS NULL))"
InsertCommand="INSERT INTO [MENU] ([ITEM], [URL], [PARENT], [TOOLTIP], [SORT_ORDER], [TARGET]) VALUES (?, ?, ?, ?, ?, ?)"
OldValuesParameterFormatString="original_{0}"
ProviderName="Oracle.DataAccess.Client" SelectCommand="SELECT * FROM [MENU]"
UpdateCommand="UPDATE [MENU] SET [URL] = ?, [PARENT] = ?, [TOOLTIP] = ?, [SORT_ORDER] = ?, [TARGET] = ? WHERE [ITEM] = ? AND (([URL] = ?) OR ([URL] IS NULL AND ? IS NULL)) AND (([PARENT] = ?) OR ([PARENT] IS NULL AND ? IS NULL)) AND (([TOOLTIP] = ?) OR ([TOOLTIP] IS NULL AND ? IS NULL)) AND (([SORT_ORDER] = ?) OR ([SORT_ORDER] IS NULL AND ? IS NULL)) AND (([TARGET] = ?) OR ([TARGET] IS NULL AND ? IS NULL))">
<DeleteParameters>
<asp:Parameter Name="original_ITEM" Type="String" />
<asp:Parameter Name="original_URL" Type="String" />
<asp:Parameter Name="original_PARENT" Type="String" />
<asp:Parameter Name="original_TOOLTIP" Type="String" />
<asp:Parameter Name="original_SORT_ORDER" Type="Decimal" />
<asp:Parameter Name="original_TARGET" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="URL" Type="String" />
<asp:Parameter Name="PARENT" Type="String" />
<asp:Parameter Name="TOOLTIP" Type="String" />
<asp:Parameter Name="SORT_ORDER" Type="Decimal" />
<asp:Parameter Name="TARGET" Type="String" />
<asp:Parameter Name="original_ITEM" Type="String" />
<asp:Parameter Name="original_URL" Type="String" />
<asp:Parameter Name="original_PARENT" Type="String" />
<asp:Parameter Name="original_TOOLTIP" Type="String" />
<asp:Parameter Name="original_SORT_ORDER" Type="Decimal" />
<asp:Parameter Name="original_TARGET" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ITEM" Type="String" />
<asp:Parameter Name="URL" Type="String" />
<asp:Parameter Name="PARENT" Type="String" />
<asp:Parameter Name="TOOLTIP" Type="String" />
<asp:Parameter Name="SORT_ORDER" Type="Decimal" />
<asp:Parameter Name="TARGET" Type="String" />
</InsertParameters>
Please help me figure this out. I think it must be a cofiguration problem
R/Brian