Hi, I have an Oracle/RDB database. I am using ODBC to connect to it. I am also using a TableAdapter. Non-Parameterized queries work fine. However, I do not know how use a parameter query. I cannot use @param or :param. I tried ? and I can get the parameter
to work, but the underlying .xsd code breaks because it cannot map the dbtype ? to and odbctype. It cannot map ? to anything, which makes sense. Thanks.
johnnyWebPag...
Member
10 Points
37 Posts
How do I use ODBC and a TableAdapter with Parameters with non-SQL Server Database?
Jun 16, 2008 03:34 PM|LINK
Hi, I have an Oracle/RDB database. I am using ODBC to connect to it. I am also using a TableAdapter. Non-Parameterized queries work fine. However, I do not know how use a parameter query. I cannot use @param or :param. I tried ? and I can get the parameter to work, but the underlying .xsd code breaks because it cannot map the dbtype ? to and odbctype. It cannot map ? to anything, which makes sense. Thanks.
oracle oracle/rdb odb dbtype parameter query tableadapter