Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 and Informix on UNIX via ADO
Message
From
01/06/2001 10:45:43
 
 
To
01/06/2001 02:42:26
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00513604
Message ID:
00513791
Views:
16
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform