ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Connecting Windows DSN from AIX

Post new topic  Reply to topic
 Connecting Windows DSN from AIX « View previous topic :: View next topic » 
Author Message
SANTY_P
PostPosted: Sun Aug 26, 2012 7:26 pm    Post subject: Connecting Windows DSN from AIX Reply with quote

Newbie

Joined: 24 Apr 2012
Posts: 3

Hi All,

I have a message flow running on aix (5.3v) needs to connect a windows DSN. ( One of our database vendor has connectivity only from windows server so we installed those drivers in one of our windows machines and created a SYSTEM DSN ).

We want to connect to that System DSN from one of our flow which is having java compute node, but its running in AIX server.

Any help or advice highly appreciated ..

Thanks.
regards,
Santy
Back to top
View user's profile Send private message
mqjeff
PostPosted: Sun Aug 26, 2012 7:33 pm    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

It's not a DSN. It's, presumably, a database that can be addressed by a data source, said data source then having a name.

If your vendor only has connectivity from a windows machine, then you can't connect to it from AIX. CAN NOT. AT ALL.

You'll have to connect to something else from the AIX box, that runs on windows and then connects to the database.

What I personally would do is run a new broker on a windows machine, and use a message flow that reads from an MQ queue and queries or updates the database, and provides response messages.

Other people might choose to use something other than MQ to communicate with a program running on a windows box.
Back to top
View user's profile Send private message
smdavies99
PostPosted: Sun Aug 26, 2012 8:52 pm    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

If the DB Vendor is 'Windows only' then the chances are that Broker won't support it anyway.

If however, you are in a situation where the DB you have to access is running on Windows and broker is running on AIX AND it is one of the major players in DB's that broker supports then the chances are that the Datadirect drivers provided by broker will do the job for you.

goto the InfoCentre for your version of Broker and search for
'supported databases'

The answers will tell you pretty much all you need to know.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Connecting Windows DSN from AIX
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.