VFP -> ODBC -> Informix
Posted in 1995
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Migration, Import/Export & Data Conversion
The dear colleagues! I should like to bind two '''' - Visual Foxpro 3.0 (Client ) ( Windows 95 - Informix OnLine 5.0 ( Server ) ( SCO Unix ) In a epoch of 16-bit products at me well worked the union Foxpro 2.6 under a Windows 3.11. - > Informix 5.0 It(she) works and under Windows 95. And here VFP requires, that all components on the party of the client were 32-bit. In particular, 32-bit drivers ODBC, 32-bit Informix Net. Informix does not absolutly hurry up to release I-Net for Windows 95. Yes and with drivers not o'key. Resently them distributors have offered to us to look the newest product from Informix: I-Net for NT 3.0 ( though it already even not enultimate version NT, seems, yes and all one it under Win95 is not installed ). And here suddenly on WWW-server of the firm OpenLink the driver ODBC 32-bit ( for 30 days) is offered to unload to self. That I and have made. Architecture is interest ( multi-tier ). A driver is universal - for Win95 and Win NT 3.5 More(yet) at the client it is installed Request Agent ( oplwsock.dll ). On server - Request Brocker ( oplrqb ) for SCO Unix and Database Agent ( generic_inf5 ) for Informix 5.0 for SCO UNIX ( is and for 6.0). Thus it is bypassed a network layer of the manufacturer ''''. All has delivered and begun to access into Informix. With the first version ( 1.00.0000 from 26.08.95 - 155136 byte ) driver ( oplodb32. Dll ), which and now on - my lies on the WWW-server, Visual Fox did not in general desire to work, informed: the application has executed illegal operation. I go in comp.databases.informix and me from OpenLink have sent the version ( 1.10.0905 from 23.10.95 - 135168 byte ). Now the connections are established anyfrom. But to work from VFP all the same is impossible. 1. Though SELECT is usually executed - and through SQLEXEC and through remote view, the retriving of record sets is usually accompanied the message on a error: Connectivity error: Unable to retrieve specific error information. Driver is probably out of resources. 2. To add a record in the remote table through remote view to me has not in general managed. A driver talk: Connectivity error ( OPL ): Memory allocation failure. 3. At attempt to read from the table, in which the data have 866 code page, gives the message RPC: Can't decode result. [ OPL ] Communication Link failure. The last message is given even by testy program of firm OpenLink self. 4. And other similar. I do not speak that it is impossible through INSERT... VALUES to insert value from a char line in blob field ( TEXT type)of a table Informix, though FoxPro 2.6 permitted it. Whole good Gennadij Uljanov