- #INFORMIX ODBC OPTIONS HOW TO#
- #INFORMIX ODBC OPTIONS UPDATE#
- #INFORMIX ODBC OPTIONS DRIVER#
- #INFORMIX ODBC OPTIONS VERIFICATION#
I'm not sure what the port 8443 reference is for since it seems to work without it. I also found some PHP code that will use AXL, a gentleman had posted it here īut the link he's using in this example is /realtimeservice/services/RisPort?wsdl, which I do not believe will work for CDR queries. I understand that this statement will proabably not do me much good in rendering the information to a web page, but it's a start. Run sql car select datetimeOrigination, dateTimeConnect, dateTimeDisconnect, callingPartyNumber, finalCalledPartyNumber from tbl_billing_data where finalCalledPartyNumber like 'XXXXX' or callingpartynumber like 'XXXXX' order by datetimeOrigination
#INFORMIX ODBC OPTIONS UPDATE#
So, update to my query situation I've figured out the SQL string I should run to get the information I'm looking for Lots of really good information on there.
I spent more time on your site and I must confess it's very cool. What is the database name on CUCM that I can add to the DSN? Is there a document like the UCCX DB Schema doc that I can use? Any help is very much appreciated. What kind of account should I create to do this? What kind of rights role should it have? Server names seem to prepended with a "g" and the version number of the server seems to be appended as well, so Īlso, for UCCX, there is a default ucchruser account that is used for the purpose of DB queries.
#INFORMIX ODBC OPTIONS VERIFICATION#
For CUCM, I cut to the chase and pulled a db replication trace to look at what Informix server names were being used, but I would like a verification to make sure I am on the right track. There are certain rules, such as hyphens are turned into underscores, etc. So, for the CUCCX Wallboard project, one roadblock was in adding the Informix servername to the DSN.
#INFORMIX ODBC OPTIONS HOW TO#
I've read some of the CUCM Data Dictionary, but I still have questions on how to find the relevant information for the DSN. I'm looking for the same information for CUCM. For CUCCX, the DB Schema document was very valuable because it gave information on the database name as well as a pretty thorough description of the tables. I got it working and would now like to extend this our CUCM publisher. The data source or for the connection.A while ago I set upon configuring a Debian server to use ODBC and PDO to query our CUCCX server for use as a basic wallboard.
#INFORMIX ODBC OPTIONS DRIVER#
The driver is unable to load the translation DLL that is specified for SQLConnect(), SQLDriverConnect(), and SQLSetConnectOption(). Theįollowing functions can return this error code: SQLBrowseConnect(), This IBM Informix CLI error code is the same as SQLSTATE value IM009. 11048 Unable to load translation shared library (DLL). This is all I can find about error 11048: Subject: RE: Error when creating a dsn in IBM informix odbc driver 3.50 for informix db 10.0 If the echo shows INFORMIXDIR/bin is cut off then move the INFORMIXDIR/bin to the front of the path statement. Windows path statements are limited in length. If this is the case, move the INFORMIXDIR/bin for the new version to the front of the path statement. Keep in mind you can only use one version at at time. If there was a previous version of informix on this machine the DSN will pick up the first one it encounters. This error will usually occur is there is a problem with the path statement.įirst check the path statement from DOS command prompt by typing echo %INFORMIXDIR%, check for the path.Ĭheck the path for two INFORMIXDIR/bin statements.
0 kommentar(er)
