October 28, 2002 at 3:17 pm
In an effort to work around another issue with an Intersolv Informix5 ODBC driver, I am trying to create a dynamic Execute SQL task using Parameter mapping of Global Vars.
If I select a data source using the Intersolv driver, I can't get the drop-down boxes to work on the input screen in Parameter Mapping. If I select an Oracle data source, it works fine.
I'd love to use a different driver, but can't. There just don't seem to be any better drivers out there.
I've tried using ADO recordsets in ASP. I've tried creating a custom ActiveX object on the server and calling it ASP. I've now tried an ActiveX task in DTS, but in order to use it effectively, I need to have a dynamic SQL task in front of it to move the data into a recordset. The ActiveX code works like a charm if I use a static query to get the recordset.
I considered using SELECT * from Table_name, but this would result in a recordset of 300,000 rows.
Where do I go from here? Does anyone know why I can query this data source from DTS, but not use Parameter Mapping? I've just about run out of ideas- and this is the last piece I need to roll out my project.
October 28, 2002 at 5:00 pm
I called the vendor that sells/supports the systems I am trying to query. They just laughed and told me it won't work with the drivers I'm using. They suggested alternate drivers (at a cost of ~$10,000 for enough licenses). That's not gonna fly.
That's when I had a moment of inspiration. I realized that one of the Crystal Reports tools that we use performs pass-through queries in MS-Access to get data from these data sources. I always thought it was because our vendor just didn't want to spend the time to create InfoViews for Seagate. Then, in a flash, I had the thought that they may be using Access in order to gain functionality...
So I created an MS-Access DB to pass my queries through... and whadda ya know... it works.
I hate to introduce yet another application into the project, but at least it works...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply