hello, i need to connect to a Informix SE 6.0 database, i have tried
with the informix client sdk but it fails in the connection, i know
that is possible to connect because i can to connect with paradigm 4gl
to it, but i need an odbc driver or something like that to connect
because paradigm 4gl doesnt let me to program in vb, so i need an odbc
driver or an oledb driver,the service name in my sco unix that hears
for the data is sqld, i have "listened" to the socket where the driver
sends its data(the 1525)and these are the results:
the ilogin from informix sdk:
sqATwBPQAAsqlexec pepe 9.201 RDS#N000000 -p -fIEEEI
DBPATH=//usr/informix DBDATE=dmy4/ CLIENT_LOCALE=en_US.CP1252
:AG0AAAA9c2UAAAAAAAAAAAA9c29jdGNwAAAAAAABAAABLwAAA AAAAAAAc3FsZXhlYwAAAAAAAAVzcWxpAAAGAAAAAwANdXNyL2l uZm9ybWl4AABrAAAAAAAAA0wAAAAAAAVBTEVYAAAFQUxFWAAAG kY6XFBST0dSQU1BU1xJTkZPUk1JWFNESzIAAHQACAAABNIAAAA AAH8(0)

the paradigm software:
sqlexec pepe 4.10 RDS#N000000 -p -fIEEEI DBPATH=/usr/1998 DBDATE=dmy4/

I think that the problem is that the informix sdk is too new to my
database, i would like to know some system to access the informix se
6.0 or if possible some place to download a previous version of the
informix sdk compatible with my informix database
Thanks in advance
Al

Al wrote:

> hello, i need to connect to a Informix SE 6.0 database

SE 6.00 is very obsolete - it would have been released about 1994, and
should have been upgraded to 7.2x a long time ago. Having said that,
it is less subject to Y2K problems than, say, Informix OnLine Dynamic
Server 6.00 would be.

> i have tried
> with the informix client sdk but it fails in the connection,

It should work. You would have an sqlhosts entry such as:

se seipcpip mymachine sqlexec

You'd set INFORMIXSERVER=se. If you wanted network connections, you'd
have to run sqlexecd from $INFORMIXDIR/lib, use sesoctcp or setlitcp,
and set the service name in the sqlhosts file (it might also say
sqlexec, but it would mean the entry in /etc/services, whereas the one
above refers to an executable in $INFORMIXDIR/lib).

You might need to think about the relay module too - that was a
feature for older (4.x, 5.x) clients to connect to 6.x and above servers.

> i know
> that is possible to connect because i can to connect with paradigm 4gl
> to it, but i need an odbc driver or something like that to connect
> because paradigm 4gl doesnt let me to program in vb, so i need an odbc
> driver or an oledb driver,the service name in my sco unix that hears
> for the data is sqld

So you have a service name (port) in /etc/services such as:

sqld 1525/tcp

And you would have an sqlhosts entry such as:

se setlitcp mymachine sqld

You should, therefore, be running sqlexecd too. And that you're not
running it is the most likely reason why your CSDK is not working.

> i have "listened" to the socket where the driver
> sends its data(the 1525)and these are the results:
> the ilogin from informix sdk:
> sqATwBPQAAsqlexec pepe 9.201 RDS#N000000 -p -fIEEEI
> DBPATH=//usr/informix DBDATE=dmy4/ CLIENT_LOCALE=en_US.CP1252
> :AG0AAAA9c2UAAAAAAAAAAAA9c29jdGNwAAAAAAABAAABLwAAA AAAAAAAc3FsZXhlYwAAAAAAAAVzcWxpAAAGAAAAAwANdXNyL2l uZm9ybWl4AABrAAAAAAAAA0wAAAAAAAVBTEVYAAAFQUxFWAAAG kY6XFBST0dSQU1BU1xJTkZPUk1JWFNESzIAAHQACAAABNIAAAA AAH8(0)
>
> the paradigm software:
> sqlexec pepe 4.10 RDS#N000000 -p -fIEEEI DBPATH=/usr/1998 DBDATE=dmy4/
>
> I think that the problem is that the informix sdk is too new to my
> database, i would like to know some system to access the informix se
> 6.0 or if possible some place to download a previous version of the
> informix sdk compatible with my informix database

It would be a lot easier to upgrade your server to SE 7.25 than to
find an antique ESQL/C v6.00.

--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

"Jonathan Leffler" <jleffler@earthlink.net> wrote

> It would be a lot easier to upgrade your server to SE 7.25 than to
> find an antique ESQL/C v6.00.

Is there any difference between SE 5.x, 6.x and 7.x in terms
of features or functionality.

rkusenet wrote:
> "Jonathan Leffler" <jleffler@earthlink.net> wrote
>
>
>>It would be a lot easier to upgrade your server to SE 7.25 than to
>>find an antique ESQL/C v6.00.
>
>
> Is there any difference between SE 5.x, 6.x and 7.x in terms
> of features or functionality.

7.2x (for all x) has GLS support.

7.25 has support for big files (>2GB data or index).

Otherwise, no. And I'd expect a 6.0 or later (4.x or later) SE
database to migrate to SE 7.25 with the minimum of issues. About the
biggest problem would be if the platform you used an aeon ago had
CREATLOCK locking and the new version uses fcntl() locking instead.
There's an environment variable you set to tell it to convert the lock
modes. That's a minority problem (originally an issue on SunOS -
pre-Solaris - circa 1990).



--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/