dbTalk Databases Forums  

parameters while accessing Oracle Database

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss parameters while accessing Oracle Database in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
KC
 
Posts: n/a

Default 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..




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.