Search found 6 matches

by mmallory
Sat Sep 19, 2009 6:31 pm
Forum: General
Topic: DataStage 8.1 Installation is deleting MS ODBC Drivers
Replies: 0
Views: 925

DataStage 8.1 Installation is deleting MS ODBC Drivers

Hi,

I have now confirmed this on four different installation (2 servers, 2 clients).

Is this by design? I need to define a Microsoft Excel Driver DSN. Does anyone know how I can get back these drivers?

I can physically see the .dll's in windows\system32, and the references in odbc.ini.

Thanks.
by mmallory
Sat Sep 19, 2009 6:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems extracting data from Lotus Notes using NotesSQL
Replies: 16
Views: 10472

update.

I received confirmation from IBM Engineering that they have 'replicated my problem'.
by mmallory
Thu Jul 09, 2009 11:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems extracting data from Lotus Notes using NotesSQL
Replies: 16
Views: 10472

More and more it is pointing to a bug with DataStage (at least in 8.1). I am still actively working on this. Update: I can see Domino tables and views via the ODBC DSN in 'import table connections'. I get ODBC errors when clicking 'view data' or running the stage. In excel, I am able to import data ...
by mmallory
Thu Jul 09, 2009 10:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Change Oracle port number.
Replies: 3
Views: 2089

I got a good answer from IBM. These changes worked: 1. stop websphere 2. update the port number in \IBM\InformationServer\ASBServer\apps\lib\ojb-conf.jar/repository_database.xml 3. update the port in \IBM\InformationServer\ASBServer\bin\sql\database.properties 4. start websphere 5. update all databa...
by mmallory
Fri Jul 03, 2009 10:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems extracting data from Lotus Notes using NotesSQL
Replies: 16
Views: 10472

I have tried all available drivers from 3.02 to 8.5 and none of them are working with DataStage 8.1. I can see the list of forms / views in domino, but get the same error when viewing data or running the job. I'll try the 3.01. Does anyone have an update on this connection?
by mmallory
Wed Jun 10, 2009 4:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Change Oracle port number.
Replies: 3
Views: 2089

Change Oracle port number.

Hi, We installed Infosphere using the default oracle port of 1521 for our repository database. Now we need to change it. I have scoured the internet and can not find any instructions on how to do so. Does anyone have instructions on how to get this done? We simply tried changing the client tnsnames....