Home > Archive > MS SQL Server DTS > June 2005 > parameters while accessing Oracle Database









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author parameters while accessing Oracle Database
KC

2005-06-23, 11:23 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..



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com