Connect to Informix SE 6.0

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:AG0AAAA9c2UAAAAAAAAAAAA9c29jdGNwAAAAAAABAAABLwAAAAAAAAAAc3FsZXhlYwAAAAAAAAVzcWxpAAAGAAAAAwANdXNyL2luZm9ybWl4AABrAAAAAAAAA0wAAAAAAAVBTEVYAAAFQUxFWAAAGkY6XFBST0dSQU1BU1xJTkZPUk1JWFNESzIAAHQACAAABNIAAAAAAH8(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> :AG0AAAA9c2UAAAAAAAAAAAA9c29jdGNwAAAAAAABAAABLwAAAAAAAAAAc3FsZXhlYwAAAAAAAAVzcWxpAAAGAAAAAwANdXNyL2luZm9ybWl4AABrAAAAAAAAA0wAAAAAAAVBTEVYAAAFQUxFWAAAGkY6XFBST0dSQU1BU1xJTkZPUk1JWFNESzIAAHQACAAABNIAAAAAAH8(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/