Avaya and OpenLink
Moderators: chulett, rschirm, roy
Avaya and OpenLink
Has anyone had any luck connecting DS to to an Avaya Informix instance using the OpenLink driver?!?
Re: Avaya and OpenLink
[quote="tacitus"]Has anyone had any luck connecting DS to to an Avaya Informix instance using the OpenLink driver?!?[/quote]
I have the same issue. Currently I am connecting using MS Access as I installed Openlink ODBC on windows. It seems DataStage DLL has some kind of incompatibility with Openlink on the Sun Solaris Informix. Whenever I try to connect it is locking the ODBC on the informix. We have opened a ticket with DataStage. Please let me know if any one able to do this.
I have the same issue. Currently I am connecting using MS Access as I installed Openlink ODBC on windows. It seems DataStage DLL has some kind of incompatibility with Openlink on the Sun Solaris Informix. Whenever I try to connect it is locking the ODBC on the informix. We have opened a ticket with DataStage. Please let me know if any one able to do this.
Re: Avaya and OpenLink
We ended up using Data Direct by finding a port Avaya left open that allowed us to connect not using OpenLink. This wasn't really an Informix issue as much as a restriction created by Avaya.
I have the same issue. Currently I am connecting using MS Access as I installed Openlink ODBC on windows. It seems DataStage DLL has some kind of incompatibility with Openlink on the Sun Solaris Informix. Whenever I try to connect it is locking the ODBC on the informix. We have opened a ticket with DataStage. Please let me know if any one able to do this.
Re: Avaya and OpenLink
Hi,
Thanks for the reply, Could you please let me know how did you find the open port on Avaya. And also how did you use Data Direct?
Thanks for the reply, Could you please let me know how did you find the open port on Avaya. And also how did you use Data Direct?
Re: Avaya and OpenLink
DataDirect drivers are the default odbc drivers DataStage expects to use. You need to add an entry in your .odbc.ini file for the database. I have pasted a blank entry below. The port number in it is the one we found to be open. If that doesn't work you will need to work with an admin to do some snooping.
You also will want to add an entry in your uvodbc.config.
[AVAYASERVER]
QEWSD=
Driver=<your path>/branded_odbc/lib/VMifcl20.so
Description=DataDirect Informix Wire Protocol
Database=
LogonID=
Password=
HostName=
PortNumber=3077
ServerName=
CancelDetectInterval=0
TrimBlankFromIndexName=1
ApplicationUsingThreads=1
You also will want to add an entry in your uvodbc.config.
[AVAYASERVER]
QEWSD=
Driver=<your path>/branded_odbc/lib/VMifcl20.so
Description=DataDirect Informix Wire Protocol
Database=
LogonID=
Password=
HostName=
PortNumber=3077
ServerName=
CancelDetectInterval=0
TrimBlankFromIndexName=1
ApplicationUsingThreads=1
rrcreddy4 wrote:Hi,
Thanks for the reply, Could you please let me know how did you find the open port on Avaya. And also how did you use Data Direct?
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact: