Oninit® Archive
Results for “REMOTE_SERVER_CFG”
kill idle session
database sysadmin; select sid, username, dbinfo('UTC_TO_DATETIME',connected) conection_time, current - dbinfo('UTC_TO_DATETIME',connected) connected_duration from syssessions order by 4 desc,2,3…
No Trust/No HDR?
informix-list-bounces@iiug.org wrote on 03/01/2010 12:16:26 PM: > From: > > "red_valsen@yahoo.com" <red_valsen@yahoo.com> > > To: > > informix-list@iiug.org > > Date: > > 03/01/2010 12:20 PM > > Subject: > > No Trust/No HDR? > > Sent by: > > informix-list-bounces@iiug.org > > Is …
DRDA redirection to HDR primary
Hi Gerd. Could you share your connection string to CM? I'm trying to connect via JDBC (ifxjdbc.jar). Thanks, ------------------------------ Victor Huaquisto Email: victor.huaquisto@gmail.com Lima-Perú ------------------------------…
REMOTE_SERVER_CFG issue/question
All, I tried posting this via the web, but every time I click on the "Post" link, I get a pop-up stating: Access Denied You don't have permission to access "http://community.ibm.com/higherlogic/ui/mvc/contributedcontent/contributedcontent/createQuestion" on this server. Reference…
Who needs a HOME?
Informix-only level trust through REMOTE_SERVER_CFG and/or REMOTE_USERS_CFG, since early 11.70... ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------…
HDR Issue
Remove the s=6 from the sqlhosts files, until you have verified the connectivity. Then, from your secondary server, see if you can connect to the primary server with that connection, e.g.: (On ifxdb2), run: dbaccess sysmaster@ol_ganga_prim Check any error messages and check the …
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 ------------------------------…
Question of dostats
Thanks Art. Another question, Is TCP connection preferred to other type of connection (e.g, shm, ssl, ....) for running dostats ? Thanks Frank…
HDR
Hi Amit, on_nebula21 has to be aware of connection details of on_nebula31 and vice versa, so first of all you need to add on_nebula31's sqlhosts line to on_nebula21's sqlhosts file and also the other way round - how else could a connection be established from one to the other? Th…
ontape error
Hi Sergio Any type of replication will require server/user level equivalence; it's not specifically an ifxclone requirement. Is using REMOTE_SERVER_CFG the policy in your organisation? If it is not, I would elect to use hosts.equiv as this has been a tried and trusted method for …
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…
Connection Managers not forwarding connections
Hi, We had an upgrade for the whole informix cluster and after bringing up all the servers , couldn't resync HDR with primary because it was always causing checkpoint blocked on the primary. Afterwards, I noticed that the connection managers aren't forwarding traffic, restarted t…
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…
Connection Refused
Dear colleagues: I have the following problem: My PC has a 64-bit Windows 10 installed, and I have an Informix 7.31 TD6 engine installed, which works perfectly. I also have the SQL Editor installed, and it connects without any problem to said engine. As I also have to run a 16…
Trusted context
You're missing, or better saying, confusing different concepts. Informix has a trusted connection and a trusted context. They are very different things (in spite of the similar names) A trusted connection is a connection to a database server where no password is given and for th…
Does DBD::Informix support SSL connections ?
Does DBD::Informix support SSL connections ?…
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.…
Re: HDR Question
Ok, just some steps/checks: 1) preparation of the sqlhosts file is needed - you need to have minimum one entry for the primary instance, and one entry for the secondary instance. We keep the file identical on both hosts The lines should be like: prim onipcshm localhost localhost…
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…
OAT is not connecting to database server
I am giving the fully qualified hostname. but not connecting…
Rebuid sysmaster database and effects in a HDR/RSS
Hello MUKESH, Unfortunately, we have implemented the HDR environment on AIX / Power7 machines. We do not work with IDS in Windows environments. But on the subject you comment I can tell you some links that I think will help you: https://www.ibm.com/support/knowledgecenter/en/S…
HDR Implementaion
Hi, this was already answered multiple times to your request. https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/i ds_admin_1407.htm create a text file named hosts.equiv with a notepad editor in \\\\%WINDIR%\\\\system32\\\\drivers\\\\etc You will nee…
HDR Cannot connect
If I connect to the instance on the local machine, I can connect. If I try and connect to the instance on the remote machine, it fails...darn.…
dbaccess & hosts.equiv
Use REMOTE_SERVER_CFG and create your own hosts.equiv instead of using the OS one ? Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Informix DBA Sent: Thursday, March 23, 2017 11:31 AM To: ids@iiug.org Subject: dbacce…
Cannot Connect To Newly Installed Informix
Your login did not include password credentials so you are depending on a trusted host relationship. Make sure that user informix is trusted on 192.168.206.141 from 192.168.206.1 with an entry in one of: - /etc/hosts.equiv - ~informix/.rhosts - the file listed in the REMOTE_SERV…
HDR setup issues pertaining to hosts.equiv
Before testing Informix HDR to a new box (uxtest-drunix) I had setup HDR between two other boxes (uxdev-uxtest). I encountered a few issues setting up this (the uxtest-drunix HDR). One of the most persistent error I noted in the log was: 12:01:11 listener-thread: err = -956: ose…
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)…
connection Manager
Hi All How exactly connection manager works with ? Can anyone help me configure connection manager, I have heard that it has some bugs, is this so? Thanks Jaya…
Informix Authentication failure with Hp-Unix
err.... that's why oninit is owned by root and setuid.... or was this a non-root informix installation? On Aug 24, 2015 8:31 PM, "Vaibhav S Dantale" <vdantale@in.ibm.com> wrote: > Forgot to mention that Jonathan Leffler was really helpful in debugging=20 > the issue. Thanks Jona…
RE: Limiting access to instances when using OS aut
If you are using hosts.equiv and can upgrade one of the servers to 11.70.xC4 or higher you could use onconfig parameter REMOTE_SERVER_CFG to limit connections. Regards, David. > On 25 June 2015 at 20:40 LARRY SORENSEN <lsorensen25@msn.com> wrote: > > > Thank you all. I was hopi…
RE: hosts.equiv and rlogin
In general for UNIX/Linux I would hope the "r" commands are gone already! If you need to functionality for Informix the better option is to move to 11.70 and use the new REMOTE_SERVER_CFG parameter to have a seperate hosts.equiv file for Informix. http://www-01.ibm.com/support/…
Data Encryption
I have customers using Vormetric - I think it does what you are asking Cheers Paul > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > Rubinstein, James > Sent: Friday, February 13, 2015 9:41 AM > To: ids@iiug.org > Subject: Da…
Trusted Connection
Ok, Fernando. Thanks a lot. I got two machines in a cluster environment and I MUST to declare on hosts, and hosts.equiv on both of then. That was the problem. Thanks > To: ids@iiug.org > From: domusonline@gmail.com > Subject: Re: Trusted Connection [34511] > Date: Fri, 23 Jan 20…
Intermittent DNS failures
Being able to complete reverse DNS is not a requirement for an Informix connection (unless it's a trusted connection and you use names in the hosts.equiv or .rhosts files. So the answer is yes. But of course please test on another system. Don't forget to restart the database afte…
Connection Manager
Started Connection Manager successfully. It is pointing to 2 servers (Primary/Secondary HDR). I log into the secondary server and run 'onstat -g cmsm'. It shows me the connection manager name/version, cluster name, even failover arbitrator/order/timeout details. It completely lea…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
not trusted
Somehow the Informix process doesn't see it self as that name... That's easy to happen if you have multiple TCP interfaces (I assume you're connecting through TCP). It would be interesting to see your "sqlhosts" configuration. The message cleary says that the server resolved the …
block connections sysdbopen
Hi, As I can block access to odbc connections within sysdbopen?…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
VB6 connection string to ids 11.5 64bit failing
Thanks That resolved the issue. I created a 32 bit connection.…
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.…
11.7 - REMOTE_SERVER_CFG
I would benefit greatly from being able to manage my own hosts.equiv; as /etc/hosts.equiv is owned by root and I have to jump through hoops to update. I have an HDR pair setup on separate servers for testing. On the secondary node, I set the REMOTE_SERVER_CFG value in ONCONFIG an…
Re: Connect to database error -951
No., no, please no... Informix/IBM took around 20 years to fix something that customer kept complaining... So now that it's solved let's not keep the bad habits Please use the parameter REMOTE_SERVER_CFG in $INFORMIXDIR/etc/$ONCONFIG.to define a file (located in $INFORMIXDIR/etc)…
test connect
Hi All, Is there any other alternative select statement just to check the database connection?. I'm doing "select count(*) from systables". IDS 9.4 Solaris 5.7 thank you,…
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
On Fri, Jan 18, 2013 at 4:14 PM, JOHN CALLICOTTE <john.callicotte@ottawa.edu > wrote: > sqlhosts: > > ksotinfx01 onsoctcp ksotinfx01 istartrain2 > ksotinfx01_shm onipcshm ksotinfx01 ksotinfx01 > istartrain onsoctcp ksotinfx01 istartrain > > onconf.cars: Too long to post here, bu…
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,…
S6_USE_REMOTE_SERVER_CFG
Ok, so S6_USE_REMOTE_SERVER_CFG is not relevant for my purposes since I'm not using any options for my connection. The system default location for the hosts.equiv is in /etc, not $INFORMIXDIR/etc. The REMOTE_SERVER_CFG MUST be defined to hosts.equiv for IDS to use $INFORMIXDIR/e…
use of connect statement
Version 11.5 FC8W2 on Linux Does anyone know of a way to prevent a user from using the CONNECT statement to connect to the database as another user? The users are connecting using dbaccess. I've limited the menu options on dbaccess so they can't use that to change users, but th…
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…
dotnet and connection manager
HI, A partner write the application using dotnet. currently they use HDR on IDS11.50 FC8,but they don't use connection manager. Do anybody know whether connection manger could reroute the connection request from DOTNET? thanke for your time.…
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 …
HDR not working
Be carefull... $INFORMIX/etc/hosts.equiv is not the default place for Informix to validate trusts. For replication only connections (when you use "s=6" option in $INFORMIXSQLHOSTS) it will look there. But for normal ports (which can also be used for replication) be default it wi…
Connection Manager
I have setup an RSS server but I am having problems getting it working properly with Connection Manager. Here is what I am running. IDS 11.70.FC4GE CSDK 3.70.FC4DE ServerA - Primary server ServerB - SDS ServerC - RSS The connection Manager config file is - NAME conn_man LOG 2…
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.…
Problem with .net
Hi, I try to connect with iLogin and winsql(i run scripts from winsql) Both clinents correctly connects to db, i can modyfy tables, procedures etc. The firewall isent problem, i try to connect from localhost, so network settings arent problem(I hope they arent:)…
need refresher on DBSERVERNAME/ALIASES/NETTYPE/SQL
On Mon, Apr 18, 2011 at 10:15, Norma Jean Sebastian <njiiug@gmail.com>wrote: > Hello, > > Please point me to a good refresher document about setting INFORMIXSERVER > and it's relation to DBSERVERNAME/ALIASES > DBSERVERNAME is the 'official name' for the server. DBSERVERALIASES …
How about to authenticate without OS account?
Fernando, thank you for your advices but apparently it does not help. See below Tue, 18 Jan 2011 20:13:41 -0500 (EST) письмо от "Fernando Nunes" <domusonline@gmail.com>: > I'm sorry if my post contains wrong assumptions. I didn't …
dostats IDS 11.70
The problem with trusted contexts occurs when: (A) The program uses CONNECT and WITH CONCURRENT CONNECTIONS, and (B) Was compiled with CSDK 3.50 or earlier, and (C) Is run against CSDK 3.70.xC1 Iibraries. This is a bug, and an awkward one. There are two immediate workarounds a…
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…
informix dropping idle connections
Cesar this script appears to kill idle unix login sessions not database connections…
Any Mac IDS users out there?
I'm curious if IBM supports IDS connectivity via Informix's connectivity or DRDA?…
Memory Management
oh..also think around 300 threads connected to this database.…
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…
HDR Problem
Hi, I don't think that it matters which order you identify the two servers to each other, though I've always started with the primary IB I've done it the other way around without problems also. Yes, the two systems must trust each other, at least for the specific user(s) that wi…
Re: How to secure ODBC connection
> From: red_valsen@yahoo.com > Subject: Re: How to secure ODBC connection > Date: Mon, 30 Nov 2009 09:53:20 -0800 > To: informix-list@iiug.org > > On Nov 20, 2:57 pm, LIGHT SCANS <light_sc...@yahoo.com> wrote: > > Sorry. You cannot encrypt ODBC. For internal systems you can > >…
Restricting Connection to Informixservers
Because of enhanced network security requirments, I have an informixserver for which I've configured a dbserveralias running onsocssl for users of developed applications which require access to the database, but strictly through the developed application. I'd like to restrict th…
dbaccess with onsocssl
Can dbaccess use an onsocssl connection? Running IDS 11.50.FC4 on hpux11.23…
CDR connect error
Hi while trying to set up a new replicate and working on a very long queue (up to 80.000.000 length whatever) there appear connection errors in the message log: 17:26:57 CDR: Re-connected to server, id 5, name <grp_sun1> 17:27:19 CDR NIF receive failed asfcode: -25582 oserr 6…
ODBC - Database Locale Information Mismatch------W
Well, nevermind. I was using a created DSN-less connection in the app so configuring the ODBC connection did no good! I would still like to know how to set this (DB Locale) in the connection string, but the ODBC setting works...…
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…
Now for some interesting news...
IBM Q3 in... According to the main press release quarter was flat for IM. Does anyone have more specific news, like Database sales up/down while other IM products up/down? (Yes IM sells other products like ETL, BI, etc ...) Just curious. I wonder how long it will take before I…
help:root can't logon "log mode ansi database"A
create database db01 in dbs01 with log mode ansi grant dba to root grant connect to root dbaccess using root 387 no connect permission i don't know why??please help??…
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…
Connection Manager - restrict connections
Greetings all, In a world where multiple DBSERVERALIAS values exist, is there a way to restrict which ones the Connection Manager tries to establish connections through? As a brief example, If I have these values in the ONCONFIG file: DBSERVERNAME aspbeL1 DBSERVERALIASES hdr1P…
Re: Connection manager redirect
A Network error, because the client at the public network can't connect directly to the IDS server at the private network, it's for that reason we use the connection manager between them. We want to know if always the connection manager is used only to the initial connection to t…
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…
RE: Trouble connecting to IDS 11.5 development server using SQuirrel SQL with IDS JDBC driver.
Ian. I suggest you go back and check your attitude at the door. Did I say I had a netgear router? Nope. Did I say my client has a netgear router? Nope. Did I say how old the routers were? Nope. The point, junior is that the routers may allow for DHCP, but from their web interfa…
Trouble connecting to IDS 11.5 development server using SQuirrel SQL with IDS JDBC driver.
> Date: Tue, 14 Apr 2009 08:43:07 +0100 > From: goddai01@hotmail.co.uk > Subject: Re: Trouble connecting to IDS 11.5 development server using SQuirrel SQL with IDS JDBC driver. > > Exactly what part of the phrase "p3.12 of the IDS 11.50 IDS > administrator's guide" did you not u…
RE: -952 Authentication Error on Solaris 10
> From: nateman@kc.rr.com > Subject: Re: -952 Authentication Error on Solaris 10 > Date: Fri, 27 Mar 2009 06:20:48 -0700 > To: informix-list@iiug.org > > On Mar 27, 7:59 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- > emmendingen.de> wrote: > > Hallo Nate, > > > > You have .rh…
-952 Authentication Error on Solaris 10
nateman@kc.rr.com wrote: > I'm running IDS 9.40.FC9 on two new Solaris 10 DB servers - one for > prod, one for test. The prod one is live and functioning OK. I'm in > the process of setting up the test one (a little backwards, I know, > but there are reasons...). I can log into t…
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…
How to connect database resides on different host
Thank u guys!! I am now able to connect to the database!!…
Informix IDE
What are my options for IDE's to connect to Informix both free and nonfree. I know there is Data Studio and Toad is able to connect. What do most users here use?…
Informix 10 Data Base Links Across Servers
Not exactly an example of ant you want: http://informix-technology.blogspot.com/2007/11/informix-user-authentication-pam -for.html Check part II of the article. It has some examples of configuring the sysuser database for cross instance queries. If any of the articles (part I a…
-25588 error after CPU & fiber channel failure
John, See if the app can connect if it uses the network connection (carsitcp) instead of the shared memory connection. Mike…
Connection Pool
Hello everybody! I have been looking for this issue for some hours and I wasn't able to find anything. How can I use the connection pool for IDS 9.4? I'm developing in C# of Visual Studio .NET. Until now I have been using Oracle. And to use the connection pool, I only had to u…
slow connections
IDS 10.00.FC7 on AIX 5.3 on IBM P550 server Greetings fellow IIUGgers, I'm getting sporadic slowness establishing connections OR complete connection timeouts. Not sure what could cause such behavior, the server is 95% idle. Any recommendations where to look? I can provide other …
ODBC connection failing
Hi The new host is a copy of old one so all the IDs exist with the same password. Only difference is shadowing is enabled in the new server. dbauth:124545445yuyuy:501:102:Database Authentication:/home/dbauth:/bin/rksh (Old) dbauth:x:501:105:Database Authentication:/home/dbaut…
Re: Configuring IDS for multiplexing
does NETTYPE sqlmux place any limits on # of sessions/connections. The output from onstat -a shows max connections of 120 consistently. NETTYP tlitcp,3,250,NET should allow up to 750 connections.…
connecting to informix
I am trying to connect to Informix using an existing application with a field for a connection string. Using the ODBC driver works great, however I would like to use the .NET driver for performance reasons. Is there a way to specify the string use that driver instead of the curr…
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…
Syssessions connected
I am attempting to write something to cleanup all the disconnected sessions on my 11.10 server automaticly. 9.4 never had this problem but my problem now is, the sysmaster-syssessions.connected variable. Should show some sort of time yet it is an integer variable. I found it ful…
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…
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.…
Connection Error
Hi Guys, I trying to connect to informix database with a specific user name. No trouble if I do it using login and password before I run dbaccess utilility. But, when I tried to do it using the connect option of dbaccess, and typing user name and password, enginne gaves me the …
Re: connect && rename && connect
Thanks Radhika, but that doesn't fix the problem. I don't want to disconnect my current connection and I don't want to switch to a connection to the server (but I will have to!). I will report the bug, as soon as I know how to do it. Thanks Jonathan. On 5/6/08, Radhika Gadde …
connect && rename && connect
Why am I getting an SQLCODE == -425, ISAM error == -107? I haven't found anything in the online documentation about making an implicit connection when renaming a database. onstat -u doesn't reveal any other connection different from anydb. $ uname -a SunOS since 5.10 Generic_127…
Re: Problem with Windows domain users
Martin, I just posted a blog entry with what I believe to be a summary of the known problems with IDS in Windows domain configurations: http://www.ibm.com/developerworks/blogs/page/gbowerman?entry=ids_problems_with_windows_domains As of IDS 10.00.TC6 the situation was not good …
connection ?
I'm trying to verify if a user is connected to the database by my shared memory connection ... is there a table or onstat that can give this to me. I've looked at the onstat -g env and that shows the proper INFORMIXSERVER, but I'm not sure if they connected that way or with the T…
JDBC Connection
I'm trying to connect to an Informix DB V7, using the jdbc driver. The connection string I'n using is; jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME> I'm not sure the info I'm being given is correct. I can ping the host. Where can I see what the DB and SER…
Re: Problem with Windows domain users
> There should be no difference in authentication behaviour between > 7 and 10.0. Unfortunately the difference exists. I have 3 clear instances on my computer installed locally - 7th, 9th and 10th. First two give me connect as domain user (using short name without domain and back…
connection issues
Hi all, we are having issues with connections not being released timeously from the database. We are running IDS 10 FC5 on an HP/UX box. Users connect to the database over ODBC or via the informix native drivers on to an onsoctpc connection to the database. We either run into…
IDS On Win Vista Ultimate
The 11.10 Windows machine notes has the following: 3. Enable Connections on Windows Vista To enable connections between database servers on the Vista operating system, you must enable network discovery and NetBIOS over TCP/IP. To enable connections: 1) From the Control Panel…
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…
cdr repair and Invalid connection-type.
> (1) Can we avoid .netrc file to use it? Yes, here is how you setup trusted environment for ER using s=6. (excerpt from page --- http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp?topic=/com.ibm.s ec.doc/ids_am_032.html ) When you set s=6, the Enterprise Replicatio…
Monitor connection of remote users
Our OS is HPUX 11.23 - IDS 10.00.FC6. We have recently acquired the FOURJs Genero BDL product and are currently developing browser based applications. My question deals with tracking and monitoring user connections. All users will have a unix account and password that grants a co…
Number of users
Hi Can I limit users connection ? I want to limit just 90 users to connect in Informix ( 9.40 , HP-UX PA Risc 64-bit ) Thanks Ricardo…
Computer Security Information
I Want To Share Computer Security Information To All Internet Netter: 1. Firewalls Torn Apart 2. Guide To Social Engineering 3. Social Engineering And Email Account Cracking 4. Network Firewall Security 5. Hijacking Hotmail Accounts For Newbies 6. Various Ways To Hack Or Ov…
Error 25588 : IDS 7.31UD1 on Solaris8
Hello, I did some more tests and I found out that after 50 connections, the next one cannot connect anymore!!! Kurt.…
Ghost Sessions causing login failures
This usually happens with Windows clients which do not properly shupdown the TCP connections. It is seen most often with BSD based UNIX servers (like AIX) where the network timeout detection is set too high (BSD default was over an hour). Reducing the network timeout detection to…
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 …
ODBC Connection error
Sounds like it didn't find a database of the name you provided or the user that tried to connect has no connect priveledges on the database…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
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…
how to setup PAM Kerberose on IDS 10.FC6
Hi Jim, On Wed, 2007-05-23 at 12:39 -0400, Jim Cramer wrote: > Wiesiek, > > SUCCESS! > > In my reply to Nilesh just now, I mentioned that I now > have PAM working thanks to an earlier post of his. > I'm very glad that your configuration works OK. Connected to previous post I'm …
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…
onstat -u and IDS maximum concurrent sessions
"maximum concurrent" gets reset with an onstat -z -----Original Message----- From: SANJIT CHAKRABORTY [mailto:c_sanjit@lycos.com] Sent: 26 October 2006 15:03 To: ids@iiug.org Subject: Re: RE: onstat -u and IDS maximum concurrent s.... [7679] The 'maximum concurrent' in the last…
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 …
RE: So much hate....
> A unix "pro" that can't install Informix...... Scary. > That's obviously an overpaid person..... even if he works for free, he's > overpaid!! > How much simpler does it have to be? > On the other hand, maybe it would be interesting to meet him..... > incompetent and 'unix per…
NETTYPE for db server
If I've got - a db server and a remote app server connecting to it - 12 cpu vps - a few local shm connections for maintenance / monitoring jobs - mostly tcp connections for apps What would be the preferred setting for my NETTYPEs? Bob Roussey robert.roussey@spiritair.com…
Users connected to a DB
Hi all onstat -u or querying sysmaster:syssessions gives me a list of connected users to a server. What if I want the list of users connected to a specific database?…
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 Question - not specific to informix
Darren_Jacobs@carmax.com wrote: > Greetings, > > I'm faced with a project that deals with accessing databases by way of ini > or config files. Basically the apps/scripts are sourcing files to gain > passwords. Some of which are in plaintext. These files can be on windows > or …
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…
connection to db2 database through db2 client on windows slows down intermittently
we restart the database and then connection gets established.…
limit connections
Is there any way to limit connections to an informix instance ? I understand that even if you set nettype for a certain number of connections, once more than that come to the server, Informix will dynamically create a new poll thread. But what if we only want to allow a certain a…
UNIX/Windows network security
I have two different Informix instances running in two separate machines in the same network: One in UNIX and another in Windows: 1st machine: -------------- OS: SCO UNIX hostname: thasos Informix DS 9.21, server name: ol_aegean user: akin Database dbakin $ cat /etc/hosts.equiv…
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?…
Linked tables in SQL
Is anyone using linked tables in SQL to connect to a ids9.4 db ken.shew@state.co.us…
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/…
Connecting to Informix
I am writting small program in C++ and need to connect to Informix database. Program should run under Solaris 8 and compile using gcc 2.95.3. Are there any free libraries to use? Can anybody help me?…
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: 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!…
Oops! IDS on Windows XP Error 900
Please help! I have installed IDS 10 on Windows XP. When dbaccess started, it connect to the internet and hang. Finally, it comes back with Error 900: Attempt to connect to database server failed. Connection Refusd. What is wrong? Why is Informix trying to connect to the int…
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.…
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…
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:…
user can still connect after CONNECT privilege get revoked
Hi, I have revoked the connect privilege from a user. The user is not admin. Still, the user can connect to the database. How to revoke the CONNECT privilege indeed from a user? How to check a user can't connect (e.g. catalog table or user setup) without letting the user try to …
ODBC Connections
--0-1022851391-1118096900=:67143 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, I need monitoring all ODBC connections only. For internal auditoring. Regards, --------------------------------- Do You Yahoo!? La mejor conexi�n a Internet…
Connection Pooling
We are using the odbc driver "INFORMIX 3.31 32 bit" The version is 3.31.000 2.40.TC1 When I look at it the set up for it in ODBC drivers, it says <not pooled> under the connection pooling heading. Yet, when I close a connection in a program, my temp tables do not drop. That is,…
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…
Connection ODBC INFORMIX CLI 2.5 32 BIT
Anyone know the connection string for connecting from a VBA Microsoft Access project to ODBC INFOCMIX CLI 2.5 without set the paramenters in setnet32.exe? Tank you. Simone…
Connections hang
Hi fellows, from time to time, not quite often but believe me its pretty annoying, happens that connections from remote servers or applications - every onsoctcp connections - to our main IDS box just hang without any apparent reason. Anyways local connections (e.g. a simple "dba…
Broken connections
Hi all, =20 I'm seeking an advice to detect broken and cut connections to an INFORMIX instance. =20 I got a SUN BOX running ids 9.40 =20 I found that I can tune up a parameter in Solaris for tcp. it is 'tcp_keepalive_interval' =20 Using this command 'ndd -set /dev/tcp tcp_keepali…
Re: Sudden & massive SHMADD activity; engine went BANG!
Well we have got some relatively new apps connecting via JDBC, and we have run into an issue before whereby the connection pools aren't freed unless they explicitly close the connections.... Sounds plausible. I'd appreciate a copy of the script if you're ok with that, thanks RK.…
Re: Sudden & massive SHMADD activity; engine went BANG!
Well we have got some relatively new apps connecting via JDBC, and we have run into an issue before whereby the connection pools aren't freed unless they explicitly close the connections.... Sounds plausible. I'd appreciate a copy of the script if you're ok with that, thanks RK.…
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…
HPUX PAM Authentication configuration problems
We have a new HPUX server that we will be migrating our production IDS database and software to. In this migrations we will be also migrating from IDs 7.31 to IDS 9.4. In our testing everything went well with the upgrade to IDS 9.4, but we are trying to get PAM authentication w…
Informix 7.23 connection problem
We are using Informix 7.23 Online database on Unixware 2.1.3. It works OK if less then 50 users are connected. When 51-st is connecting, it starts to refuse connections, create closed connections and go slow. I have increased tcp, MAXUP and NBUF parameters, but its not working. C…
Installing IDS 7.x on Windows NT
david.reed@compuwin.co.za wrote: > I would like to install IDS 7.x for workgroup on Windows NT machine What exact IDS version? If your "7.x" is below a certain version it won't necessarily work with your NT Service Pack version. > that do not have any network installed on it. …
Connect error
Hi, I've a pb to connect to ifx. I get error message 952 with ODBC. I tried with dbaccess and I surprised with 2 behaviours : - first, I launch dbaccess, user is registred, it works - I try to pass by menu "connect" and it reject me with all users/passwords giving the same error…
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'?…
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…
Re: To build better security
There are OS (and even Informix) based security mechanisms that you can enable through configuration of INFORMIXSQLHOSTS. In the server security option field (5th field) of SQLHOSTS, you can specify s=1 (/etc/hosts.equiv based) s=2 (~/.rhosts based) s=6 ($INFORMIXDIR/etc/hosts.eq…
RE: To build better security
Guys- You should be able to do it with a firewall. Deny access to the Informix port (1525, 1526, etc.) except to connections from specified addresses. --EEM -----Original Message----- From: Andrew Hamm [mailto:ahamm@mail.com] Sent: Friday, July 09, 2004 9:55 PM To: informix-…
Re: To build better security
--0-1806648619-1089724075=:52348 Content-Type: text/plain; charset=us-ascii Andrew, Please enlighten us with your knowledge on why it is wrong to secure connections by IP if there is a need for it from the business ? Thanks. Andrew Hamm <ahamm@mail.com> wrote: Mike Smith wrot…
To build better security
Mike Smith wrote: > > Does any one know of any tool, software or a method that I can use to > secure my > > Informix user connectios only from certain IP addresses, just like in > MySql database ? iptables if using Linux. This is really a networking issue and shouldn't be addres…
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…
From infomix backup tape to file
I'm in WinNT 4.0 SP6a. How can I mount the tape over the network ? -----Original Message----- From: kagel [mailto:1190260@skytel.com] Sent: Friday, June 25, 2004 12:27 To: Narcis Ciornei Subject: Re: From infomix backup tape to file [3157] You cannot easily do what you are tryi…
Re: ISM-Legato RPC Error
Hi, Rastislav Jan�? wrote: > > Dear all > > I have installed IDS 9.40 64-bit version on AIX 5.2 64-bit machine. All > but ISM works fine. > ISM doesn't, ism_startup -init ends with core dump of nsr binaries > Have anybody seen such thing? Please check /etc/security/limit for…
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.…
Informix Connect
I'm having a problem connecting to my db due to the fact that my Informix SE (v7.23) wants to talk via (SETLITCP). Any new ODBC driver I try wants to talk via (SESOCTCP). Does anyone know if an old version of Informix Connect will talk via TLI? The oldest I can find on IBM's w…
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…
Re: Error -1811
Andrew Hardy wrote: > can somebody explain to me what this means: > > lesu273> finderr -1811 > -1811 Implicit connection not allowed after an explicit connection. > > Once you have used the CONNECT TO statement to establish an explicit > connection to a database server, you can…
Error -1811
Sorry to be a pain, can somebody explain to me what this means: lesu273> finderr -1811 -1811 Implicit connection not allowed after an explicit connection. Once you have used the CONNECT TO statement to establish an explicit connection to a database server, you cannot use one…
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: 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…
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…
DSN-less and oledb connection scrint for Informix using OpenLink drivers
I've recently started to work with performing queries against an Informix 2000 database using the OpenLink drivers and ADO. I've figured out to use a DSN connection string in my VBScript, but I would prefer to use a DSN-less connection. I would also like to try an oledb connecti…
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…
ODBC Connectivity
I'm after some advise. Current situation: User 'fredn' can log into Unix host and run 4GL application User 'fredn' can access database via ODBC in update mode User 'pcuser' has been set up specifically to allow ODBC access in read-only mode I want to stop user 'fredn' accessin…
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.…
Connection problem
Hi all, I have this problem : Error -951 while trying to connect to the Informix 7.31TD2 server (on = win2000) from an windows XP (client APP) via ODBC. The ODBC test connection works ok, but the application throws this error = : user not known on the database server. When I us…
connection problem
Hi everyone, did someone meet the following issue? We use Informix Online 5.00 UC2 on a Unix box (AT&T UNIX SYSTEM V Release 4.0). Currently only 91 users can connect to the database. Afterwards no new user can login - till someone logs out and the user can connect to the server…
Sniffer Packet Decode?
Hello All, My company is running Informix 7.31 on AIX 4.3.3. We are currently looking at different ways to increase our security and performance to try and comply with the upcoming new Sarbanes-Oxley security laws. Our network geeks are using Sniffer Pro to look at network tra…
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…
cannot connect
hello, we are experiencing a sporadic problem where the database will not allow any new connections. does anyone have a script they run that will connect to the database, do a simple select and then exit? this script would only send mail if there was a problem, otherwise we would…
DataBase Connection
hi!!!! I have 2 linux Red hat 7.2 servers with informix 7.31 UD2 version, I want to get the connection between them but it shows "908: Attempt to connect to database server (servgra) failed. ISAM error: record is locked. ". I defined this: ** On the services file:(both servers) …
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…
Connectivity Issue
Can anyone please provide help with the following. I am trying to access db tables in an IDS instance running on WinNT from MS Office 2000 applications. The IDS is ver 9.3 and the ODBC driver is Informix 3.33 from the ver 2.6 CLI SDK Using MS Access or Excel I can create a link…
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…
Which version to use of Informix Connect?
Hi Community, I have some questions about Informix Connect and hope that somebody knows the answers :-) We are using HP-UX 10.20/Informix 7.31.UD5 and the clients (OS: WIN NT/WIN2000) are connecting to the database through I-Connect 7.20. Are there known problems with this vers…
Catastrophic Error
I connect to an Informix database with Visual Basic using ADO, and have a program that must periodically connect to the database, make some process, and then disconnect. The problem is that when I use oledb Informix provider (ifxoledbc), after a number of connection/disconnectio…
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???…
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…
Syntax
Do someone know the syntax to connect to an Informix database via Internet (ASP Program)…
ODBC Security
Consider this scenario: An ODBC connection configured to allow a user direct access to a database, thus bypassing any application security locking users out from specific records of tables. Any user granted access to a table is granted access to the table level, although when r…
ODBC connectivity
Has anyone set up links between an Oracle database on Windows or Unix to an Informix database. I would appreciate any information or documentation which is available. Of particular interest is 1) What ODBC drivers were used 2) What port numbers does Informix 3) Any 3rd party soft…
I-connect limitation
We are using VB with ODBC and I-connect 7.2 connecting to our Informix SE DB on SCO Unix. The problem is that we try to connect several db simultaneously for some queries but i-connect only allow one DBPATH. Thus only one db connection per pc configuration. I tried the SDK2.5 wit…
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: Informix CLI 32 and Access
Hi Simone. How do you you connect Access ( or plan to connect ) to the tables you want to use ? /Falco…
No secrete to a root account holder under Informix
> From: Jonathan Leffler <jleffler@informix.com> > Organization: Informix Software Inc > Newsgroups: comp.databases.informix > Date: Fri, 08 Dec 2000 01:29:38 GMT > Subject: Re: No secrete to a root account holder under Informix > >> In this sense, at least, does Oracle appear mo…
URGENT.I NEED HELP.THANKS
I NEED HELP. HOW TO CONNECT PERL WITH INFORMIX DATABASE?? THANKS ALOT.…
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…
Which Connection ?
I have written a perl program predisponsing a lot of INSERT sql command. Now I would be glad to connect with remote database and execute the remote insert. Anyone know about which kind of connection software I can look for (some peole tell me about SDK, other ODBC) ? …
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…
Can I Determine Client IP Address?
Is there a way to determine the IP Address of a client PC connected to Informix? I see where the Hostname (TTY) is available, but we don't run DNS, so there's no way to resolve it that way. What I'm looking to do is this: 1. Create a security/transaction log that records who …
Error -951 when starting IDS2000 on RedHat
Do not use md5 password encription in your Linux box - Informix doesn't understand it, try to use des instead. Good luck. Sergey. Oszvald Elem�r <oszvalde@westel900.net> ����� � ���������:3A0EDA84.7AE6F087@westel900.net... > > Hi > > I get the following message in the log when…
Attunity Connect
Has anyone here used a product called Attunity Connect with Informix? TIA. Colleen ========== The preceding e-mail message (including any attachments) contains information that may be confidential, be protected by the attorney-client or other applicable privileges, or constitu…
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: ------…
Connect to informix
Hi, First of all, i'm very new with using linux. :-) Now i have a UNIX with informix server 7.3 on it. I use ODBC to connect under windows, so that's no problem, and works fine. Now, i have a linux. And (you can guess) i want to connect to the UNIX. The idea is that i want to ma…
Connection / Disconnection
Can anyone explain the following behaviour ? Configuration : Ifx 9.21 UC 2 , IBM S80 AIX 4.3.3 16 Go 18 proc. NETTYPE onsoctcp, 17, 180, CPU When 1500 users ( that's to say 3000 connections to the databaserver) are working, time are quite ok. But when the first users disconnec…
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 …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
ODBC Connection
Is there any particular svc that Online (7.23) would use as a default? I've looked through /etc/services but really am not sure which one... Thanks in advance, Joe Robinson, SFC System Administrator USPFO for Oregon, Oregon Army National Guard Email: robinsonj@or-arng.ngb.arm…
Does risql connect via odbc?
Administrators, I'm trying to connect to Redbrick 6 via a 3rd party application on Solaris 2.7. This application connects via Odbc. I CAN NOT conect via this application or via the "adhoc" program, but can connect via "risql". I'm trying to determine where the problem lies. …
RE: Informix ODBC Drivers vs Merant ODBC Drivers
Hi About 2 to 3 years ago we spend a lot of time evaluating different ODBC drivers. There are about 30 different manufactures out there. 1. We found Openlink the fastest, best extra security build in {AFAIK, no other driver have all the extra security}, easy to set up, etc. 2. …
DSNless connection
Hi there: How to use DSNless connection in VB6.0 and Informix7.x. I can do that in using MS SQL Server7.0, but not with informix. Thanks! -- ------------------------------------ ������(Kuang-ming Kuo) �]�Ϊk�H�_����|�q���� (Chi-Mei Foundation Hospital) kmkuo@mail.chimei.org.tw …
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…
Regarding connect permissions of the database.
Hi All, Is there any restrictions on number of users for granting permissions (connect) to a databases? What will be effect of revoking connect permissions from public after adding connect permissions to the application users. (Running HP-UX 10.20 and Informix 7.3). Please hel…
ADO
Is it possible to connect to Informix using ADO/OLE DB ?????…
Redbrick Connection
Hi Folks, Does anybody know if there is some kind of driver to connect a Redbrick database with an Oracle database so that I can do selects from both. Either direction would be fine. Thanks, Gregg Sent via Deja.com http://www.deja.com/ Before you buy.…
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…
Connect fail with error 908
Hi, I try to connect to a remote database with dbaccess comand 'connect to '@dataserver';' and gor error '908: Attemp to connect to database server (dataserver) failed'. Can someone tell me what the probem is? The remote database is up and running. Thanks, Thanh Ngo…
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…
RE: ODBC and network security
If you do not have ESQLC, but have the C version of 4GL, do the following to relink. go to .../openlink/lib c4gl -static inf73_sv.o -o inf73_sv cp ../bin/inf73_sv ../bin/inf73_sv.old cp inf73_sv ../bin I also had problems when upgrading to 7.3. I first just used the 7.2 diver …
Consultants - FREE Zero Impact Sql & Service Level Monitor
The Zero Impact Sql Monitor product line is being used by several of the most security conscious firms in the world (eCommerce, Wall Street, banks, manufacturing, telecommunications, utilities, etc. firms) as well as in US Defense agencies. It has had to obtain at these organiza…
RE: ODBC and network security
Try to get Openlink to solve the MS Access problem. SCO SQL Retriever is the same as Openlink {No CLI} but the last version I tested was slow. Cant remember if it had security options. Next I have a working solution but some C coding is involved. INFSPY from the IIUG will do …
ODBC and network security
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_01BFC022.F34EFF88 Content-Type: text/plain; charset="iso-8859-1" Hello all, Pardon me if this has been a recently disc…
Web connection
Hello. I am interested in developing web-based solutions with my Informix IDS7.32UC2. I have a Microsoft IIS server, with ASP-pages, and the 1st solution could be the creation of ASP pages with ODBC-connectivity to Informix. But I suppose this is not a very secure environment, f…
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…
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…
Re: read-only access
Hannes Visagie wrote: > > Yes Mark. This works fine but what if the user needs to access the DB with > ODBC because they use some MSoft product, but still needs to use > applications that runs on the application server {UNIX - Telnet}, full > access. > > The only secure way is t…
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…
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…
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…
ODBC Connection
I am trying to connect an Access2000 database to our Informix side. ODBC is setup and I see Informix (on a Unix box) and all the objects of the database. I can import the tables from Informix and get all the data but am unable to view the data if I choose to link to the table. L…
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…
connecting to informix
I'm using NT4 and need to connect to Informix. I have not had much luck with connecting using Iconnect and DataDirect. What other connectivity software is available to do this, otherwise, what version of IConnect and DataDirect should I be using? thanks Dg…
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…
ISM and ONBAR in a Secured Environment
Hi, We are upgrading from IDS 7.11.UC5 on Solaris 2.4 to IDS 7.31.UC4 on Solaris 7. We run our server in a hardened mode, i.e., we do not run inetd, rpcbind, CDE, etc. and severely restrict access ports to only what is needed for Informix and SSH. We found some time ago that th…
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…
SQL CONNECT
Greetings, I have been asked to provide some estimates for "connect" times to databases. Does anyone have any average times for completion of an execution of the Informix SQL CONNECT statement ? I realise that this will be one of these "It Depends ..." type situations, but I woul…
odbc
Hi all I made it all. (add in c:\\windows\\services) But i have error -908 I check my network and all is right. I can connect to my aix server. I check /usr/informix/etc/sqlhosts file /etc/hosts /etc/services all is ok nut i cant connect to informix 7.2 I wath network using 'tcp…
Connect problems
--------------203C6B2724A3084FED993DB8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have installed Informix Dinamic Server 7.3 in a redhat Linux 6.0. Before I had installed it in redhat Linux 5.2. I followed the same steps that i make in redhat 5.…
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…
Informix SE 7.24.UC5 on RedHat Linux 6.2 and password security
Otis Michaud wrote: > > There would seem to be some issues with password security and this > software/OS combination. > > We can establish a connection using dbaccess or ODBC only if we attempt to > connect with the root login and password. > > 1 - Has anyone experienced the same…
Installing IDS on NT Server with DOMAIN configured
I don't know if my problem concerns NT or Informix. The scenario: my customers send me their NT server for installing my application which runs on IDS 7.2 or 7.3. the NT server belong to o PDC (primary domain controller) but has also an administrator local account. Obviously I in…
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…
Help on the minimum to test replication laptop to desktop
Hi, I would like to set up a test of replicating data from a laptop to a desktop. What is required, caveats etc and most important least cost. I would like to test on a dialup and direct connect. The connection on the dialup connection will be brought up and down on schedule …
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…
CSM
> I'm searching information about the Communication Support Modules (CSM). > I have Informix Dynamic Server 7.3 and HP-UX 10.20. > > I found in the Technical Brief (Part 4: > http://www.informix.com/informix/techbriefs/ids/feat.htm): > "Communications Support Service (CSS) > Comm…
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…
number of connections in NETTYPE
What is the limitation on numbers of connections in parameter NETTYPE in IDS7.31FC2…
Crossed Connections
I have recently upgraded my client/server applications from 16-bit to 32-bit NT. They are powerbuilder applications and an Image Display C DLLs. The pb and c pgms both connect to an Informix server using 7.23 Informix Esql-C (the powerbuilder using native drivers). The problem …
why is connect via C++ so slow?
There is an important detail that I ommitted, connection is via ISAPI.…
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…
No more connections
All, When i do "netstat -a | grep inf1_svc | wc -l" i get +- 50. (inf1_svc being my Informix service name). This is always when the users can't log in anymore - even though i've got NETTYPE tlitcp,2,250,CPU. Only thing i can do is bounce the server. Anyone seen this on Unixware…
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…
ODBC question
Brian Hampson wrote: > > We are thinking of implementing ODBC with our Informix DB, can we limit > ODBC connections to > > a) certain hosts (subnets etc) > b) certain users (subset of users on UNIX box) > c) combinations of a+b Security isn't part of the ODBC spec. However, man…
IFMX/Redhat 6.0
I am having problems connecting to my Informix instance...well kinda! I am able to use dbaccess to successfully connect to the stores7@demo database. These options work: * dbaccess->database->select->{select database} * dbaccess->connection->connect->{select server…
Number of Connections
Is there any good way of determining the number of database connections currently active or zoombies? Russell L. Cook Marconi Integrated Systems, Inc (858) 592-5008 russell.cook@Marconi Integrated Systems, Inc…
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.…
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…
Connection Question....
The current system is informix 5.x with a 4gl front end. All the users IP addresses are in the DB servers host file. They are changing the network to use DHCP what do i need to do on the DB server to make sure i don't get -954 errors(client unknown to host). TIA, Bill…
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…
unable to connect
Hi I have an Informix DBS 7.23 for NT 4 and an Informix DBS 7.30 for Solaris 5.6 On my PC I installed the Command center (Tools 7.23) The database explorer (7.23) shows both DBS and I can work with the databases. The command center shows me bothz DBS - but only the 7.23 (NT) onli…
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…
IDS refuse connection on NT when connected to Internet?
>The strangest thing; > >I just noticed that whenever I connect to Internet, I can't connect to my IDS 7.3.TC7 >on NT (connection refused - Agent_log: Attempt to connect to database server (%s) >failed.) > >As soon as I disconnect from internet, connect works. > Sounds like some…
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…
connection error
could anyone tell me what's this error is? >Cannot connect to this database. >java.sql.SQLException: DBNLS is not set or LC_COLLATE must be '%s'. I use jdbc122jc1 driver. I have no problem connect to other Informix databases on other hosts. Does it have to do with firewall? tha…
I-Connect
Could someone explain, what is I-Connect in Unix box versus sqlhosts connection, if we are talking about C/S system in db-level. Is it same thing ?.…
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…
Remote Connections
Can someone tell me what steps the engine (ODS 7.24 on Solaris 2.x) uses to determine if another user/machine is allowed connection? For some reason, when I connect the hostname is in all caps, and therefore does not get resolved because they are listed in the rhost files as lowe…
RE: Connecting from SCO Unix to an Informix database running on W
Having you tried running a truss on it? That will tell the exact device it's trying to open and in which mode. I agree with Art that everything points to some network configuration problem. Is there an accompanying isam error, anything in /var/adm/messages. Is the OS patched a…
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…
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…
Silly Q. How to add user to database?
Here's your answer Grant [ CONNECT | RESOURCE | DBA ] to [ USERNAME ]…
Multiplex Connection
Does anybody know what it is and how it can improve performance of a client application. Do you know if there is any documentation available about this topic and how to set it up. We have HP UX 10.2 and Informix 7.3. Thanks in advance for any responses.…
Re: Connect to Server only - not database from Delphi 3
How about connecting to 'sysmaster' ?…
Connection Problem
My company has Informix OnLine 7.0.2 (I believe) running on SCO UNIX Openserver 5. The server is a dual PII 400 with 256 meg of RAM. Whenever we get around 50 connections to the database, we are no longer able to start up any new applications that access the database. At first …
C2 security, DEC & Informix -951
Hi all, After implementing the C2 security in our development server ( DEC ), we start getting error -951 > Incorrect password or user jcs is not known on the database server. I used the same account and was able to use dbaccess to access the database. The problem only occur w…
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…
Connect to MicroStation
I`m trying to connect a INFORMIX Database (IDS 7.3) to MicroStation SE Vers. 5.7.0. The IDS, the Database and MicroStation are on the same SGI (IRIX 6.2.). The only message I get is: Unsuccessful CONNECT statement Has anybody ever tried this? Are their any specific settings neces…
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…
Database connection
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 But when I want conect to server over the net its not work. When I want do loopback it doesnt work too.…
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?…
Security Issue
You are kidding right? I can think of hundreds of problems that can be caused, even mistakes that could be causes. In article <77iiim$fu0$1@news.xmission.com>, Abraham Perl - Application Developer <abep@bhphotovideo.com> wrote: > > anybody know of a security problem with a u…
Equivalent of connect by
i have a sample code in Oracle... that use connect by. wonder what's the equivalent in Informix and do i need to change the codes. code as follow: 1 select itinerary_id, dept_station,arrv_station 2 from 3 (select rownum-level itinerary_id, 4 dept_st…
Change the owner of a table
In article <76vfuo$jlt$1@news.ppp.net>, "S. Radtke" <rt@pascal.de> wrote: > Hello, > > Can anybody tell me, how i can change the owner of a table without drop and > create the table ? > > Thanx Sven > > For security reasons, I believe you're forced to drop and rebuild. You co…
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.…
connection problem
Hello~ I want to connect to INFORMIX-Universal Server Version9.13.UC3 on SunOS5.5.1 from ASP Server winNT4.0 with NT Services Pack3.0 and Option Pack4.0 I am using INTERSOLV 3.10 32-BIT INFORMIX 9 ODBC Driver. ILogin Demo works well... When I tried DB open, IE4.0 displayed fo…
Remote Connection
I have installed the Informix connectivity software on my Windows NT box and was testing my connection with the ILoginDemo software to a database on AIX. For the connection to work properly I have to have an entry for my desktop machine in the etc/host.equiv in the AIX machine.…
ASP-Informix
Has anyone ever connected successfully to an informix database through an ASP? If so, what connection string did you use? Any help is appreciated.…
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…
Re: what is Satan ?
For a short description, it is network and system security tool. For more detail description, check out http://www.trouble.org/~zen/satan/satan.html At 11/22/98 09:47 PM -0800, babak bayati wrote: >Hi every body, >What does Satan program do? > > >_______________________________…
Re: Why the applet can't connect to the database server remotely ?
In article <70qdiq$3ds$1@news.xmission.com>, wugangzh@scf-fs.usc.edu wrote: > What the problem may be ? The client machine has installed java Plug-in > 1.1.1 and > set the security options to unstricted and low. I have convert the HTML > file using a > converter downloaded fro…
Re: Why Satan kills informix processes ?
From my email archives for April 1995, which is when Satan was first released... >From: Mark Sigler <msigler@informix.com> >Subject: [WARNING]SATAN can crash Online! (fwd) >Date: Sat, 8 Apr 95 10:29:39 EDT > >For those of you who have not heard about 'SATAN', it is a piece of >p…
Re: Changing Password
In article <72pob1$9p8$1@news.xmission.com>, Steve Romankiw <sromankiw@execrisk.com> wrote: > > We would like to have the ability to change our UNIX password from a > Windows client. > > We are running Windows/95 and WinNT for clients and Solaris 2.5.1 > servers. Also, we are …
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.…
25588: The appl process cannot connect to OnLine server
I am trying to connect to a database but it does not let me connect. It displays the following "25588: The appl process cannot connect to OnLine server red1_dev711shm. Not a typewriter" And also, does someone know about this 'typewriter' stuff ? I thought funny messages came …
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…
a problem with connections
We have a problem with remote systems: We have these products: INFORMIX-SQL Version 4.12.UE1 INFORMIX-4GL Version 4.10.UC2 and RSAM Version 5.02.UC7 and we have noted this problem, for us is quite important to solve it. I'll explain: We have to remote systems, A and B, both …
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…
Re: Connection
Irineu Rocha wrote: > > Hi folks, > > What I need to do in order to perform a select statement from one > Informix server to another informix server (NT to HPUX)? I did this when > NT was just running Informix client (setnet32), but I don't have any > idea how to do between serve…
Connection
Hi folks, What I need to do in order to perform a select statement from one Informix server to another informix server (NT to HPUX)? I did this when NT was just running Informix client (setnet32), but I don't have any idea how to do between servers. Any reply will be appreciate…
Connect Failure
I have three RS/6000 boxes (S/70, R/50, E/30). I can connect to two of the three using ILogin or ROM, but not the third (the R/50). I get a -908 error. The Setnet values are almost identical for all three (all use onsoctcp), and they're using the same ODBC drivers (Informix-CLI 2…
Re: Replication thru a firewall
Robert: Check out http://www.peerdirect.com. Our company has developed a replication system for Informix (and several other databases) that supports secure replication through firewalls. Any questions, please contact me directly. Regards Dave Bell email dbell@cntc.com In ar…
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: Multithreaded process - connect problem
David Ferguson wrote: > > G'day > I am writing a multi-threaded server. I can connect to the database in > the main > thread but not in my database thread. However, once connected, I can > close and > then re-connect successfully in my database thread. You can only have one u…
Multithreaded process - connect problem
G'day I am writing a multi-threaded server. I can connect to the database in the main thread but not in my database thread. However, once connected, I can close and then re-connect successfully in my database thread. System: Solaris 2.5, Informiix 7.22 Any ideas? Thanks.…
Re: Informix 4GL on Linux? When?
Richard Spitz <richard.spitz@ana.med.uni-muenchen.de> wrote: > Nils Myklebust wrote: >> I hope you have filled in the survey at >> http://www.informix.com/idn-secure/Linux/WebPages/survey.html > I tried to access this URL. However, a username and password were > requested (I used…
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: 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…
connectivity problem
Hello I downloaded the evaluation copy of informix Dynamic Server for Windows NT4.0. I installed the software in Primary Domian controller and I am able to create the instance and database. Now I am not able to connect to the database from the client side. The client I am using i…
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…
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…
pb6
Hi, Can I-Net connect PowerBuilder 6 to Informix online 5/7?? What to make it connect? TIA Nien…
Re: ? IECC Does not provide sessions and other info
You have to first connect to the database server. To do that right click on the database server name and select connect As option. Natraj DBA, Bourns Inc…
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: Informix 7.23 via NT and Unix security?
Mike Segel <mikey@segel.NOSPAM-.KING.OF.MYDOMAIN.-NOSPAM.com> offerred: +Narkinsky, Pat wrote: +> +> It sounds as thought what you need is "NIS" (Network Information +> System). This is a network service that allows multiple UNIX machines +> to share configuration files. Unfort…
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…
Re: Informix 7.23 via NT and Unix security?
Narkinsky, Pat wrote: > > It sounds as thought what you need is "NIS" (Network Information > System). This is a network service that allows multiple UNIX machines > to share configuration files. Unfortunately, NIS can become a major > security hole. NIS+, (which is only availa…
RE: Informix 7.23 via NT and Unix security?
It sounds as thought what you need is "NIS" (Network Information System). This is a network service that allows multiple UNIX machines to share configuration files. Unfortunately, NIS can become a major security hole. NIS+, (which is only available on Solaris last time I looke…
Re: Prohibiting ODBC access
Neil Truby wrote: > OnLine v7 on Solaris 2.5. > > Does anyone have any ideas how I can prohibit ODBC access to my database > server from anyone, including users who might otherwise be valid > database users? > > The system I have isn't really Client/Server, in that users telnet …
Connect Privileges
Trying to give connect to a user in dbaccess. Says permission granted, but that user name is not added to the sysusers table. Can anyone help with this ?? John…
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: +…
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…
oppty in emerging technologies start-up
US-CA-Bay Area Software Engineer - Encryption Subsystem Engineer. Well-funded start-up developing highly optimized network application engines for the burgeoning market for wire-speed network embedded applications seeks experienced Software Engineer - Encryption Subsystem engine…
Informix Connectivity
Hi, I am trying to connect a WIN95 workstation that gets its IP address using DHCP and then connect to INFORMIX ON-LINE V5.x using version 5 connectivity software on the PC. We get an error -954 i.e. server does not know who the client is. Any work around or solution will be …
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…
problem with shared memory connections
hi all I'm having constant problems with shm connections in UDS 7.2x The error returned is -25588 - the appl process cannot connect to Online server server-name. It looks like Informix will allow so many shm connections before refusing a connection, but this seems to vary. If I …
Connectivity Question
I have a question here on OnLine7 connectivity. Consider these two machines... MachineA 1 OnLine database called "dbA" MachineB 1 OnLine database called "dbB" MachineA sqlhosts ----------------- dbAshm onipcshm MachineA shm_file dbAtli ontlitcp MachineA …
Re: [Fwd: OWS ERROR]
In this case you have to give the user who is trying to connect to the database, a permision to connect as minimum, how you do that?, connect to the server using user informix and then run the dbaccess or the sql editor, and do a new query: grant connect to user…
Connection to the database
We're going to install the system(using Power Builder) that we're developed outside the LAN where our database server(Online Workgroup Server) are located. Can anybody tell me what we need to do to : 1. The server that contain the database 2. The machine that will run the …
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 multiple databases (one local, one remote in New Era)
Hello, We are trying to connect to 2 databases: + 1 on the local database + 1 on a remote UNIX database Both databases are Informix. Connecting to 2 databases on the remote server causes no problems. Connecting to the local database or the remote database cause no problems ei…
Database Connectivity
Is there any database connectivity between Tcl/Tk 8.0 and Informix? I believe there are drivers for Oracle and Sybase, but what about Informix? Thanks for any info.…
Re: Restricting ODBC access
Someone once mentioned making the role name a secret, i.e. the name of the role itself becomes a sort of password which would be built into the applications. Does this not work? Michael Segel wrote: > > Dave Otto wrote: > > > Easy if you are running 7.1+. Use ROLES. If there i…
Re: Trusted user question
> > > > > > Check your hosts.equiv file? > > > Check to see if you are in a *trusted/secure* mode of the OS. > Simple check, see if the encrypted passwords are in /etc/passwd. > > If not, then you are in a secure mode. > Even using hosts.equiv or .rhosts wont work. HP-UX will ove…
Re: Trusted user question
Mark Collins wrote: > > > Mark > > > > Check your hosts.equiv file? > Check to see if you are in a *trusted/secure* mode of the OS. Simple check, see if the encrypted passwords are in /etc/passwd. If not, then you are in a secure mode. Even using hosts.equiv or .rhosts wont work…
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…
Re: Multi Thread App
David Williams wrote: > In article <68tpjb$q9j@cssun.mathcs.emory.edu>, "Art S. Kagel" > <kagel@ns1.bloomberg.com> writes > >On Tue, 6 Jan 1998, Alexander Jaremenko wrote: > >You use the CONNECT TO ... AS <connection name> statement repeatedly with > >different connection names…
Re: Multi Thread App
On Tue, 6 Jan 1998, Alexander Jaremenko wrote: } Hello Mr Kagel, } Thank You for response. } } > ODS/ESQL-C versions 7.21 and later support threaded applications. } > Versions prior to 7.13 supported only one connection per process and } > 7.13->7.20 supported multiple sessions …
Connecting to websites
Friends, I'm using newera (v 2.12) for our database application development. I'm trying to open netscape navigator browser and go to a particular website. I could open the browser with the statement RUN "c:\\\\progra~1\\\\netscape\\\\navigator\\\\program\\\\netsca…
connection to ERwin
Greetings, I am trying to get a connection to a database from ERwin from a NT 4.0 workstation to our Informix instance which is on a Solaris 2.5 Unix box (Informix ODS 7.23). I have tlitcp configured in the onconfig and the sqlhosts done but I'm not sure what I need on the cl…
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: Gaping security hole? (network db connections)
I have a related question. We are running Online 7.22 on DEC Alpha UNIX. Our GUI is in Delphi. Some of our PCs can connect to the server with no problems others get a 956 error "user or host not trusted". I spoke with Informix support they informed me I would have to make an …
Re: Can't authenticate to Online: password incorrect?
Hi all, I've been having similar problems with my Windows NT server since it refused to boot after upgrading to 4.0.(yah Microsoft easy upgrade path huh?) dbschema gives me this error message when I try to dump a databases schema. Names have been altered to protect the server. …
Re: Can't authenticate to Online: password incorrect?
Check ownership of oninit ... make sure it's root. I encountered same problem when someone (not I!) installed oninit as informix and system was using shadow passwd file ... thus informix couldn't authenticate. Local users were fine becuase host trusts itself. -Lin VFraenkle <…
Re: Gaping security hole? (network db connections)
Nathan Neulinger wrote: > Jack Parker <jparker@informix.com> wrote: > > At 12:24 AM 11/4/97 GMT, you wrote: > > }Actually, .rhosts is still a problem, > > } > > }It jsut narrows the hole from: > > } > > } ANY user on client can log into ANY user on server > > }to > > } A…
Re: Gaping security hole? (network db connections)
Jack Parker <jparker@informix.com> wrote: > At 12:24 AM 11/4/97 GMT, you wrote: > }Actually, .rhosts is still a problem, > } > }It jsut narrows the hole from: > } > } ANY user on client can log into ANY user on server > }to > } ANY user on client can log into this particular user…
Re: Gaping security hole? (network db connections)
Anders Hackin' Karlsson <anders.karlsson@karlsson.pp.se> wrote: > I'm not getting in to this discussion if .rhosts/hosts.equiv is bad > or not. I'll just comment on a factoid. As you state that anyone can > play with the PC hostaddresses, connecting from a DOS/WIN/NT PC to > Info…
Re: Gaping security hole? (network db connections)
> Informix's security is flawed in that /etc/hosts.equiv was really meant > to authtenticate a user on a particular machine. It was meant for a > UNIX to UNIX authentication, rather than a PC to UNIX. (peer to peer, > rather than client server.) This IS!!! for a UNIX to UNIX aut…
Re: Gaping security hole? (network db connections)
On Tue, Nov 04, 1997 at 09:17:24AM -0500, Jack Parker wrote: > At 12:24 AM 11/4/97 GMT, you wrote: > >Actually, .rhosts is still a problem, > > > >It jsut narrows the hole from: > > > > ANY user on client can log into ANY user on server > >to > > ANY user on client can log into t…
Re: Gaping security hole? (network db connections)
At 12:24 AM 11/4/97 GMT, you wrote: }Actually, .rhosts is still a problem, } }It jsut narrows the hole from: } } ANY user on client can log into ANY user on server }to } ANY user on client can log into this particular user on server You can specify user@host to narrow it down to…
Re: Gaping security hole? (network db connections)
Anders Hackin' Karlsson <anders.karlsson@karlsson.pp.se> wrote: > I'm not getting in to this discussion if .rhosts/hosts.equiv is bad > or not. I'll just comment on a factoid. As you state that anyone can > play with the PC hostaddresses, connecting from a DOS/WIN/NT PC to > Info…
Re: Gaping security hole? (network db connections)
Actually, .rhosts is still a problem, It jsut narrows the hole from: ANY user on client can log into ANY user on server to ANY user on client can log into this particular user on server Plus, based on some further testing I have done, it appears that it can be done without e…
Re: Gaping security hole? (network db connections)
I'm not getting in to this discussion if .rhosts/hosts.equiv is bad or not. I'll just comment on a factoid. As you state that anyone can play with the PC hostaddresses, connecting from a DOS/WIN/NT PC to Informix is different than connecting from a UNIX box. Last time I check the…
Re: Gaping security hole? (network db connections)
> > and look at what a connection looks like, and then send that same data to > > our central server. > > > > The problem here isn't the usual security problems with BSD .rhosts / > > hosts.equiv mechanism. We've accepted those. And if it were only that, > > this wouldn't be a pr…
Re: Gaping security hole? (network db connections)
That is quite a price. With an entry in hosts.equiv, the remote user can login as ANY user. I much prefer .rhosts, more of a pain to administer, but less of a gaping security hole. cheers j. At 07:58 PM 10/31/97 +0000, you wrote: }Nathan Neulinger wrote: }> }> Is it just me m…
Re: Gaping security hole? (network db connections)
At 08:58 PM 11/1/97 +0000, you wrote: >> >.rhosts exist in each user's home directory. Anyone can write anything >and the UNIX system will consider it valid. (Milage will vary on >different UNIX systems which also have private lists of trusted sites.) .rhosts is ineffective unle…
Re: Gaping security hole? (network db connections)
Michael Segel <"MailerDaemon"@[127.0.0.1]> wrote: > > The sqlexec process on the client is running as 'joeuser'. Anything that > > a process running as 'joeuser' can do, so can a process running as > > 'freduser'. > > > > The only way .rhosts/hosts.equiv works is that remsh/rlogi…
Re: Gaping security hole? (network db connections)
Michael Segel <"MailerDaemon"@[127.0.0.1]> wrote: > Nathan Neulinger wrote: > > > > Is it just me misreading things, or is there no security whatsoever in the > > network sqlexec connections to an informix DB server? > > > I'll give you the short answer. > Yes and No. > Don't use…
Gaping security hole? (network db connections)
Is it just me misreading things, or is there no security whatsoever in the network sqlexec connections to an informix DB server? I was under the initial impression that the informix server used the .rhosts/hosts.equiv mechanism to validate users - where the remote connection say…
ODBC connectivity
Hi guys, Can u tell me how to connect an informix database with visualBasic's Crystal Reports? Roshni roshni@comsysmgt.com…
Re: NEWERA -- Database Security
Mike Ripley wrote: > > I think this question may have been asked before. > > On Windows 3.11 you can force users to enter a password to log on to the > network. If they enter incorrectly they still get the desktop but can't > connect to network drives. > > However this does not s…
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…
Unable to connect
Here a question from a newbie: I have a copy of Informix OnLine (as shipped by Baan) running on an NT-server. The version is 7.20.TE1. Now I would like to manage this server from my Workstation (Windows95). I have installed the client-apps that come with the other copy of Inform…
Informix Connect
Quick question. . . Will Informix Connect 7.2x for Windows 95 work with Informix 5.0 or do we need to upgrade to Informix 7.0? If this information is available from an FAQ, please point me in that direction. Unfortunately, the Informix web site leaves much to be desired as a su…
Re: Protocol
Hi Elisa, Elisa Hoffman wrote: > Has anyone connected to an Informix UNIX database through a firewall? > > How does INFORMIX (on UNIX) using I-NET, via ISQL, validate and confirm > who the remote client is? > - Is DNS used? If so, is the lookup based on IP address, where > ser…
ontape error
We have a Baan/Informix/NT setup and are having problems with running the command line utilities that require admin status within Informix. The version is 7.20TE1 and we've tried logging into the box as baan, baandb, informix, and administrator. When we try to do an 'ontape -s -L…
Re: I-Net protocol stupid design: a performance issue for networking.
In <01bc9550$ad416e40$a34efac2@philippv> "Philippe Verdy" <verdy_p@msn.com> writes: >I have been requested by one of the customers of the company for which I >work about networking performance that I did not detect before during >development until I put our software in the produ…
Re: Connections
>From: Johannes Plassmann <plassmann.pad@sni.de> >Date: Thu, 10 Jul 1997 09:05:43 +0200 >X-Informix-List-Id: <news.40292> > >I have a question concerning connections (CONNECT to, DISCONNECT from >commands). During program execution we set a connection to a database >server throug…
Connections
Hi there, I have a question concerning connections (CONNECT to, DISCONNECT from commands). During program execution we set a connection to a database server through (e.g. CONNECT to '@soc20_1'). In other parts of the program (running in a shared library, used by several instances…
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…
Network connection.,,
Hello all, 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 doubled-checked the sqlhosts files, onconfig, hosts.equiv, hosts files, and restarted the database engine, only to ge…
Re: SECURITY - NewEra/ODBC
On 18 Jun 97 at 15:17, David Lapsley wrote: > Are we correct in saying that NewEra uses OBDC to access Informix > databases (via INET) ? NewEra can connect via Informix-Net _or_ ODBC. > If so how do we prevent users using other ODBC compliant products > such as MSQuery ( which…
Re: SECURITY - NewEra/ODBC
On 18 Jun 97 at 15:17, David Lapsley wrote: > Are we correct in saying that NewEra uses OBDC to access Informix > databases (via INET) ? NewEra can connect via Informix-Net _or_ ODBC. > If so how do we prevent users using other ODBC compliant products > such as MSQuery ( which…
SECURITY - NewEra/ODBC
We are considering the use of NewEra (V3 ?) to develop a client/server application accessing an Online 7.2 database. Are we correct in saying that NewEra uses OBDC to access Informix databases (via INET) ? If so how do we prevent users using other ODBC compliant products such a…
Connection problem
I am trying to connect to my Informix box with Space Manager (I have Informix OnLine Workgroup Server on a NT4.0 SP2 box). I get an error message saying I can't connect to <server>. Now I can connect with the Database Manager. I have no clue to where to look to try and correct…
Re: What DB to use for lots of IMAGE files?
In article <5lja9a$g5u$1@news2.xs4all.nl>, Kees Pijnenburg <kpijnenb@xs4all.nl> writes > >As an example assume a table containing usernames and picture >names to indicate whether or not a user has access (I know, a >lousy setup for maintenance). Now it would be nice if each user …
Re: What DB to use for lots of IMAGE files?
kpijnenb@xs4all.nl (Kees Pijnenburg) wrote: >tpcarmen@NO_EMAIL_SPAM.SEE_SIGNATURE_FOR_ADDRESS.org (Terry >Carmen) wrote: > >>In any event, although it's possible to store large files in a >>database, I've had much better performance by storing the image with >>the native underly…
Re: What DB to use for lots of IMAGE files?
tpcarmen@NO_EMAIL_SPAM.SEE_SIGNATURE_FOR_ADDRESS.org (Terry Carmen) wrote: >In any event, although it's possible to store large files in a >database, I've had much better performance by storing the image with >the native underlying filesystem, and only storing the image path and…
Re: /etc/hosts.equiv
Roger J. Allen wrote: > > Mike Segel <mikey@segel.NOSPAM-.KING.OF.MYDOMAIN.-NOSPAM.com> wrote: > > Both the use of .rhosts and hosts.equiv are > > security holes. > > > DO NOT USE .rhosts! > > Check out your man page for rlogind. There MAY be some security > enhancements to .rho…
Connecting to OnLine Workgroup Server 7.12 for Windows NT
Please Help!!! I am trying to connect to OnLine Workgroup Server 7.12 for Windows NT from the work station . I can ping my machine and I can see ILOGIN is working but I can not get connected to the Server using ODBC Connect CLI Driver. Please Help!!! igor13@ix.netcom.com…
Re: Security of Illustra
hansr@businesstales.nl (Hans F. Ruinemans) writes: >Were can we find information about security of the Illustra Database. We >like to protect it, but we want to be able to keep working on our SGI Indy >at the same time. The manual doesn't solve that problem. What particular pr…
Re: Loooking for opinions on: "INFORMIX-Universal Web Connect"
Jan C. Zawadzki wrote: > WWW and "secure" don't go together. If you *have* to run secure go with > Netscape Enterprise and restrict access to 128 bit capable browsers that > present certificates *you* issued. You'll be ok for a while... > 128 bit ciphers are indeed secure, bu…
Informix connectivity
I have an Online 7.2 database. I have purchased CLI for the INET piece on the server. I will run on HP, Sun Solaris, Aix, and SCO platforms. I have an application written in ANSI C++ that runs on Windows95 and NT. I do not want to implement ODBC because we will be deploying the …
ODBC connect
Hi, I'm looking for help. I try to install ODBC 3.0 (Intersolv) on NT 3.51 for Informix Database 7.12. As I try to configure the driver I get error code 126. I found in the documentation that I need isqlt07c.dll. Where can I find it ? thanks for any help. -- -------------------…
Mirroring Informix database across a network
Hi, I was wondering if anybody could suggest a strategy for mirroring a copy of an Informix database on two seperate machines connected over a network. One machine would store the actual database, the other a copy. (The platforms I am considering are IBM RS6000s running Infor…
Connect Informix databases with Paradox forms
Hi, Does anyone know how to connect an Informix database with Paradox Forms ? Eric…
trusted connection
How to set up trusted connection for Informix Online for NT server? Basically, I want to do is using SQL*editor on my Win95 machine to access Informix server on NT server. TIA…
<<TOP SECRET PEOPLE NEEDED>>
VERY LARGE prestigious Northern Virginia based company looking for many people with technical background that have the following: * ACTIVE Top Secret clearance or higher * MUST have a Degree (VERY IMPORTANT) * Technical Experience (need Jr level to Sr level) Positions Looking t…
JDBC Connectivity
Connect Software, Inc. is pleased to announce that release 2.5 of FastForward is now available for download at our website: http://www.connectsw.com/ The new release brings major performance improvements across the entire product line, as well as compatibility with the new Java…
JDBC Connectivity
Connect Software, Inc. is pleased to announce that release 2.5 of FastForward is now available for download at our website: http://www.connectsw.com/ The new release brings major performance improvements across the entire product line, as well as compatibility with the new Java…
ODBC for Informix?
What are other ODBC choices to connect to Informix (without I-Net) besides OpenLink? I have had some problems connecting with OpenLink.…
Multiple Open Connections to Informix 7 and Intersolv's Informix 7 ODBC Driver
It appears that if I have two or more open connections and close one ( SQLDisconnect() ), all connections terminate. Has anyone experienced this? If so, know of a way around it?…
Re: Shared memory connections
Neil Truby wrote: > > My site uses OnLine 7.13 on Solaris 2.4 > > I've noticed that one of our instances has only network connections > defined, no shared memory ones, so not even local utilities are using > shared memory connections. Does anyone have a feel for the effect this …
Connectivity
Can I connect from a 7.20 OnLine and reference a 5.0 SE table? HELP???…
ASSISTANT SA
A major San Francisco based securities firm seeks an assistant hardware technician for their nationwide trading operation. Candidate should have 2+ years experience servicing macs, printers and pcs. Network experience a big plus. Knowledge of Unix, TCP/IP, modems and route…
Re: Is my brain dead or what....
> Background: > A large client has 1000+ PCs in its corporate headquarters running > windows 3.11 (Among other things). It is mainly a NOVEL network, read > IPX. Their goal is to have several small VB (Visual Basic) type apps > run against some Informix databases. > > Problem…
Re: Caldera Network Desktop (was:Re: SMP & threads for SQL queries)
In article <324333B5.57E979B3@en.com>, Sean Casey <casey@en.com> writes: >> >You mentioned that a lot of big shops are running the stable versions of >> >linux. Does any body have any information like what is it used for - >> >desktops or servers. What kinds of databases are the…
Re: Caldera Network Desktop (was:Re: SMP & threads for SQL queries)
> >You mentioned that a lot of big shops are running the stable versions of > >linux. Does any body have any information like what is it used for - > >desktops or servers. What kinds of databases are they running on these? Ernst & Young, the second largest international account…
Erwin connection:
Does anybody out there know who I can get Erwin ODBC (Win95) connection to informix database…
I-NET 16 bit using PPP connection
I am trying to connect to Informix 5.04 running on Sun Solaris 2.4 using ppp connection from a windows 95 winsock.dll. I am getting a -932 error/getservbyname(WSANODATA). If I am using a network connection from the same box the ILOGIN will work. The serv…
Re: ODBC & Client Access
This discussion has been up not to long ago. I now however have decided what we are going to do. Irwin Goldstein <irwin@objectsoft.com> wrote: :Ray Riley <weho-isd@ci.west-hollywood.ca.us> writes: :> Does anybody have an answer for ODBC client security? :> :> Once you open up O…
Socket Connections
Hello I am trying to develop a Java applet that allows employees to do their timecards online with an existing Informix database. My first thought was to try and use JDBC, but I am now told that Informix already listens for a socket connection on port 1525. How can I access the…
Informix Remote Commands
Is there an Informix "remote" command which connects to an Informix database not on the Web Server?…
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…
DCE Security & the WWW - April 16-18, 1996 - San Jose, CA - LMHQM01
DCE Security and the World-Wide Web (the following information is also available on the World-Wide Web at: http://www.DCIexpo.com/) Only four weeks left to register for the only OSF-sponsored DCE User & Developer conference in the industry. The OSF DCE User & Developer Conferen…
Short Courses on Multi-level and Network Security from UC Berkeley
U.C. Berkeley Continuing Education in Engineering Announces 2 Short Courses on Computer and Network Security MULTI-LEVEL SECURITY: Information Security Issues for Effective Systems Development (February 28-March 1, 1996) Course Description This intensive course presents a compr…
Test Delete This Message
Test, to check is connection okay…
DCE Security and the World Wide Web
DCE Security and the World Wide Web The OSF DCE User & Developer Conference being held April 16- 18, 1996, in San Jose, CA., is pleased to announce the addition of a new track to the conference program: DCE Security and the World Wide Web. This track is intended for those who a…
Connection to Informix
I'm working with PowerBuilder 4.0 and Informix 7.4 (?). I have a dialog box when the user have to type his login and his password and press an accept button. Then, the login and the password in the sqlca are setted with the values of the fields in the dialog, and …
Re: B1/C2 security level?
One thing to bear in mind whenever reading Informix's claim to be: "...the only RDBMS product with a successful NCSC B1/C2 evaluation...", is that it is a slimy marketing claim which Informix maintained even after the beginning of April 1994 when Oracle's products completed 4 eva…
Informix Secure Database C2, B1 and B2 Evaluation Status
There have been some recent questions regarding Informix' Secure DB Products Evaluation status in both the US (NCSC) and Europe (ITSEC). Some of the "fog" needs to be cleared, both regarding the status of the ongoing evaluation efforts themselves, and also regarding the meaning o…
Re: B1/C2 security level?
Tim <cchung@cs.tamu.edu> wrote: >Does INFORMIX-OnLine/Secure remain the >"only" RDBMS product with a successful >NCSC B1/C2 evaluation? (As I know, in >1994 Summer, it did.) >Has INFORMIX-Online/Secure got its B2 >certification yet? >Thank you. Informix Online Secure v4 was t…
CONNECT syntax
Can anyone tell me the syntax for the CONNECT statement for ISQL 6.0? Specifically, how is the USER clause specified? Please email if possible. Thanks -- Allen Nguyen…
Network Security '95
As promised, the final program for Network Security'95 is attached. As you'll see, the top gurus in every key area of UNIX network security have all been invited and have agreed to provide practical and interesting talks and papers. The entire program lasts a week (November 13 …
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?…
Re: [WARNING]SATAN can crash Online!
bkh@lib1.byu.edu (Brian K. Holman) wrote: > >Richard Spitz (spitz@GANS2X.ana.med.uni-muenchen.de) wrote: >: What is SATAN? > >SATAN (Security Administrator Tool for Analyzing Networks) remotely probes >systems via the network and stores its findings in a database. It tests for >…
Re: [WARNING]SATAN can crash Online!
Richard Spitz (spitz@GANS2X.ana.med.uni-muenchen.de) wrote: : What is SATAN? SATAN (Security Administrator Tool for Analyzing Networks) remotely probes systems via the network and stores its findings in a database. It tests for known security holes such as sendmail problems, et…
Internet applications/database position available (Cambridge, MA)
Do you have a unique combination of Internet, World Wide Web, SQL, and database skills? Our company, Open Market, Inc. is a rapidly growing start-up software company located in Cambridge, MA. We're building technologies for commerce on the Internet, including secure payment tra…
Informix connectivity
-> How can one tell if informix i-net & i-star are installed properly? They work! Seriously, though, there isn't much you can do beyond a -ps- to see if the processes are running. Maybe johnl@informix.com has some ideas. Regards Billy ---- Digitec Online - 20 Nodes....* Joha…
Database connectivity
I get the following error when trying to attach to an on-line database on a remote server. 908: Attempt to connect to database server (segfs001) failed. Bad file number I've set up the /etc/hosts, /etc/services $INFORMIXDIR/etc/sqlhosts files. -- ___ / /( \\ \\ …
Informix connectivity
How can one tell if informix i-net & i-star are installed properly? -- ___ / /( \\ \\ | \\ | \\ \\ _)/ / (__ __) : ^ : """…
Re: Network Security
Jack Parker wrote : > > First Cathy and now Lionel - maybe there's something wrong with our solution? > We discovered excatly what Cathy ran into. So perusing the I-Net/I-Star > manual (that weighty tome of knowledge!) we noticed that you could use .rhost > instead. Now each of…
Re: network security
Cathy J. Senft wrote : > We have a system set up with two RS/6000s, one as our database > server and one as a "software server". Our users rexec a command from > their PCs to run our application on the latter machine. We run I-Net > and I-Star for the communications between th…
Re: network security
> > We have a system set up with two RS/6000s, one as our database > server and one as a "software server". Our users rexec a command from > their PCs to run our application on the latter machine. We run I-Net > and I-Star for the communications between the machines. The users…
Re: Network Security
First Cathy and now Lionel - maybe there's something wrong with our solution? We discovered excatly what Cathy ran into. So perusing the I-Net/I-Star manual (that weighty tome of knowledge!) we noticed that you could use .rhost instead. Now each of our users has a .rhost file w…
network security
We have a system set up with two RS/6000s, one as our database server and one as a "software server". Our users rexec a command from their PCs to run our application on the latter machine. We run I-Net and I-Star for the communications between the machines. The users have to h…
Re: Informix and trusted host access
In <1qhppnINNb0q@emory.mathcs.emory.edu> obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler) writes: >>Date: Wed, 14 Apr 93 09:53:03 CST >>From: uunet!mulga.awadi.com.AU!lwaugh (Lionel Waugh) >>Subject: Re: Informix and trusted host access >>X-Informix-List-Id: <…
Re: Informix and trusted host access
John Carter wrote Re: Informix-NET and trusted host access > > This involves using DES and a fair amount of C code on both client and > server to perform the handshaking between systems and ensure that > someone isn't trying to sneak in their own packet and break in. > It is nece…
Re: Informix and trusted host access
>Date: Wed, 14 Apr 93 09:53:03 CST >From: uunet!mulga.awadi.com.AU!lwaugh (Lionel Waugh) >Subject: Re: Informix and trusted host access >X-Informix-List-Id: <list.2147> >John Carter wrote Re: Informix-NET and trusted host access >> This involves using DES and a fair amount of C …
Re: Informix-NET and trusted host access
Jonathan Leffler replied :- > The problem is: if you don't have trusted status, how are you going to > provide the user ID and password for network access? What about if a query > in the application suddenly refers to a remote database, possibly via a > synonym and you weren't …
Re: Informix-NET and trusted host access
>Date: Wed, 24 Mar 93 07:51:18 CST >From: uunet!mulga.awadi.com.AU!lwaugh (Lionel Waugh) >Subject: Informix-NET and trusted host access >X-Informix-List-Id: <list.2041> >I am surprised that nobody seemed interested to comment on my previous posting. > Perhaps nobody is using In…
Informix-NET and trusted host access
I am surprised that nobody seemed interested to comment on my previous posting. Perhaps nobody is using Informix-NET ? Perhaps nobody is worried about losing network security ? Perhaps 'I am not doing it right' ? I would like some indication (even if you disagree with me), as…
I-Net Security
%UNIPLEX %TO informix-list@rmy.emory.edu %FROM rridley %SYSTEM DHLNET %SUBJECT I-Net Security %VERIFY y %DATE 24/03/93 14:00 %REFERENCE 16723 Re: >I am surprised that nobody seemed interested to comment on my >previous postin…
RFI: Secure database systems
Dear Netters, I am writing a report on security in data base systems, both theoretical aspects and real systems. I am looking for references to information about this topic. In particular, I need information about secure data base products from vendors like Oracle, Sybase, Ingr…
Informix database security
Path: emory!swrinde!cs.utexas.edu!uunet!iWarp.intel.com|ogicse!psgrain!m2xenix!quagga!ucthpx!oct1!aim1!chan From: chan@aim1.UUCP (Neville Chamberlain) Newsgroups: comp.databases,comp.databases.informix Keywords: database security informix Message-ID: <53@aim1.UUCP> Date: 15 Oct 9…