I'm trying to use the SSIS "OleDB Data Source" object to create a
connection to our Informix DB. I'm not having any luck. I'm totally unsure
about how to translate our working connection string parameters into
SSIS OleDB Object properties.

Any help would be greatly appreciated ... Thanks in advance!

Barry
in Oregon

THE SPECIFICS ...

ENVIRONMENT: We have a major data entry (and bunches of other) C# .Net
applications SUCCESSFULLY CONNECTING to our Informix DB on a daily basis
with no problems what so ever using OleDB. The connection string paramaters
are similar to those below. I have the newest (2.90) Informix OleDB drivers
loaded and they work fine with our C# & Web apps. So I know for certain
that OleDB connections can be successfully established from MS Apps to our
Informix DB.

CONNECTION STRING:
PROVIDER=Ifxoledbc.2;
DATA SOURCE=owrd;
User ID=xxxxxx;
HOST=xx.yy.zz.aa.us;
SERV=owrd_service;
SRVR=owrd;
PRO=onsoctcp

QUESTION: I can't figure out how to configure an SSIS "OleDB Data Source"
object to connect to our Informix database ... the OleDB Source Editor
presents totally unfamiliar Lingo and Options ... So I've got a number of
questons ... I'm definitely a stranger in a strange land with this SSIS
stuff.

1st and formost is how to I translate the above connection string into SSIS
"OleDb Data Source" Editor fields & options.

MY RESEARCH EFFORTS THUS FAR: If I click NEW a few times from the OleDb I
eventually come to a Connecton Manager window. There I can click the Data
Links button and select our Infomix OleDB data provider. Clicking the Data
Links button again causes a Data Link properties window to appear ... dual
purpos button - kind of wierd/unexpected behavior, plus it removes the
ability to change your Data Link selection if you just happened to click on
an incorrect option ...

The Data Link properties window provides 3 Tabs "Connection", "Advanced" &
"All"

The "Connection tab" asks for a Data Source and/or Location of the data ...
I've tried bunches of guesses here but I've had no success.
The Advanced Tab provides one option that can be edited "Connection
Timeout" - I'm assuming the 0 seconds value means basically no time out.
The All Tab provides Connection Time, Data Source, Extended Properties,
Password, Persist Security Info, and User ID options - again I've tried a
bunch of guesses here with no success.

If I select the All Option from the Connection Manager side panel I get the
following options

[Extended Properties] - can't find anything in the BOL or online to explain
what might work here (I'm guessing that their Informix Extended property
options)
[Connecton Timeout] - seems to be a favorite option and always defaults to 0
[File Name] - which I figured after some searching around wants the file
name for a UDL file ... I created a UDL file that successfully connected
with the UDL editor I'm using but wouldn't connect with the SSIS Connection
Manager "Test Connection".
[OleDB Services] - which is set to default - don't have a clue as to what
options might want to go in here.
[Password] - I have a pretty good guess what might go here
[Persist Security Info] - don't think it's really a part of the Informix
OleDB provider
[Data Source] - who know's, I've tried just about every incantation I can
think of. (i.e. Connection string permutation / combination)
[Provider] - is hard wired to Ifxoledbc.2 which should be correct.

ANY HELP anyone may be able to provide getting the "OleDB Data Source" to
use the Informix OleDB connector to connect directly to our Informix DB
would be greatly appreciated.

Thanks in advance,

Barry
in Oregon

Hello Barry,

I am not quite sure about for Informix because there is on buitl in OLE
provider for it but you could try the following steps:

1. Open the existing SSIS project.
2. On the right panel, right click Data Sources, and click New Data Source.
3. Click New button to create a new Data souce.
4. On Provider, select the Informix oledb provider you want to use
5. Select the server name, username, password etc which is UI provided by
Informix oledb provider.
6. Click OK
7. You could double click the data connection you created to see the
connection string.

Hope this is helpful.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Peter,

Thanks for the reply. It's very much appreciated. I'm in the midst of
upgrading our Sql Server from the CTP version to the RTM version.
I'll give your solution a try as soon as I can get everything backup and
into a functional mode. Shouldn't be long. I've got developers outside the
machine room door with pitch forks and torches.

Barry
in Oregon



"Peter Yang [MSFT]" <petery (AT) online (DOT) microsoft.com> wrote