parameters while accessing Oracle Database -
06-23-2005
, 10:02 AM
I am trying to use a parameter query in DTS to Access an Oracle database
such as :
select field1, field2 from table where create_date > ?
It works fine when going against a SQL server Db..but when I use it to go
against an Oracle db (using MS OLE DB provider for Oracle connection - which
is Ok when I take out the parameter!) It is Ok when I select parse
query..but when I select the parameter button I get the message ..."provider
cannot provide parameter information and SetParameterInfo has not been
called"..
Thanx for any help.. |