Oninit® Archive
Results for “INFORMIXCONRETRY”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
listener-thread: err = -25580 IDS 9.40 UC 4
Get the client sdk and write an esql/c program that tries to connect. Or get the jdbc driver and jselect from www.iiug.org and write something that tries to connect.…
Web Based Accounting Packages?
Are there any true web based accounting packages? We're interested in installing the software on a Windows2000 server using SQL2000 as the database but want the remote locations to install a thin client utilizing the web to connect to the server?…
IDS 14.10.FC13 compatibility with other Informix tools
If you use sqlhosts with the CSDK then either use 4.50.12 or wait for the new version 4.50.14 tentatively scheduled for release a week from today. Using CSDK 4.50.13 and above with sqlhosts will return an Error -79716. ------------------------------ Daniel Karwatka -------------…
Cannot connect to Informix database via Python
Hi Malcom, I followed following document and it worked for me using sqlhosts onsoctcp protocol. https://github.com/OpenInformix/IfxPy Note: Client SDK should be installed and LD_LIBRARY_PATH should be exported. Regards, Nandkishor ------------------------------ Nandkishor Singare…
HDR Issue
Hello Boycho , Thanks for your reply. Changing hostname with IP Address in SQLHOST file worked. Looks from Unix level hostname not taking the IP Addressing. Thanks again. Regards Amit Patel ------------------------------ AMIT PATEL ------------------------------…
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Error -25546 in connection manager 4.50.FC10
Milan, It seems to me the right place for 'SQLHOSTS LOCAL' is outside CLUSTER definition, i.e. just after LOGFILE. Does CMALARMPROGRAM react on the error? If so, what does it output? ------------------------------ Sincerely, Dennis ------------------------------…
Informix HA Cluster and CM
Thanks so much David, that clears many of my questions. From what I have read on the CM, it only routes the connection request. It uses its local sqlhosts file to accommodate the connection or any sqlhost on the primary instance or HDR. The next question is. My current single i…
onstat -g ses returns "Changing data structure forced command termination"
David: I don't know the APAR. It happens with even a single client connection that has executed no SQL at all. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
Replication of Informix
Please post your SQLHOSTS settings from both servers' hosts for both servers. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
JDBC & TLS/SSL
Yes the SSLCONNECTION=true is required regardless of using the SQLHOST file. The driver looks to this parameter to setup the TLS to make the connection. It does not look at the SQLHOST protocols for this purpose. The point is valid that if the SQLHOST file has enough information…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Error in SQL Linked server to Informix DB
Hi Eric, I created an ODBC connection on my client (a windows client with Sql Sqerver), then a created a linked server in sql server. I try your tip and let you know. Thanks Gianni…
4gl version 7.2 connection to ids 11 ?
Replying to my self, for others. The only thing is needed to connect to a new db for an old client is to set the correct port in /etc/services ( 9088 ) and configure everything as it should be for a normal connection. Thanks anyway !! Pierluigi…
ONMODE -Y on the client side
"onmode -Y" turns on SET EXPLAIN for given session. "onmode" isn't distributed with the client software and connects to an instance's shared memory so is strictly server only. Presumably you don't control what the client is doing otherwise the obvious thing to do would be to run…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Re: 12.10.FC9 1809 Error
i'm just connecting on shared memory (onipcshm in sqlhosts) regards…
How to tell that client uses SSL connection?
We are in process of migration from soctcp to socssl connections and I cannot find any onstat command (or anything else) that can tell me what connection is used by client: secured or not. Any ideas ?…
HDR is not working
Post your last 30 lines from C:\\\\Connection_Manager\\\\tmp\\\\cm.log and your Connection manager sqlhosts…
Connections from Linux client take a long time to
Hi, I have a Linux server that seems to take a long time to make connections. On a working (AIX) server, I get this: time echo "SELECT CURRENT FROM systables WHERE tabid=1;" | dbaccess rmca_test - Database selected. (expression) 2018-01-28 14:44:16.000 1 row(s) retrieved. …
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
keep-alive in sqlhosts
Hi all, we have the problem that longer lasting remote client sessions on informix databases are interrupted by the firewalls, particulary when no packets were sent. It's possible to configure the port on the firewall to extend the time before the connection is interrupted. The …
Connection Manager for HDR in Windows server
Thanks Mr.Art But still little confusion. On the host of each client application, create an sqlhosts file entry for each service-level agreement (SLA) in each Connection Manager configuration file. My SLA is sla_1, which is configured in the connection manager cmsm.cfg file. n…
OAT is not connecting to database server
Thank you all who are responding and very active in IIUG. Hello, I am able to connect to database server through OAT only while i mention the IP address instead of hostname in SQLHOSTS file. but whlie using the hostname in SQLHOSTS file it is not connecting to database server. …
Connect informix using Active Directory account
We are using sssd with ldap here , not sure if my sqlhosts entries are correct.…
sqlhosts file
For the sqlhosts file, if you have two servers (primary and secondary for HDR), will the sqlhosts file have 3 entries? Primary One for shared memory with name of primary and two for tcp(one for each server)? Secondary Same thing(3 entries) except for shared memory, it will have…
DBSERVERNAME in an HDR Environment
Original post: Hi, In an HDR Environment, the DBSERVERNAME of the primary server must be the same of the secondary or they must be differents ? Thanks in advance. Reply: They would be different due to the fact that DBSERVERNAMES would need to be unique in the sqlhosts file, a…
Reports making Informix to hang
Hi, Sqlhosts does not exist in Widnows, it's located into regedit of Windows, in the Sqlhosts of regedit, I have as follow: Sqlhosts directory and under that I have: INSTANCE_NAME and under taht I have these parameters: Host: ip_adress Protocol: onsotcp Service: Instance name r…
Re: jdbc connect to cluster
I must be doing something wrong, with both cm up everything works ok always. When I turn one cm down I get exceptions randomly. Am I missing something else to force the swtich in case of failover? jdbc:informix-sqli:informixserver=ifx_lab_ps;SQLH_TYPE=FILE;SQLH_FILE=/opt/infor m…
jdbc connect to cluster
https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/id s_jdbc_048.htm for example jdbc:informix-sqli://INFORMIXSERVER=g_primary; SQLH_TYPE=FILE;SQLH_FILE=sqlhosts; USER=my_user_name;PASSWORD=my_password; INFORMIXCONRETRY=2;INFORMIXCONTIME=10;LOGINTIM…
is it possible to change server name on the sqlhos
Hi, I have multiple instances and one of the instance require to change IP address (I.e. cluster package ip) on the sqlhosts file. Is it possible change sqlhosts file at the time other instance online? Verision: 11.50 HP-UX Thank you --001a113fbc0e4fda99052e5608e7…
Sqlhost entry on the client server
Hi All, I have two client server and one database server. In the database server sqlhost file defined as db1 onipcshm serverA sv db1.1 onsoctcp ServerA sv db2 onipcshm serverA sv1 db2.1 onsoctcp ServerA sv1 etc/services sv -750 sv1 -7002 Client A db1 onipcshm serverA sv db1.…
Instances not starting after installing 64 bit sql
Thanks Keith, Is there any other workaround to keep the existing instances and corresponding databases? Does creating a new mount point for installing IDS as the INFORMIXDIR could help (with onconfig file, sqlhosts, etc) from old directory? Regards, Sameer…
Socket listener stuck behind non-yielding thread
Did you get a onstat -g stk several times to see what the session is doing? Would INFORMIXCONRETRY help? Or temporarily running NETTYPE NET rather than CPU? Regards, David. > On 02 February 2016 at 12:51 NEIL TRUBY <neil.truby@ardenta.com> wrote: > > > I'm re-building all 1,9…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Setting up SDS cluster
HP-UX B.11.31 IDS 11.70.FC8W1 Setnet 4.10.TC5 Hi All When I start the connection manager and try to connect from a Ilogin I get a -908 error. I have checked the port setting on both client and server match but still get this error. Any advice will be appreciated. thnx…
SDK degrades IDS
When Web Server connect With SDK client, the IDS degrade. I configure the NETTYPE soctcp,2,600,NET NETTYPE ipcshm,2,500,CPU I need know what happen and if I reconfigure another parameters…
RSS and SQLHOSTS groups
Hi, We are running Informix 11.70.FC7 on Solaris. We tried using groups in the SQLHOSTS file to connect to an RSS server though we received the error below. Aside from using the connection manager, is there a way to use something similar to groups so that if an application alway…
SQLHOSTS for HDR
Hi Jacob. Enterprise Replication requires that all database servers participating in replication be members of database server groups. So, if you are combining Enterprise Replication with HDR, both the primary and secondary HDR servers must be members of the same database server…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
System Or Internal Error InterruptedIOException
Hi, in your Informix Server environment you can do: % finderr 25582 -25582 Network connection is broken. The connection terminated because the network is down, the database server is offline, or the client is offline. If you receive this error on a client, check the network co…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Remote database connection failed
Hi All, I have modified /etc/services and /etc/sqlhost file pointing to the instance and try to access through application but gives error to connect. Any suggestion or advise on this cat /users/wksogrp/cm172895/cmt001_err_17150_cm172895_whx003n.log The following diagnostic inf…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
sqlhosts file
On UNIX, the sqlhosts file contains connectivity information that is loaded from the default location in $INFORMIXDIR/etc/sqlhosts, when the database server is started. My problem is, the sqlhosts file gets changed after the server is started, and I do not know where or how I ca…
Re: SLA Not Working with Kerberos Enabled Service
please take a look http://www-01.ibm.com/support/docview.wss?uid=swg21635513 that article explains how to use PAM DBSERVERALIAS, you can try the same way with 'csm' options, define support1 sqlhost options same as test1_tcp_1 in CM side sqlhosts file like support1 onsoctcp <cmh…
Connect 4GL to Informix Server
Thanks. I have my sqlhosts file in both, 4gl programs and informix server: ol_resp onsoctcp 192.168.1.122 ol_service…
recover SQLHOSTS file
Hi, We have Informix Dynamic Server Version 9.40.FC9 running on HP-UX B.11.23. We have 21 instances running on the server. All of a sudden the SQLHOSTS file has turned to zero size (not sure how), all the entries are lost. we are not able to access any of the databases. Is there…
Server Install Weirdness:
You need to change your SQLHOSTS entry to use the IP address of the host and then restar your Informix server.…
How to connect Java/JDBC with Connection Manager
Thanks for the help, please also tell me that if this sqlhosts path is the file path at the client environment side (i.e. in my case windows path, where I need to create an identical sqlhosts) or it is the sqlhosts path at the Informix Server side i.e. $INFORMIXDIR/etc/sqlhosts? …
redundant connection manager configuration using H
correct. since PRIMARY always has zero latency, so most time Connection Manager will route client application to the PRIMARY. if you want use secondaries and low the connections to the PRIMARY, you can define cm_sla1 as SLA cm_sla1 DBSERVERS=(RSS,HDR),PRIMARY if all RSS and HDR…
Trusted JDBC Connections to IDS
Hi Forum, I understand that it is possible to configure IDS to trust DB connections from particular hosts, so that a password is not required. In the past I have done this with 4GL and dbaccess client connections to remote linux servers, by specifying the client host names in t…
Invalid ASF API parameters
The port number is defined in the sqlhost file…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Connecting to a remote server
Something else interesting: I can connect as callj from the client if I connect explicitly to the ksotinfx01 server, and put my password in.…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
SQLHosts File
Hi I've trying to find out the effects/impact of changing the SQLhosts file on a running engine. Background. I have a live running engine on a server and want add a second instance to undertake some testing. Obviously this will need entries in the SQLhosts file, can I make these…
Same server name on the same host
Version : ids 9.4 Can I set up 2 instance which has the same server name ? What if I set 2 different SQLHOSTS files ?…
sqlhosts setup enterprise replicatiion window - un
thanks for that Art I had missed out an entry in sqlhosts in registry. Replication now working between windows and UNix servers. Now managemnet tell me to try Informix on Linux !…
Full db restore from 1 server to another
Thank you. I was able to resolve this issue. The problem is that, i commented out the sqlhosts parameter pointing to the machine1. both machine1 and machine2 should exists in sqlhosts. REgards,…
SQL query involving multiple IDS instances
Just added the entrance to $INFORMIXDIR\\\\etc\\\\sqlhosts refered to the other instance and the service in /etc/services and worked like a charm. Thanks a lot mates!…
client connection to a multi connection manager sy
Hello I have one java application that connects to informix server through connection managers, but even when I have more that one connection manager, when one of the fails I cannot connect anymore with my java application. I have two connection managers , and two informix data…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
952 errors
I have had this error heaps. Often happens when client pases incorrect connection string to the server which contains login/passwd. Could it also be batch running regularly with wrong connection string ? Have experinced it a lot with OAT related connections…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
PSORT_NPROCS
Hi, If I have a large box, lots of physical CPUs in the server, the client application run in another box, connected trhough TCPIP, I want to set environment PSORT_NPROCS, Is it being set in client or server side ?…
Enterprise Replication Problem
hi Hard to say whats going on. anyway if you have not done so already ,for the 3 servers to talk to each other you need to have entries in all sqlhosts files for the servers. So in sqlhosts file for A you need to have entries for B and C for host B the sqlhosts file has to have e…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Changing charset on IDS 11
SOLVED... Probobly problem was just in client program, I next use visualstudio, and evrything was ok, connection, codepage and whole charset problem was solved. This or other way, thanks for help, Im glad the nightmare with charset is over:)…
four j's client connect error
redhat as4 informix ids 11.5 four j's BDL 3.53 windows front end 2.10 on windows/xp When I try to connect redhat by Four J's tool ' windows front end '. I cannot login , It display " Wtcp client term0 to 10.35.7.1 ,service 513 failed : CONNECT_FAIL none I already enabled read…
How to test conection from Windows PC to Linux ?
Protocol is "onsoctcp". Service is the port number corresponding to the service name in the sqlhosts file. Art On Mar 23, 2011 7:24 PM, "HERNANDO DUQUE" <hduquec@hotmail.com> wrote: --bcaec50160c7000ca5049f312df7…
JDBC Connection Problem
On Mar 11, 3:41 pm, Mark Jamison <maj...@me.com> wrote: > Localhost is your likely problem > > JDBC is not resolving the sqlhost entry. > > Best solution would be to either use your machine name or a * > > I used to run into the same problem on my MacBook pro Thank you for the h…
Detection of Secondary
You might want to export the following to reduce the time an oncheck -pr takes to run for an offline engine. export INFORMIXCONTIME=1 export INFORMIXCONRETRY=0 oncheck -pr |grep 'DR Last Mode Change' on secondary DR Last Mode Change 8 Secondary mode on primary: DR Last Mode C…
IDS Error: CDR DEFINE SERVER
Hi, My sqlhosts is OK now. I rebooted the instances and tried again, but the error continues. Have any idea? tks, Hugo…
11.70, drda & ldap
Hello, did anybody install 11.70 with ldap authentication and connect client with drda? I installed 11.70, ldap and users can connect with "normal" sqli (with PAM), but I can't configure drda access. Does anybody have cookbook or something similar? Regards, Hrvoje…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
How to Monitor Open Connection Tiime???
Hello Cesar. Please see the comments below. On Sun, Nov 28, 2010 at 3:20 AM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Hi , > > I'm working with Miguel on this situation . > After some debugs with strace, tcpdump, application log we could confirm > the …
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
loading file from the CLIENT (in SP)
Hi there, does anybody know is there a way of loading a file from the client file system to the SP running on the same client connected to IDS? I would use LOAD if that would work in SP, I would use EXTERNAL TABLE but it reads the file from the server side not the client's filesy…
ibm informix client sdk 3.5
Hi, Can I connect ids v11 with informix client sdk 3.5 and delphi 7 ? If not , which version of client sdk is runable ? any message from you will be appreciated. daisy…
error (-908) trying to connect to IDS v11.50.TC2E
didn't see that happening on my site but if a machine is the domain it could take FQDN of the client and not allowing you to connect (check with/without domain on the failing client or search for documentation about switches like CHECKALLDOMAINSFORUSER…
Informix Client SDK &Informix Client Connect 3.5
Hi, I would like to know the difference between Client SDK and Client Connect (3.5) for .Net. Is Client Connect (.net runtime) downloadable free of cost?. Thanks in Advance, Bala…
Suspending HDR temporarily?
> So, do I need to also edit the sqlhosts file on the primary? But, then I would have to bounce the primary, right? (That's production, can't do that.) DG…
odbc connection pooling settings (in windows client)
Hello, in the odbc control panel in windows, i go to the connection pooling tab (not sure in english how it shows to you), i double click on IBM INFORMIX ODBC DRIVER and there there is a window with an entry for the amount of seconds for keep a connection in the pool. There is a…
Error : 930 Cannot connect remote database
I'm not sure but I believe other clients that dbaccess must use C-SDK for connect. Try to connect with dbaccess from your client machine for valid the connection is OK. If it's true, so you must use C-SDK. syntax to connect : dbaccess database@informixserver…
How to secure ODBC connection
Hi, how can i implement secure (encripted) odbc connection from windows clients to informix dynamic servers 11.5 ? I read something about client supports SSL but no idea how to implement or use it. The big problem is some sniffer catching odbc users and passwords, and of course…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
FW: screen shots for connecting EHDS client from k
Can I execute a JDBC URL via a remote workstation thru an Informix client to a remote database server? I'm getting " ERROR: Attempt to connect to database server (%s) failed." Is there something in the JDBC, URL, or onconfig that needs to be set? OS=AIX 6.1 <-- Client and Datab…
Re: can't connect to database with client
On 12 Wrz, 00:05, "John Hardin" <jhar...@epicor.com> wrote: > "Robert" <robso...@gmail.com> wrote in message > > news:99b51f1c-549b-4326-a7a8-b45cf72ccf88@j4g2000yqa.googlegroups.com... > > > > >> > Hello, > >> > I'm new todb2. I haveInformixdatabase on AIX and ODBC application >…
Re: can't connect to database with client
On 12 Wrz, 00:05, "John Hardin" <jhar...@epicor.com> wrote: > "Robert" <robso...@gmail.com> wrote in message > > news:99b51f1c-549b-4326-a7a8-b45cf72ccf88@j4g2000yqa.googlegroups.com... > > > > >> > Hello, > >> > I'm new todb2. I haveInformixdatabase on AIX and ODBC application >…
Re: can't connect to database with client
On 11 Wrz, 20:05, Ian <ianb...@mobileaudio.com> wrote: > Robertwrote: > > Hello, > > I'm new todb2. I haveInformixdatabase on AIX and ODBC application > > on Windows. I'm trying to connect toInformixdatabase using odbc > > client - I've downloaded and installed v9.5fp3_nt32_dsdri…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Client connection problem with 7.31FD7-1
Hi, I have just tried to upgrade a Tru64 Unix 4.0G server system from IDS 7.31FC2-1 to 7.31.FD7-1 (But using 7.31FD6-1 as an intermediate step.) {I know this version is very old, and the OS is also very old, but its all I have to work with, so no 'You really need to upgrade' me…
server startup
Is this the way you have things configured? (I got this from your earlier posts): DBSERVERNAME ol_ids_1150_1 # Name of default Dynamic Server DBSERVERALIASES svc_drda # List of alternate dbserver names and sqlhosts has svc_ids_1150_1 onsoctcp host svc_ids_1150_1 The first col…
Re: Connection manager redirect
Hi Madison, and how we work around this problem, because in a real situation when we have remote clients connecting throw the connection manager, the information that receive the client about the way to connect directly to the IDS server is the same that the server has at the sql…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
connect through java using group_name con mgr
Hi Kamran Your connection manager log showed the client was correctly redirected to your primary at port 9202 which looked fine. Please check your JDBC version as suggested by Jinming. If your JDBC version is correct, you can try the following steps to isolate the issue. You s…
Trouble connecting to IDS 11.5 development server using SQuirrel SQL with IDS JDBC driver.
epsilon wrote: > VG > > Oops! A blasted operator error on my part with port forwarding. I > had a typo in the "ssh" port syntax I was trying to use. This has > been corrected as listed below, and now I see the -908 error you > mentioned as a possibility. > > $> telnet localhos…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
TCP problem upgrade 9.40 to 11.50
Art I added a new nickname in the /etc/hosts 180.180.169.151 informix.orgrimmar orgrimmar loghost And Modified the sqlhosts with this nickname: pruebatcp tlitcp orgrimmar 1528 The instance is runnig...and online. I belive the problem is the dot in the name of de machine. T…
IDS connectivity with Client running INFORMIX STAR
We have our server running the database in Informix Server (IDS 11.0). This machine is having the RHEL 5.0 OS We have a machine having INFORMIX STAR or INFORMIX NET (5.0) client. This machine is having the SCO Unix OS Is there any possible ways to connect INFORMIX STAR with IDS …
onint - cannot open chunk error 2
Jon - Post or email me a copy of your user informix env., your onconfig file, and your sqlhosts file - are there other informix instances setup on this host? Mike…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
IDS error -- onmonitor
Our OS is Solaris 9 Sparc. While compiling the information you requested, I examined the sqlhosts file yet again. The sqlhosts file created during the installation of IDS 11.5 looked like this: demo_ids ontlitcp FQDN.for.colostate.edu.machine 9088 I had initially created my own …
Determine if informix is online?
Fernando Nunes said: > Not necessarily... > Just set INFORMIXCONRETRY and INFORMIXCONTIME to fair values... Are you implying that the default values might not be good enough? :oD > onstat - will not work remotely... (unless you use ssh to connect to the > dbserver of course :) …
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Informix DRDA Gateway Issue.
Can you post the sqlhosts file from each machine? Mike…
PHP/PDO maintained? *NM*
Adam -- The PDO_IBM driver uses the common CLI driver to connect to IDS. Because the CLI driver is included in the IBM Data Server client bundles only, you cannot build PDO_IBM with the Informix CSDK. Regards, Mac Gerling…
JDBC Connection
I don't know how to specify the protocol, for the jdbc connector? Could you send an example of the onconfig and sqlhosts? Is the protocol "fixed" by the entries in the files you mentioned?…
Re: error in connecting informix client with datab
Hi Vartika, Did you see this error while you list database or while you try to connecting to the database? Did you see any error in Sever online log file? I guess you have a setup issue. IBM informix sever admin manual provide detailed explanation for setting up connections. ht…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
error in connecting informix client with database
Hi, I m facing problem in accessing infromix database from informix client. the version of IDS is 9.4 The client and the database both are on diff machines.*(diff ip address). i have same os and filesystem on both the machine but diff hostnames. i have set the /etc/hosts, /etc/…
Network connection is broken
Hi, I'm experiencing a strange issue with my Informix server. When I try to connect from a PHP script, I get the error "(-25582) Network connection is broken". There is no problem on the network though, the server correctly receives the connection from the client, the request …
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
How to clean connection pool with Informix .NET provider (Client SDK)?
Hello , does somebody know how to force to clean the connection pool with Informix .NET provider (client sdk) ? Thank you…
listener-thread: err = -27001: oserr = 0: errstr =
Aaha.. I think, I also exported INFORMIXCONRETRY and possibility (not 100% sure) modified ???timeout?? ONCONFIG parameter. --- Jim Cramer <jim-cramer@uiowa.edu> wrote: > Hi Vikas, > > I was getting this exact error a few years ago with IDS 7.31. > Coincidentally I was using 4JS…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Connecting to IDS 9.4 from Linux x86_64
Additionally I can connect using the trail download of the DataDirect drivers, however looking for a solution that works with the informix client SDK driver or a free license solution.…
Initializing rhead structure...oninit: DBSERVERNAME 'cfms' not in sqlhosts file or sqlhosts file contents are damaged.
> > The changing of IP address was rolledback to the original, but the > error remains. someone mucked up your sqlhost file..... have a look at $INFORMIXDIR/etc/sqlhosts or if INFORMIXSQLHOSTS env var is set look at that. an entry cfms <protocol> <hostname or ip adress…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Onspaces freezes!
Marcus, I have disabled my firewall, but when i do telnet <MyserverIP> <MyportNum> i get the following error : "Unable to connect to remote host: Connection refused" Yes, my_srv is in the client services file with the same name. By the way how can i use numerics service numbe…
Re: ISQL install problem
andrew.burridge@gmail.com wrote: > Hi, > > It's pretty much everything regarding isql that isn't working... > > When I go to query language, it attempts to connect to the server to > find a list of databases, but fails with the error: > > "908: Attempt to connect to the database …
Unable to connect informix via JDBC driver2.21
> RAVI MADABHUSHANAM wrote ... > On referring to the error: 14565, (oninit.com) i found that i should set some > client side environment variables. but, how can i set them in a pre-written a > JAva program. Just as for any pre-written program , in the users environment who star…
onmode -ky hangs
On 10/18/06, SANJIT CHAKRABORTY <c_sanjit@lycos.com> wrote: > The onmode is nothing but a client application. Whenever, you execute an > onmode command, it will make a new connection to the database server and each > new connection uses some virtual memory. Well, ON-Mode is not …
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Error occurs when oninit: DBSERVERNAME 'sharp' not in sqlhosts file.
The machine is restarted but Informix does not come up automatically. I use oninit without options to bring Informix database server online. I get an error message then as following, how can I do with it? Can I edit the sqlhosts file manually and add an entry to correct the error…
Common sqlhosts file
Hi, I have different applications and different environment for each application. Applications A1, A2, A3 Environment DEV, QA, PROD Is it ok for me to have one sqlhost file that will have entries for each combination. I am also looking at putting all the entries in the /etc/s…
Help on rplication manager ids7.31 win nt
hi, when starting replication manager i got an error : invalid sqlhosts format, i changed INFORMIXSQLHOSTS to may machine name, but after restaring replication manager the same error appairs. thanks new on informix Maumas…
Network down
I getting this error "network down" when I use on monitor. I am using informix 7.31 on HP UX 11.11. What could be the problem. I have checked the sqlhosts file and it is ok.…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: oninit fails using onsoctcp on linux
Adam Tauno Williams wrote: > I'm running Informx 10 on SuSe with - > (sqlhosts) > MOAIPC onipcshm localhost none > BARNET onsoctcp moa online > > >>sqlhosts: >>idbs onipcshm linux4 egal > > > What is "egal"? It means: don'…
oninit fails using onsoctcp on linux
> I installed Informix 10 on my linux (SLES9) box, everything ok. > All necessary environment variables set, "oninit -i" starts > but stops when it is about to build the sysmaster, ONLY if I > use "onsoctcp" in the sqlhosts file. No other process uses the > service port. > When (…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: Cannot create/access database on NFS mount.
Yes, sqlhosts is reconfigured per http://www.iiug.org/resources/linux/linux_faq/english/iolfaq-5.html#s1_remote_conn. I'm trying to open an ODBC connection from a Windows XP SP2 machine to an IBM AIX/Informix machine.…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
ODBC Connectivity from 64-Bit Windows XP to IDS 7.31
What can I say is that 64-bits Windows platforms are not supported yet by the Informix clients (both SDK and Connect). I also found this problem, Informix support said to me that the supported client will release in the 2007. Hope this will help you…
connecting to Informix results error -908
Hi ! I have Informix Dynamic Derver 9.4 and Client-SDK 2.90 running on Windows XP. The problem is that trying to connect the client to the data base results : error -908. Informix Error Messages tells about this error: "Attempt to connect to database server (servername) failed." …
Re: Validating sqlhosts and services
Thanks for this ...not knocking it or anything but what if the services are stored in yp? "ypcat services" apparently gives something that is searchable.. I'm not sure if you can store services stuff in LDAP? Very good tho..like it...portable...easy to use...…
Re: Validating sqlhosts and services
On 17 Dec 2005 13:38:56 -0800, david@smooth1.co.uk <david@smooth1.co.uk> wrote: > > Errm.. What if people do not have perl installed? > > With C I can provide binaries that have no external dependencies. > > I just want to validate ontlitcp or onsoctcp connections with this > too…
Re: Validating sqlhosts and services
On 15 Dec 2005 19:59:43 -0800, david@smooth1.co.uk <david@smooth1.co.uk> wrote: > Does anyone know how I could write code to check the services past of > sqlhosts? > > Something that checks a servicename is valid on the current machine? > What calls does IDS use to check? > > Sam…
RE: Old INFORMIXSERVER name from onstat -g env
> > Just make sure everything matches, sometimes it is easy to miss a simple > little thing - > > DBSERVERNAME > DBSERVERALIASES > > , sqlhosts (hostname etc.), /etc/services ..... > Checked again-- all OK.…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: Configuring remote tcp connections.
You also need to add entries to sqlhosts and add NETTYPE parameters to onconfig. Read the manuals Nuno!…
Re: configuring sqlexecd for remote tcp connections.. problems :(
I ended up getting everything working. It was a combination of: for connecting from the local server with dbaccess: 1. setting the DBPATH=//database_connection_name/path/to/db I also had to set 1. on the client plus the following: 2. changing the sqlhosts from onsoctcp to se…
Hi group
thanks for answering, I did what you suggested : 1. ping fedora1 from the client and it answered 2. dbaccess from the server (after setting INFORMIXSERVER=demo_on_tcp) and it was worked 3. yes. the services file and sqlhosts file are the ones you mentioned with the difference t…
Re: AIX informix select on a other AIX system
Ok, I installed the IDS and the client, and now I have dbaccess. But can I make a script (.sh), which connect to the db and select something and put it in a file. What is the syntax?…
Re: conversion script for Enterprise Replication - catch 22 problem
The "catch 22" issue was resolved with assistance from online support (#437614) by updating the syscdr state, then re-running the ./concdr.sh 9.21 9.4 command again. The program got further along, but still crashed due to a problem with our sqlhosts file setup. Since th…
Re: infromix license question
nope you cannot ship clinet SDK with your application unless you have a distribution agreement with IBM your client will get a copy of Informix Connect included with the Informix database engine. Informix connect will include the ODBC driver they require.…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
HDR problem - ontape -p
Guys, first, thanks for your help . It gave me directions. The problem was services/sqlhost file already had some "dead" entries which caused confusion [shouldn't happen in a virgin/textbook cases] .…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
Help:informix database backup/restore with netbackup agent.
You have to set correct value for the INFORMIXSERVER environment variable or check the sqlhosts file content. Here is the quote forme the finderr -25596: ------ The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry. The default database server name that th…
RE: Format of sqlhosts file
> -----Original Message----- > From: Graham Nicholls [mailto:graham@rockcons.co.uk] > Sent: Tuesday, May 24, 2005 8:27 AM > To: informix-list@iiug.org > Subject: Re: Format of sqlhosts file Snipped > The 3 fields are as follows: > > XX 2 character server type - "on" for IDS, a…
Format of sqlhosts file
Good morning! I am having some problems with ODBC drivers, which I've managed to get past, but not without getting very confused about the $NFORMIXDIR/etc/sqlhosts file. Can anyone enlighten me on its format, please, or point me to some resource. I am, and will continue to goo…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Re: connect to database error
my sqlhosts is set demo_on onsoctcp linux linux_s thanks -- Message posted via http://www.dbmonster.com…
Re: connect to database error
Is your serever really called demo_on? thats the name of the example entry in the sqlhosts file. what does the line corresponding to demo_on say in your sqlhosts file? demo_on onipcshm on_hostname on_servername…
connect to database error
Is your serever really called demo_on? thats the name of the example entry in the sqlhosts file. what does the line corresponding to demo_on say in your sqlhosts file? demo_on onipcshm on_hostname on_servername…
informix + pam on linux
Hi, can somebody tell me how to configure pam.d directory/file on Linux for IDS 9.4/10.0? Which name of file for informix will be right? ... and how this file and sqlhosts should look like? Regards, Thomas…
informix + pam on linux
Hi, can somebody tell me how to configure pam.d directory/file on Linux for IDS 9.4/10.0? Which name of file for informix will be right? ... and how this file and sqlhosts should look like? Regards, Thomas…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: PEMEX - CDR WITH NAT
CDR uses the CDRID to replicate, not the IP address. The CDRID is the 'i=3D' field in the sqlhosts options column. As long as you make sure that your sqlhost files have the proper mapping, then changing the network, the ip address, and/or the port numbers should not impact CDR. …
how can I make a conection to informix
first create an entry in sqlhosts or modify. $INFORMIXDIR/etc/sqlhosts os whereever INFORMIXSQLHOSTS points to myserver sesoctcp <yourhostname> <someserverice or 1533> #----------^^^^^^^^ or setlitcp check rel notes. if you use someserverice add someserverice to …
how to read data from database on other machine
Hi all, I was wondering how we can read data from an Informix (IDS) database on another machine. Do I need to metion in the sqlhosts file the other database server? etc.... thanks for any tips!! Danny…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Unix ODBC test
I have recently installed the Informix client on a Unix machine and would like to test the ODBC piece. Does anyone know of a Unix-based tool that will test ODBC connectivity? thanks…
Re: DBI connect timeout question
Dave Kosenko wrote: > I'm using DBI to write a monitoring program for our informix > servers. Problem I am running into is that if the database server > (to which I am always connecting via a tcp connection) is down > completely, the connect() takes a very long time before it r…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
JDBC reading from SQLHOST file
It seems JDBC applications can make connections to the database without a SQLHOST file by specifying everything in the database URL. However JDBC manual also mentioned SQLH_TYPE=file and SQLH_FILE being the SQLHOST file. What is the format of this SQLHOST file. Is it the standar…
informix over WAN
What are the parameters to be tuned when connecting to Informix over WAN. I know FET_BUZ_SIZE. Anything else. The client connects to Informix using JDBC. While testing, we are experiencing severe performance issue when we moved the database from LAN to WAN.…
IDS_9.21.UC2 Problems on IRIX 6.5.22
"Don Rieger" <d.e.rieger@larc.nasa.gov> wrote in message news:40E45DCC.D4A1646D@larc.nasa.gov... > Hi > > Has anyone had the following problem with the Informix Dynamic Server running > on SGI computer with IRIX 6.5.22? > > > The only way we could get Informix Server to work cor…
Problem with Linux client connecting to Solaris Informix Server
Hi all, I have a problem where the initial connection from a Linux client failing with the following error : DB connect failed: inf_open_conn: (25507) The specified service name or protocol is unknown. I believe this is something to do with the client not seeing that the DB (…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Re: Informix Connect
On Tue, 20 Apr 2004 17:32:51 -0400, Paul Watson wrote: > I thought SCO Unix was originally based on Xenix which was owned (??) by > Mircosoft SCO Xenix and SCO UNIX are different code bases. SCO Xenix WAS derived from the original MS Xenix for IBM XT, but SCO UNIX was a pure p…
Re: Informix Connect
I thought SCO Unix was originally based on Xenix which was owned (??) by Mircosoft "Art S. Kagel" wrote: > > On Tue, 20 Apr 2004 16:11:37 -0400, Tom wrote: > > NO NO NO NO > > under the hood SOC and TLI are the SAME protocol, TCP/IP. The only difference > is the call level inte…
Re: Informix Connect
On Tue, 20 Apr 2004 16:11:37 -0400, Tom wrote: NO NO NO NO under the hood SOC and TLI are the SAME protocol, TCP/IP. The only difference is the call level interface. Mist systems derived from BSD use the Sockets library API while those derived from AT&T System V.4 use the TLI…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Change in sqlhost file
Dear All, I am working on informix7.30UC7. Using ODBC connectivity I am able to connect to my database which is for test environment, where m/c hostname and hostname in sqlhost is same. But on live environment ( which is a different server altogether ) connectivity is not gettin…
Off-platform SDK
Thanks for those that sent me advice on this. The main problem turned out to be the service listed in the sqlhosts file on the Linux machine. I had ontlitcp, and it needed to be onsoctcp. Brian McLaughlin Administrative Computing George Fox University (503) 554-2587…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
RE: Whatcha' wanta have?????
And a simple one...when message INFORMIXSERVER not found in sqlhosts file or DBSERVERNAME not found in sqlhosts file could the message include the name it is looking for? This would make it much easier to debug! Also oninit -v option to be documented. All of onstat options to b…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Re: ODBC Connection Problem to SE on Linux
Hi Jon. Your error is 908. [tsutoo@bygzam ~]tsutoo940uc3_tcp% finderr 908 -908 Attempt to connect to database server (servername) failed. The program or application is trying to access another database server but has failed. Note the server name in the current statement. T…
RE: Client/Server Connection Problem
Maybe it's just a typo in this message, but I see an extra "_" in the name (1st column) in your sqlhosts entry, i.e., "my_host_se" vs. "myhost_se". HTH, Paul Mosser -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of …
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Re: Client/Server Connection Problem
Sorry all. I attached IDS release note. Please change setlitcp instead of ontlitcp using Solaris box. Sorry again. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> >To: levartze@hotmail.com, informix-list@iiug.org >Su…
Re: Client/Server Connection Problem
Hi Levartze. You are using Solaris box. You should specify ontlitcp. Here is a part of release note under Solaris. a. NETTYPE in the ONCONFIG file and the nettype field in the sqlhosts file entry must contain "ontlitcp". HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:1681…
Re: Client/Server Connection Problem
I'm trying to setup our Informx SE 7.24, so that we can connect it to a Crystal Reports application. I seem to be having problems with getting the server daemon up and going. Here's what I have: 1. The /etc/hosts file has the following entry: 10.8.33.1 my_hostname …
Re: Informix Client SDK and .Net connection question
There is an article in the MSDN that covers this topic at length, but in a fairly general sense at http://msdn.microsoft.com/architecture/application/default.aspx?pull=/library/en-us/vbcon/html/vboriintroductiontoapplicationsettingstorage.asp The opening sentence is "Dynamic p…
Informix Client SDK and .Net connection question
Hello all, CSDK Driver: IBM Informix CSDK 9.52 2.81.TC3B2 For the IfxConnection.ConnectionString since you cannot use "DSN=XXX" as in the specs,how do you set up a connection string on production without hardcoding the uid and pwd information. Thanks Inadvance Chavan Koya…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Network driver cannot bind a name to the port!
Hi bro, Probably you've some kind of mess in onconfig and specially sqlhosts file Check for correct DBSERVERNAME, DBSERVERALIASES, hostname and port. See also services file for correct service name/number Greetz…
Problem about connection from remote client
Hi all, i have installed ids 9.2 on redhat linux 9.0, after that, i tried to connect to the server from remote client by "telnet server_name service_port", but it failed, can anyone help? Thanks. The following is my configuration. /etc/services # Local services demo_on_service 1…
Re: onconfig and sqlhosts
Hi Thomas. Administrator's Guide for Informix Dynamic Server, Version 7.3 http://www-3.ibm.com/software/data/informix/pubs/library/ids_73.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Thomas Ronayne <trona@ameritech.net> >Reply-To: Thomas Ronayne <trona…
onconfig and sqlhosts
I've managed to blow away my installed Informix system and cannot for the life of me find the notes I had about onconfig and sqlhosts. It's version 7.30.UC5 running on Slackware 9.0 -- can someone point me at the right document in Answers for the appropriate settings? Thanks.…
client port number
Is there a way Informix can return the port number of the client it uses to talk to for a connection. We need this to identify some connections amongst hundreds of connection from iplanet server which uses the same user name. Since client port number is always unique,it can be us…
Lost database connections
Our configuration is IDS 9.21UC7 on a Sun VX880 server running Solaris 9. This server is running in 64-bit mode although our database is 32-bit. We have clients connected running a Power Builder application. Since upgrading our server from a Sun E-450 on Solaris 6 we are exper…
Re: Urgent : Net connection problem on production
One more thing - error 908 mentions ( in finderr utility) , how to deal with slow/congested network. ( INFORMIXCONTIME and INFORMIXCONRETRY variable) Rgds Preetinder samir BADAOUI wrote: > Hi all, > > After installing an other application on my production box. I receive > the …
Re: IfxSQL
Install CDSK 2.8+ o Informix Connect, you can download them for free in IBM-Informix site. You need this 'cause it uses direct connection to Informix not that odbc crap. Chucho! Jack A wrote: > Where do i get the client libraries for Informix for installation on the > client ?…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Difference between Informix connect and Informix Client SDK
Does Somebody would tell me the difference between those Informix products? And the estimated cost of each one (for Linux) ? Thanks in advance regards sending to informix-list…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
Re: multiple instances
For basics it's setting Informix environment variables and exporting them. 1. INFORMIXSERVER=sqlhosts entry 2. ONCONFIG=onconfig file name 2. If the second instance is installed in a different Directory then set INFORMIXDIR to there. 3. If it's a different sqlhosts file name o…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Sqlcode = -1829
I keep getting this error when attempting to establish a connection from a Wintel PC with Informix client. I just can't figure out what it means. It's not listed anywhere. Can anyone help me?…
RE: Client Connection Problems
Probably not that helpful, but sounds like the good 'ole W2K registry permissions. It may be worth checking the MS knowledge base. Do you access using W2K admin rights? TJ Hello All I have being upgrading the hardware for my development system and have run into problems access…
Client Connection Problems
Hello All I have being upgrading the hardware for my development system and have run into problems accessing the database from a client machine. The setup is as follows: 9.21.TC6R1-1, Merant OLE DB 2.1, Windows 2000 Professional. VB6 + SP4, Access 2000 on the "workstation" 2 DEL…
native connection to 2nd network card
We currently have our sqlhosts file setup to allow connection for one port on ip address aaa.aa.aa.aaaa through odbc or native connection. I want to add another network card on the same server to the sqlhosts file so that we can connect to that ip address of bbb.bb.bb.bbbb as wel…
-27001 Read error occurred during connection atte
We running Informix Dynamic Server 2000 Version 9.21.UC2 on SCO 5.0.5 In sometimes the next error are on my system, we heave in house system, and the last change was an system uptdate to a hosts, and 4, or 5 users can work , if another attemp connect from 4gi or dbaccess or anoth…
sqlhosts on W2k
Hi all, I have got define the group on the UNIX server : #sqlhosts on UNIX g_repl1 group - - i=1,e=tranzit tranzit ontlitcp tranzit online g=g_repl1 How do I define this group on W2k in registry? I have got this in the registry, but this isn't functional: [HKEY_LOCAL_MACHIN…
Re: enterprise replication
You probably have a misconfiguration in one of your sqlhosts files. I'd examine them first. If you can't figure out where the inconsistancy, then I suspect that you can get this fixed quickest by contacting tech support.…
INFORMIXSERVER value not listed...
The client machine is a NT4(SP6) server connecting to Informix2000 on NT. Both applications developed with Visual Studio, the one that works using VB6 and the one that doesn't using C++. As I said, the INFORMIXSERVER is listed correctly in the registry of the designated INFORMIX…
ODBC Connection Timeout?
Does anyone know if the TXTIMEOUT parameter in the $ONCONFIG file would time out an ODBC connection after the specified period of inactivity? We have a client making an ODBC connection to our informix server and it is losing it's connection intermittently. Any other ideas on wh…
Re: Parallel Transactions
news You may want to open a pool of connections instead of 1 connection. That way you can assign a new thread to a client as it comes in and attach the client to a free connection in your pool. HTH Sujit "news.uswest.net" <jsnodgrass1@uswest.net> on 12/16/2000 01:07:00 PM Ple…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Client Server comunication
Hello I have Informix server 7.30 UC7 running on Linux suse 6.4 and client sdk 2.4 TC1-2 on Windows '98. When the client application connects to the server there are more than 50.000 packages between them Is it so much? (each packages have 2 bytes of data) Thank in advance Andr…
Client Server comunication
Hello I have Informix server 7.30 UC7 running on Linux suse 6.4 and client sdk 2.3 on Windows '98. When the client application connects to the server there are more than 50.000 packages between them Is it so much? (each packages have 2 bytes of data) Thank in advance Andrea…
Sluggish connections between NT Client and IDS on NT
When connecting to IIF.2000, I am experiencing connect times as long as 15 seconds. The environment that I am has less than 5 connections. The sluggish connections has through ODBC and via Ilogin utility. Below is an overview of my configuration. My client consists of: ------…
protocol
I notice that our informix server has the sqlhosts set to ONSOCTCP and that the windows connect is set to OLSOCTCP shouldn't these be the same? What is the difference between the two?…
Help needed: sqlhosts basics
Hi all. We try to configure an IDS 9.21 FC2 on Solaris 7 with HDR. The clients though are 32-bits, so we were told to use TCP connections, not shared memory. For the previous version used (7.30), we were using shared memory, and our sqlhosts on one of the servers looks like: …
sqlexecd error 25507
How is one supposed to get a Windows client to connect to a UnixWare7 host when the sqlexecd daemon on the UnixWare7 side does not support sesoctcp as a protocol? I've been able to get sqlexecd to run if I use setlitcp for a protocol, but this option is not available on the wind…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
Re: onsoctcp..?
Hi, se means the standard edition according to Informix SE. Both, on, ol means OnLine. btw: the first entry in sqlhosts is the DBSERVERNAME not the DBNAME. Greetings, Andi…
Connection Timeouts and ESQL Programs.
Environment variables: INFORMIXCONTIME INFORMIXCONRETRY combine to control the amount of time spent attempting to connect and how manu retries are attempted before returning an error. INFORMIXCONTIME is the total time spent trying to connect and INFORMIXCONRETRY is the number …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
27001 error
What are your INFORMIXCONTRY and INFORMIXCONRETRY settings? William Fisher wrote: > Hi, > > This problem concerns the following setup. Two Sun E450 enterprise > servers (one app server, one db server) both running two CPUS and Solaris > 2.7 I'm using Informix7.31 Dynamic O…
connecting to informix database on unix from Microsoft Acess on windows
Hi, We have informix database on Sun Spark server. I was wondering if there is a way to connect to that database from a client machine using Microsoft Access. Vijay Sent via Deja.com http://www.deja.com/ Before you buy.…
Re: Error 27001!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
From: Simbarashe.Pangeti@icl.com > >please help me out to sort out this error >just do a finderr 27001 and you will get the details!!! Just read what the finderr says, and you might find some clues!!! -27001 Read error occurred during connection attempt. This error can occur …
RE: Error 27001!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Will it help you? -27001 __________________________________________________________ Read error occurred during connection attempt. This error can occur on either the client or database server side. When you encounter this error on the client side, it indicates that a network…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
RE: sqlhosts on IDS 7.31
Jane We have been running this combination at a client with AIX live since February - 32 bit tools and 64 bit engine. The information you were given was wrong. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On B…
RE: sqlhosts on IDS 7.31
I have been in contact with informix and found out that I was shipped the 32-bit versions of tools and the 64-bit version of the IDS engine. The engineer said they were not compatible. 64-bit versions are on their way here as I type (I hope). ---------------------------- Jane …
Re: sqlhosts on IDS 7.31
Jane, I'm running the same environment OS and IDS versions. Check your environment (INFORMIXSERVER/ALIAS and your network, then please post your onconfig and sqlhosts files. John ---------------------------------------------------- John F. Coyle Senior Database Administrator …
sqlhosts on IDS 7.31
I have just installed IDS 7.31 on an HP-UX 11 box. I have created a database with tables with data and can access it all fine via dbaccess. But - when I try to access the data via isql I get error message 25588 which says there is a problem with my sqlhosts file. I've looked ov…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: cannot connect from client
From: hillsa <hillsaNOhiSPAM@pegasystems.com.invalid> > >I'm pretty new to this so any help is appreciated. I am trying to >connect my client (pegultra10) to the server on a remote machine >(pegsub). I have installed the Client SDK on the client but don't know >what else to do. I…
cannot connect from client
I'm pretty new to this so any help is appreciated. I am trying to connect my client (pegultra10) to the server on a remote machine (pegsub). I have installed the Client SDK on the client but don't know what else to do. I have copied the sqlhost file from pegsub (the server where …
SqlHosts information in database table.
Use the UNIX cut command to format the SQLHOSTS file into a table unload format. Then load the results into a temp table. Run an insert SQL statement against a table you've created called SQLHOSTS where the temp row isn't already in the SQLHOSTS table. This could be setup to run …
Nis e Informix Client/Server
I setup a Unixware 7.1 box with Informix 7.3. All is fine except I plan to use NIS for my clients. If I connect via standard unix login, the user is accepted by the engine, but if I try to connect via sqlexec service, the user is not accepted. Is there a special configuration for…
Help Error 908 Connect Error ...
Hi all. Environment Server RedHat 6.2 + IDS2000 for linux + csdk2.40 Client Windows2000 + DDWeb2.0 (include connect module runtime) I Try connect the Server...but 908 Error was founded in ILogin sever setting sqlhosts, services, INFORMIXDIR, …
Re: How to connect to other IDS with Linux
From: root <root@Max.SIT.com.tw> > >My E-mail: kevinl@mail.cju.edu.tw > >The error code is: > >908: (ids0, conerr=-25555, oserr=0) 908 is a bit vague: -908 Attempt to connect to database server (servername) failed. The program or application is trying to access another data…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
WWW.DSLRESOURCE.NET
WWW.DSLRESOURCE.NET xDSL information for beginners and experts alike. Firewall software,FTP server and client software and tons of information regarding this wildfire broadband connection!!…
How to prevent
users to create Database? We have database server with clients connecting via network. I'm curious is there a possibility to prevent user to create database (users can fill whole disk space) Thnx in advance JS…
sqlhost file
Can someone please tell me how the sqlhosts file is layed out? I'm trying to identify database name and instance to connect with ODBC...not sure if the instance would be one of the parms here or not... Thanks in advance for your help, Joe Robinson, SFC System Administrator USP…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
Informix Client on Solaris 8
Did you remember to change the appropriate entries in sqlhosts? I recall receiving this error after inattentively copying a sqlhosts file over from another (functional) informixserver to a fresh install and not correctly editing the hostname field. walther@my-deja.com wrote: >…
RE: Query on SQLHOSTS
Thanks for the reply. My problem was solved. In SQLHOSTS file instead of giving the service name (sqlexec2) , I gave the port no (1529). It got connected !!! But still the mistry remains. I checked the sqlhosts and the /ect/services thoroughly. the service name is same everywher…
Query on SQLHOSTS
Hi All, I have two databases running on two different machines A and B. I have logged into machine A and wanted to connect to database@B. In machine A sqlhosts file in $INFORMIXDIR/etc dir, I have made an entry for database running on server B. dbservername olsoctcp server-B sq…
Determining (failed) client connections
Is there a way of finding out which user is failing his login attempts, and flooding my message log with that unhelpful "listener-thread: err = -952: oserr = 0: errstr = : User's password is not correct for the database server" message? Informix's tech support actually taught me…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
Informix JDBC 2.0-JC1 connection problem
Hi, Can anyone help me ? I have developed monitoring tool in java. For every server I create a poll-thread, in which I make a connection to this server. After this thread is connected to the database server's ( Solaris 2.6 ) it snoozes ( sleeps for 60 sec ) and lets the other th…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
RE: sqlhosts configuration
depends is the answer, check out your search order for server lookup, you don't mention the OS but I'd use nsswitch.conf on Solaris -----Original Message----- From: Thierry Achaintre [mailto:thierry.achaintre@euriware.fr] Sent: Wednesday, March 29, 2000 3:36 PM To: informix-list…
RE: Slow Connection from clients
Why do you ask me that. Anyone can own a DNS server. Use this to control your own domain. Typical env put your primary at your office inside your firewall, secondary controlled by ISP outside your firewall. Enable DNS on your UNIX box, it free and standard with most UNIX's. -…
RE: Slow Connection from clients
Do you own a DNS server ??? -----Mensaje original----- De: Hannes Visagie <hvisagie@mibco.org.za> Para: 'KuKi' <bertoni_TOGLIMI_@tecnest.it>; informix-list@iiug.org <informix-list@iiug.org> Fecha: mi�rcoles 29 de marzo de 2000 02:40 Asunto: RE: Slow Connection from clients >Thi…
RE: sqlhosts configuration
-----Mensaje original----- De: Thierry Achaintre <thierry.achaintre@euriware.fr> Para: informix-list@iiug.org <informix-list@iiug.org> Fecha: mi�rcoles 29 de marzo de 2000 02:40 Asunto: sqlhosts configuration >Hi all, > >When I build my sqlhosts file, is the hostname field the r…
sqlhosts configuration
Hi all, When I build my sqlhosts file, is the hostname field the result of the "uname -n" command or "hostname" command ? If I use DNS this two commands will not give the same result... Thanks. -- Thierry ACHAINTRE Architecte Syst�mes et R�seaux - EURIWARE thierry.achaintre@e…
RE: Slow Connection from clients
Not necessary. How will U enter dynamic IP ? -----Original Message----- From: Andrzej Beletsky [SMTP:andrzej@kw.ukrtel.net] Sent: Wednesday, March 29, 2000 1:32 PM To: informix-list@iiug.org Subject: Re: Slow Connection from clients Make shure you have ip adresses of clients in…
RE: Slow Connection from clients
This is typical a name service lookup delay. Check what is the delay doing a nslookup -----Original Message----- From: KuKi [SMTP:bertoni_TOGLIMI_@tecnest.it] Sent: Wednesday, March 29, 2000 10:29 AM To: informix-list@iiug.org Subject: Slow Connection from clients LAN Scenario…
Re: Slow Connection from clients
DNS? Have you tried hardwiring IP addresses and ports into the clients? From: "KuKi" <bertoni_TOGLIMI_@tecnest.it> > >LAN Scenario: >Nt server 4.0 SP4; IDS Workgroup Ed. 7.31.TC3 >Primary Domain Controller, Wins and Simple TCP/Ip Service installed >Some Win NT Workstation client…
Slow Connection from clients
LAN Scenario: Nt server 4.0 SP4; IDS Workgroup Ed. 7.31.TC3 Primary Domain Controller, Wins and Simple TCP/Ip Service installed Some Win NT Workstation clients. No problems connecting to the Informix server from the application installed on the server (immediate connection). 6-7…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
Informix Client SDK on Solaris 2.7
I am attempting to connect to an Informix server running on an HP-UX machine from a Sun Solaris box. I installed the Client SDK 2.40 on the Sun box and I am not able to connect. I get the following error from a simple esqlc program: Error -25574 while connecting to the database:…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Setnet 7.20
Hello, We will upgrade IDS 7.30 TC5 (NT 4.0) to IDS 7.31 TC2. On the clients we are running Setnet32 7.20. Can we keep on using that version of setnet to connect to the database ? Thanks in advance Franky Thiel mailto:franky.thiel@infohos.be…
Question
For any of you using Informix on a database server runnning HP-UX 10.20/11.00 using shadow passwords... Any problems or are there any issues with client connectivity ?? thanks in advance. mac…
Informix -931 error
How can i solve this error(-931) in Informix 7.30 tc6 NT. I install client part of this server and try to connect to the remote machine. At that i create all necessary settings in the setNet32. Thanks…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
-908 error.................
I'm trying to get the new SDK to run and I keep getting the -908 error. Its a pretty vague error message. ----------- Attempt to connect to database server (servername) failed. The program or application is trying to access another database server but has failed. Note the serv…
ODBC configuration problem
Hello, I am unable to configure client running on one machine to connect to Informix Dynamic 2000 server running on another machine in WinNT. I am using Informix ODBC driver 3.31.00 for Win NT. When the client and server are on the same machine, everything works fine. But when …
se 7.24 uc5 with redhat 6.1
i. cant connect to my database server either from dbaccess or informix cli from windows i receive the error -952 user's password is not correct for the database server the configuration in sqlhosts in correct, any idea Thanks Ruben…
Invalid sqlhosts format
I've this message where startup Replication Manager on my Windows NT 4.0 Workstation. The rest of programs (ODBC, IECC, ..) haven't problems with SQLHOSTS values. Thanks.…
err = -956 Client host or user is not trusted by the server
Hello all ! I use Informix-SE for Windows-95. When I connect to the server using seipcpip service - its OK. But if I want connect by sesoctcp service - I receive message err = -956: Client host or user is not trusted by the server. Thanks for help. Victor Vat vavic@chat.ru…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Posting from the Informix-list
Hi, My VB program is connecting to my database using Informix-CLI ODBC Driver. How do I set the isolation to dirty read within my client program? Many thanks in advance. Regards, Jouhshen Toh…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Re: oninit complain with sqlhosts file error
From: "W. J. Hsu" <wjhsu@pti.com.tw> > >Hello out there, Hello in there... >I tried to installed Informix Dynamic server 7.3 on my Linux box. >However, the oninit always complained with: > >"oninit DBSERVERNAME 'HOME' not in sqlhosts file or sqlhosts file contents > are damage…
oninit complain with sqlhosts file error
Hello out there, I tried to installed Informix Dynamic server 7.3 on my Linux box. However, the oninit always complained with: "oninit DBSERVERNAME 'HOME' not in sqlhosts file or sqlhosts file contents are damaged" The file "$INFORMIXDIR/etc/sqlhosts" was tailored from file "…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
ASF_INIT_DATA
Either: 1. your nettype in sqlhosts is invalid or it's unsupported. Check your release documentation to neee what nettype's work for your hardware. 2. your servicename in sqlhosts doesn't match.…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
strange session
Those messages in the log indicate that some user process is trying to attach to the engine while it is in Quiescent mode, a no-no. I take it that the messages stop as soon as you place the engine in ONLINE mode (onmode -m)? Exactly what that user informix session is I cannot g…
Client_local and DB_locale pb
Hi evryboby, I have a pb of conversion between a informix server on HP UX and my client web form. For example I have a "�" insteadf of a "�" character. My connection is an ODBC connection with client SDK 2.30 installed on NT server and parameter on the server are "fr_fr.8859-1…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
SQLhosts file
How do I modify the sqlhosts file on the UNIX server so that my server will listen for two requests, (ie: seipcpip and setlitcp) at the same time. Thanks!…
Sqlhosts Option
Hello. I have just inherited a IDS 7.30.TC3 on Windows NT system. In the SQLHOSTS entry for the server, there is an option "x=ol_maxserver", where ol_maxserver is the INFORMIXSERVER name. Does anyone know what the x option is? I checked the documentation but there is nothing t…
Problems with connect INFORMIX Online / INFORMIX CLI
Error -908 means -908 __________________________________________________________ Attempt to connect to database server (servername, conerr=connection- error-number, oserr=system-error-number) failed. The program or application is trying to access another database server but …
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
sqlhosts and dns.
We're attempting to migrate from having the lmhosts file on all the windows-based pc's to using DNS. However, once the lmhosts file is removed, the Informix client software can no longer find the database server. When attempting to connect using the ilogin utility, I get the -2…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Multiplexed connection
Hi, I am trying to use multiplexed connection to connect between 2 machine. Server is AIX4.3.2 with IDS 7.31 UC2. Client is ESQL/C 7.24 application on AIX4.2, IDS 7.22. I have configured server for multiplexed connection like it says in manuals, but when I connect with 25 users…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
SqlhostsEditor for NT
amgad@starnet.com.eg wrote: > > Dear all, > > Does any one have any clue on how to obtain the Sqlhosts Editor for NT > used by the replication manager to define the SQLhosts entries in > windows NT registery. > > In the Replication training manual it says that "The sqlhosts edito…
More details
Eric Shipek wrote: > > Sorry, I can log into the server -- I just can't log into the database. In > fact I can log into the Unix server with the informix login and password. > Then I run dbaccess and try to connect to the database ol_nisbc. Then when > I try to connect with the…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
CoreDump with an SQL/CLI
Hi, I made some API to connect to INFORMIX server. This API use functions like : SQLAllocEnv(); SQLAllocConnect(); SQLConnect(); SQLDisconnect(); SQLFreeConnect(); SQLFreeEnv(); In this order, i connect my client one time and at the second time i have a core when i call SQLAllocE…
Re: How to connect Win95/NT to Unix Informix Box via ODBC??
From: Grant Neilson <gdn@crt.co.nz> > > We want to connect via windows to unix informix database (SE). >I can get the software Client from iWWW.intraware.com but how does >This let me see the unix informix database. Do I need NFS or something else >To connect or does the client j…
How to connect Win95/NT to Unix Informix Box via ODBC??
Hi all, We want to connect via windows to unix informix database (SE). I can get the software Client from iWWW.intraware.com but how does This let me see the unix informix database. Do I need NFS or something else To connect or does the client just use TCP/IP addresses etc to co…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Find IP-Adress of ODBC-Client on Informix-Online (7.x)
In our WAN we have some Clients, they connect to our central Informix-Online (on Digital Unix) with ODBC. If the Client is listed in the Hosts-Table of the server, i can see the name of the host with the Syntax 'onstat -g ses'(hostname). But if the client is not listed in the hos…
Find IP-Adress from ODBC-Client on Informix-Online (7.x)
In our WAN we have some Clients, they connect to our central Informix-Online (on Digital Unix) with ODBC. If the Client is listed in the Hosts-Table on the server, i can see the name of the host with the Syntax 'onstat -g ses'(hostname). But if the client is not listed in the hos…
Re: DBA problems
I think you need to revisit : NETTYPE settings and $INFORMIXDIR/etc/sqlhosts file. Can you post them ? Also the Version you are running. Harinath Venkata Svenska Handelsbanken New York…
Slow connectivity to NT4/7.30
Hi, I'm having connectivity probs from Win95 client to NT4 (SP3) running IDS 7.30. The response is like 15 secs for each new connection. Specs: 1 CPU, 256MB RAM, db on NTFS, swap=64K Tested using ilogin demo on server - response of 1-2 secs. Tested using ilogin on client - resp…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Re: Example sqlhosts file
Thanks for pointing me in the right direction - The release note do specifically say that the only supported protocol/interface is TCP/SOCKETS. Thanks again to everyone for their help - Despite the fact that all I needed was to Read The Manual (though I couldn;t find it), everyo…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: Example sqlhosts file
Rick Mills wrote: > > dua1@my-dejanews.com wrote: > > In article <7c71it$qmg$1@eve.enteract.com>, > > > > Art S. Kagel > THere are no release notes with the ftp'd file, and none that I can see > on the site anywhere. Does anyone have release notes specific to RedHat > Linux 5.2? …
Example sqlhosts file
I've used Informix since ver 1.1 (just had to say that), but am confused by the sqlhosts file. The last version I worked on was 4.1 and didn't use it for the SE engine. Now that I've D/L the 7.2 SE (no docs) I'm in the dark about the sqlhost file. Can anyone give me a breif examp…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
How to connect via a browser to a bundle Informix version on HP-UX ?
Dear all, I am desesperately trying to connect to an Informix DB located on an Unix server. The issue is that the Informix version I have is a bundle used by an application. I have the ODBC driver (SDK Client) but I still can not connect this DB. Is there any possibility to do…
Informix-Connect and Client SDK
Informix claims that "Informix-Connect" consists of runtime versions of the client products and that "Informix Client SDK" consists of the development versions of the client products. From my experience, the claim on "Informix-Connect" does not appear to be true. I recently inst…
CONNECTION OBJECT
I am using RMI to connect my client-app to an Informix Online Dynamic Server 7.2 I have a single connection object which is used (synchronized) by all the clients. I suspect there must be a limitation in requests to the same connection. Each remote method reuses the object fo…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
sqlhosts
Subject: sqlhosts Newsgroups: comp.databases.informix Summary: Keywords: I need some help.I get the error message "908: Attempt to connect to database server (unix2_se) failed", when I tried to select my database from the "isql" Datbase menu. I checked the sqlhosts, /etc/hosts a…
Database connection
Michal Klacan wrote: > > Please help. > > I have Informix Dynamic Server version 7.3 for Solaris. > I configure it and set all files as: > > /etc/services > $INFORMIXHOME/etc/sqlhost > $INFORMIXHOME/etc/onconfig If the above two lines are not a typo this is the problem. The en…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
RE: Client disconnects
> -----Original Message----- > From: Marichamy, Udaykumar > Sent: Thursday, January 14, 1999 3:51 PM > To: 'iiug@informix-list.com' > Subject: Client disconnects > > If during a client-server Informix Update process, initiated from the > client desktop, the NT client is disconnec…
Attempt to connect to database server xxxx failed
Yi Chen wrote: > Hi, > > We randomly had a connection problems from client to server with > followning error message: > > Attempt to connect to database server xxxx failed. Any messages in your online.log? June -- june_t@hotmail.com Grounded in Palo Alto, living on M&M's (plai…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Client-Declaration
Hi, im totaly new in database-connectivity, but i have to connect to an already installed informix-Online 7.22 DatabaseServer. I've installed the client-software (cli) and used to configure the client with setnet32 but it does not work anyway. Can anybody send me an instructio…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
16-bit ODBC connection
Has anyone had any success with a 16-bit ODBC connection from a Windows 95/NT client, to an Informix database (9.1.4) running on a UNIX server (SUN Solaris 2)? If so what are the components I need to connect, i.e. middleware and ODBC driver. Thanks in advance, Glenn Moodie…
Re: Conflict between two Informix databases
Kent Mills wrote: > > We have recently installed a second copy of Informix on a new server. [SNIPPED problem description] Post your sqlhosts and ONCONFIG files, the output of uname -a and the /etc/services lines showing your port numbers used in sqlhosts and someone may notice s…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: shared memory not initialized for INFORMIXSERVER
The fact that you can work when 'if I telnet to the server, everything works fine. ' may indicate that you have no NETTYPE for shared memory in your onconfig and sqlhosts files. Hope this helps, Carl…
ODBC to Linux connection. Error -956?
Hi, I'm trying to get a windows client to connect to my SE server on Linux (Red Hat 5.2). The problem I'm having is when I run Ilogin, I get an error -956 ("Client client-name is not in /etc/hosts.equiv on the remote host."). I can watch, when I try to connect, and see message…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
RE: error -908: why?
This is what I've got from finderr -908 Attempt to connect to database server (servername, conerr=connection-error-number, oserr=system-error-number) failed. The program or application is trying to access another database server but has failed. Note the server name in the curren…
Re: SQLHOSTS file layout ???
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
SQLHOSTS file layout ???
What is the layout of the sqlhosts file. Is is the same as a /etc/hosts file or does it have a special format. Can't find any examples . . .…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Connecting linux client to Informix on NT?
Hi, I've been looking on the net to see if it's possible to connect my linux client to our Informix database on an NT server. So far I didn't find sources/libraies to do this... Is it possible? Robert Robert@pmw.plantijn.nl…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Problem with connection PC to INFORMIX ONLINE 7.22
I have problem with connection PC (WIN95) to INFORMIX ONLINE server 7.22. On my PC I have instaled Informix Connect software as a Informix client and I traying to connect to INFORMIX ONLINE 7.22 server on SCO Unix - there is no efect. I configured every needing file on my PC ( C:…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: netsrv.iem
In article <35537A28.5A9C@colburn.com>, Colburn <postmaster@colburn.com> writes >I would like to change my sqlhosts setting for local connections from >onsoctcp to onipcshm for performance. Whenever I change it, my users >start to get errors that it cannot find netsrv.iem when u…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Informix 4.0 on SCO
Am considering upgrading old SCO unix (no ethernet) to current (with ethernet). Will existing Informix software (SQL,4GL) require any updates / additions? Or does it care? Canl ODBC clients connect? Thanks, Ken…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Connecting to Informix using ODBC
I am trying to connect to Informix 7.2 using ODBC from an NT server with Informix-CLI 2.5. When I try to connect, I receive an error number -908. I reference the error number and found the following messages: Attempt to connect to database server (servername, conerr=connection-e…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: sqlhosts - valid entries ???
Although I come from a Windows NT environment, I might be able to share a little bit of wisdom. I will (unfortunately) need to speak in "Windows NT-speak" so I hope you are able to translate into AIX =) I run Informix Online Dynamic Server on NT4.0 (version 7.23 of the database…
sqlhosts - valid entries ???
I'm running INFORMIX-SQL Version 7.10.UC1 on a Powerstack (AIX 4.1) and attempting to access and older 4.x SE database via NFS. I get an error to the effect that I have en invalid entry in the sqlhosts file. Now, I've setup entries in this file before using tcp sockets, etc but …
client connections for ODS 7.23.UC4
G'day folks, I am looking for information on how to set up a NT client connection to our ODS databases residing on a Solaris 2.5 machine. I know the basics on the server.....sqlhosts, /etc/hosts, /etc/services and configure the protocol. What does the client NT machine nee…
OPTIONS values in SQLHOSTS registry
I' m having difficulty finding complete documentation on the OPTIONS:REG_SZ: key in HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SQLHOSTS\\mname\\ for Informix under Windows NT. Of particular interest are possible r=0 and s=0 options. Does anyone have a pointer to reference documenta…
Beginner: What is Sqlhosts good for ?
Hello, in our department we got the informix database, and I has to deal with it. (Programming in perl/DBI/DBD). Though I looked through all manuals we got, I cannot find a specification regarding the /etc/Sqlhosts file. What is it good for ? Besides, our database was a gift, an…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
INFORMIX 5 : is there a SQLHOSTS file ?
Hi ! I have been using Informix 7.2 / CLI 2.5 / ODBC. Now, I have an application I need to test against an Informix - Online 5 Database. The database was installed, I have created tables etc.. The problem is connecting to this database via CLI or ODBC. I was not able to c…
Re: Client/Server Connection
We currently use Online version 7.23 and GQL version 4.11. Within windows 95 you will have to use setnet32 to install the 32 bit I-NET layer needed for connectivity. Other than that, its a piece of cake. One thing you will have to watch out for is the hosts.equiv file that res…
Client/Server Connection
-- [ From: Richard Wellis Sinyem * EMC.Ver #2.5.02 ] -- Dear All, We are planning to install and implement a client EIS application development tool (i.e Andyne GQL). Environment listed below: client: Win95 client service protocol: Microsoft TCP/IP EIS: Andyne GQL v3 (Wi…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: Network connection.,,
>From: thabib@bob.zentropy.softaware.com >Date: Mon, 7 Jul 1997 17:25:59 -0700 (PDT) >X-Informix-List-Id: <list.15334> > >I'm trying to connect to a INFORMIX-OnLine Version 7.12.UC1 (online >dynamic server) with a esql/c application (INFORMIX-ESQL Version 7.12.UC1). >I have doubl…
Informix sqlhosts and LiveWire connection
Do anyone know what's wrong here? I have an entry in the sqlhosts file with a g=xxx option(used for replication?). Trouble is that LiveWire reports this error during connect: [VENDORLIB] Vendor Library Error: Illegal sqlhosts file option/parameter Removing the g=xxx option wou…
I-Net from one Windows Client to Online 7.xx and SE 7.xx
Hi Is it possible to connect via I_Net5/ODBC to both an Online 7.xx and a SE 7.xx from within the same Windows-Client? When I set the path for the SE in the informix.ini file on the client, then the connect to the Online does no more work. Greetings Philipp Gruenig Tecno Softw…
HELP!
What do I really need to connect MS-ACCESS to INFORMIX-SE 7.10? I am using W95 clients and a HP-UX operating system on the server. I will appreciate your comments. GILMAR…
Does OS/2 connect using ODBC via TCP/IP?
Hi all, Does anybody know if it is possible to connect an OS/2(version 3)-client to an informix database via ODBC? The server and client are connected via IBM TCP/IP version 3.…
XPS - Client connectivity
Is anyone out there using XPS 8.11? If so, I would like to discuss client configuration using Connect 7.20. Let me know and I will explain my problems.…
Re: 7.1 initialization error
Check if the "informix" user can write into "/INFORMIXTMP" if this directory exists or into "/tmp". If this doesn't work you should send more information (logfile, onconfig, sqlhosts, ...) Uwe…
I/NET and SQL/NET
Has any had any problems or issues with running I/NET and SQL/NET on the Same client, connecting one application to oracle and another to informix. -- Matthew Morris mmorris@lmberry.com mcmorris@infinet.com…
Re: Client Connections to Informix
Dale Forrey wrote: > > I have installed my first instance of Informix 7.20 on an IBM AIX > box. I then installed Informix CLI 2.50 on my Windows 95 workstation and > discovered that I had to have an entry in the hosts and services files on my > workstation. My next disc…
informix net with windows clients running dhcp
Hi folks, This may turn out to be a vague question - mostly because I don't have many details - I am not doing the work myself.... Anyway, we'll be connecting some windows nt clients using informix net (is that the name?) to a backed informix db running on an hp system. The init…
Re: Client Connections to Informix
Dale Forrey wrote: > > I have installed my first instance of Informix 7.20 on an IBM AIX > box. I then installed Informix CLI 2.50 on my Windows 95 workstation and > discovered that I had to have an entry in the hosts and services files on my > workstation. My next disc…
Re: Client Connections to Informix
Kerry Sainsbury wrote: > > In article <5ddti0$57s@cssun.mathcs.emory.edu>, > forrey@wsu.edu (Dale Forrey) wrote: > > Regarding "hosts", you could configure the PCs to use a Domain Name Server > or you could use IP addresses rather than host names in setnet. > You still have to u…
Re: Client Connections to Informix
In article <5ddti0$57s@cssun.mathcs.emory.edu>, forrey@wsu.edu (Dale Forrey) wrote: > I have installed my first instance of Informix 7.20 on an IBM AIX >box. I then installed Informix CLI 2.50 on my Windows 95 workstation and >discovered that I had to have an entry in the…
Re: Client Connections to Informix
forrey@wsu.edu (Dale Forrey) wrote: : I have installed my first instance of Informix 7.20 on an IBM AIX :box. I then installed Informix CLI 2.50 on my Windows 95 workstation and :discovered that I had to have an entry in the hosts and services files on my :workstation. …
Client Connections to Informix
I have installed my first instance of Informix 7.20 on an IBM AIX box. I then installed Informix CLI 2.50 on my Windows 95 workstation and discovered that I had to have an entry in the hosts and services files on my workstation. My next discovery was that there also had…
Multiple client INET connections
Can anyone tell me if there should be any connectivity issues when establishing simultaneous connections to two distinct client applications, utilizing INET 5.01 and Informix On-Line 7.1 Thanks in advance -- ------------------------------------------------------------ The opinio…
Re: Database Connection NT-Unix
Hi, Check the $home/.rhosts file in the client or the /etc/.hosts.equiv in the server. These files contain the list of hosts and clients considered trusted. The .rhosts file should have the name of the server you are trying to connect. Or the .hosts.equiv should have the name of…
Database Connection NT-Unix
Has anyone an idea how to connect from an Unix-Client (OnLine 7.13) to an Informix-Workgroup-Server 7.1 running on NT 3.51 ? The connection is always refused with the error -956 (client is not trusted by the database server). Username and password are identical on both machines. …
I-NET AND CA-UNICENTER
We have a client server application that establishes a connection to Informix database server on the HP-UX box using I-NET with WINSOCK DLL. It's bypassing CA-Unicenter's security system. Has anyone had this problem? Thanks…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Communication between servers and Informix 5 and 7
U should use the server name set up on remote host and this server should have an entry in your sqlhosts file. HTH ____________ Sanjay Kumar Email: skumar@raileurope.com…
ODBC Driver for Informix 5.x
Hello, I am looking for available ODBC drivers for an Informix 5.x Online database engine in order to connect Windows Clients to a HP-UX 9.04 system. Does anybody has a list of available products. Thx Klaus…
Tracing sqlturbos back to client connection
To simplify security maintenance on Unix in an environment that handles about 50 changes a week, we do all security checking on Novell and stop application access there. Then, all users come in under the same ID, using Power Builder queries. Using Informix, all their processes o…
7.12 SGI sqlhosts problem?
I am installing 7.12 for SGI Irix. I run oninit -i and get: DBSERVERNAME xxx not in sqlhosts file or sqlhosts file damaged. This file works fine with 7.1. I have checked and re-installed the product 3 times, ensuring the INFORMIXDIR env var is set etc. I have check the permiss…
Client Server Connections w/INET
I have been connecting to an Informix database (on a SCO Unix server) using the INET software with the FTP TCP stack on a Windows 3.1 workstation. I recently converted to Windows for Workgroups 3.11 on an NT domain and switched to Microsofts TCP stack. Now my client server conn…
Accessing ORACLE from Existing I4GL Programs
Have a client that would like to implement existing I4GL programs on an ORACLE database. Any one know of third party ODBC like products to connect I4GL applications to ORACLE/SYBASE or other DB's.…
Multiple concurrent connections per client
Hi all, I am working with online version 5.0 and need to open more than one connection to the database. I require this for implementing concurrrent mutually exclusive transactions. Ie. I must be able to commit one transaction and use the results within another transaction that m…
Client not connecting to Server!!!
I am running SCO Openserver Enterprise 5, and just installed Informix 7.1. I can initialize the dbspace just fine. However, when I try to connect to the server with dbaccess, I get a 908 error message - permission denied - attempt to connect to database server failed. My tcp/ip…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
sqlhosts file
Does anyone know the fomat for the sqlhosts file? I am using Informix for SCO unix. -- Long Live UNIX !, Windoze is a waste of time.…
Connecting From Client to Server in Online
We are working in Online 6.0. Had a tough time connecting from one Unix Client to the other Unix Server. $INFORMIXDIR/etc/sqlhosts on Client I hope need not be the same as of on the server. $INFORMIXDIR/etc/sqlhosts on Server is as follows testing ontlitcp Client telnet where…
<No Subject Supplied>
I have a client that wants to utilize viewpoint on client machines to connect to a server database. What do they need to buy to allow connectivity? Their informix sales person does not seem to be clear on what is needed. First they gave a bottom line of $40,000 then $3,000.…
Is informix a client-server DBMS?
I'm interested in connecting informix running on a UNIX server to powerbuilder running on a PC. Can this be done? Some one told me that it could not -- because Informix was not a client server DBMS... Any input would be appreciated. Thanks - faisal…
What Client workstation is the user connected to?
We are using Online 5.01 and I-NET PC 5.01. When trouble shooting a perticular user process say from 'tbstat -u' output, how can I identify which client workstation that perticular user is connected to. One solution is to give each clent workstation a name and let users only us…