Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to talk to informaix 5
Message
 
To
13/02/1997 15:47:58
General information
Forum:
Visual FoxPro
Category:
User groups
Miscellaneous
Thread ID:
00020434
Message ID:
00020439
Views:
45
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform