RE: ODBC-Server Middleware

Hi Fernando,

we have such a thing in the field for several years. Have a look to the
homepage http://www.datadirect.com/index.ssp of Datadirect (no ad! Only for
information). Problem is that our version is fairly outdated and the newer
version Datadirect Sequelink 6.0 is not certified for IDS 11.5 yet.

We have the need to use ODBC. It's rather dangerous to allow users to
connect to the databases with IBM Informix ODBC because they could change
data in bad faith or by accident. Yes, we could do something with access
rights on database and table level. For now we have to contribute to the
current situation.

That's the reason we use a two component ODBC: The datasources are
configured at a Sequelink server (there are many options, the most important
is to configure a datasource "readonly", but there is much more possible),
which typically resides on the same host as the IDS. The drivers on the
clients (Windows PC's) connects to their counterpart on serverside. They can
see only those datasources which were configured on the server. The
advantage is that the datasources are to be managed centrally and cannot be
manipulated by users.

As I heard from Datadirect sales representive we seem to be a very seldom
animal with the combination of Sequelink and Informix though the conception
is convincing.

Regards,
Reinhard.

-----Original Message-----
From: informix-list-bounces@xxxxxxxx
[mailto:informix-list-bounces@xxxxxxxx]On Behalf Of Fernando Nunes
Sent: Tuesday, March 10, 2009 12:46 AM
To: informix-list@xxxxxxxx
Subject: Re: ODBC-Server Middleware


Habichtsberg, Reinhard wrote:
Hi all

We are looking for an ODBC driver which meets the following
specifications:

Must-have:
- Resides on a server/host
- May be configured only on the server
- Dirty read is configurable per Data Source
- Read only is configurable per Data Source
- Certified to IDS 11.5 FCx

I never saw anything like this... Maybe I'm missing a whole
lot of things...
The ODBC driver usually is used by the application. What
you're talking about
looks more like some kind of gateway...

Never saw a driver where you could specify read only... It
accepts function
calls which are used to send SQL to the database... It's up
to your permissions
on the database...


Nice to have:
- Multiple ports for differential configurations could be
used (or something
similar)

Again... In a ODBC driver you don't specify "ports". The
driver is loaded into
the application, and then it connects to the database...

- Simple Auditing is possible
- Write access Data Sources can be linked to a password
- Server Software should run on Solaris
- IBM Informix ODBC could connect to the ODBC Server
instead directly to the
Database Server

Again... this looks like a gateway...

Do you have a reference to such a driver?
Regards.

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list

.

Relevant Pages

  • RE: Error from FoxPro connection in Visual Basic 6
    ... Try installing the VFP ODBC driver on the server. ... Microsoft FoxPro Technical Support ...
    (microsoft.public.fox.vfp.dbc)
  • Informix csdk 3.00.fc3 fixpack
    ... On windows 2008 x64 serveri've installed csdk ... 3.00.fc3 to connect Informix 10.00.UC1 working on SUSE Linux. ... Trying to add a new dsn in ODBC Data Sources but it does not show the ... IBM Informix driver. ...
    (comp.databases.informix)
  • Re: Problem connecting to Informix from Sql Server
    ... What version of the Informix CSDK or Connect are you using? ... that you are using an old one based on the version of your ODBC driver. ... My first guess is that the Informix client that you are using is not ... the latest and thus does not work properly on Windows 2003 Server. ...
    (comp.databases.informix)
  • Re: Errors in stored procedure dont raise
    ... query in your ODBC application? ... execute is not enough to get an error. ... Informix CSDK Team, IBM India Software Lab, Bangalore, ... informix server. ...
    (comp.databases.informix)
  • Re: Micro$oft SQL Server 2005 (64 bit version) to IDS 9.40 Linked server
    ... you're getting hit by the 64bit CSDK install bug. ... 64bit CSDK does come with the 64 bit driver. ... We have not gotten linked servers to Informix to work with 64-bit MSSQL. ... Micro$oft SQL Server 2005 to IDS 9.40 Linked ...
    (comp.databases.informix)