Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to talk to informaix 5
Message
 
À
13/02/1997 15:47:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Groupes d'usagers
Divers
Thread ID:
00020434
Message ID:
00020439
Vues:
41
Yes, you can do it.

MS has no ODBC drivers to connect to Informix.

You can either get drivers from Informix direct (they will give you
Intersolv ODBC driver), Intersolv DataDirect ODBC driver, or OpenLink
Software.

I got mine from Informix direct. The advantage of that is that you
get a whole pile of documentation with which to format your SQL
statements that you may have to pass directly through with SQL pass-
through.

I am using VFP3.0b under Win3.11 (Win32s) to talk with Informix
version 7.12. So far, it looks great. The access speed is better
than I thought. The database I'm looking at has 283 tables. The
Informix database runs on an HP UNIX server.

The only "trick" to it after you read and follow the setup
procedures is to know your server name and the servicename
that Informix uses to execute. For example, the documentation
always uses the servicename "sqlexec". Well, that may be the
default servicename and good enough for most people, but not
here. They renamed it something like "online-prod". If you
don't get that right, you're out of luck.

It should require that you have TCP/IP on the client or some
other similar transport protocol to get to UNIX. That should
not be a problem with today's Windows NT. It used to be a
problem.

Oh, BTW, don't forget to specify a 32-bit Informix ODBC driver.
If you don't, you may very well get the 16-bit one that probably
won't work with WinNT, even though they say it should.

That's all I got for now.
==Carl

Carl J. Warner
VFUG Officer

The early bird gets the worm, but the second mouse gets the cheese.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform