>Hi there !
>At least, since a month I have got original VS6! For cash.
>But, some problems still there. I have a server running under SCO UNIX 5 where is Informix database. Until now I have been connected with this database via ODBC driver for Informix (Informix-CLI 32 bit ver. 2.12.00.00) and everything has been working fine. But, as I have got VS6 I would like to "catch" this database via ADO. I know IP address of this database server, local network, TCP/IP, I have system and database adminstrator's passwords. Is this possible and how?
>Yes, I know to make programs in Informix 4GL but reports from VFP based on data from server looks much better than reports produced directly on UNIX server (wide reports, fonts, ...you know what foxy can!)
>Thanks in advance.
You can use the same connection string or DSN from ADO:
oCn.Open("DSN=myDSN")
which will use the same informix driver by way of the OLEDB provider for ODBC.
Although for VFP reports you will have to conver to a cursor or DBF.
Read the ADO jumpstart for VFP developers article from MSDN:
http://msdn.microsoft.com/library/techart/adojump.htm