October 8, 2007 at 11:11 am
I hope I'm posting in the right section
Here goes...I'm developing an application which needs to interface with Ingres. My main Db engine is Sql Server 2000, and the interface is done via a DTS which "should" execute some parameterized queries against the Ingres DB.
Before entering the parameterized criteria the statements execute fine...however after including the parameter place holder "?" i get the following error (message prompt):
---------------------------
Package Error
---------------------------
Error Source : Microsoft OLE DB Provider for ODBC Drivers
Error Description : Provider cannot derive parameter information and SetParameterInfo has not been called.
---------------------------
OK
---------------------------
As you can see...I'm using ODBC drivers to establish the Ingres connection....
I'd appreciate any help you can give.
October 8, 2007 at 11:42 am
How did you set up the parameters? You cannot just pass the value from one database to another one.
You need to set up Dynamic property to set up a value to get the parameter from the other database, then set up another value to edit the sql server query to use the value of the parameter.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply