Yeah Me

OK it worked. Not sure exactly what but here are two things that are important.

1) The Product Name. When You look into "MS SQL Server Mng Studio Express" under "Server Objects" -> "Linked Servers" -> Providers, you will see the provider Ifxoledbc.

First be sure you use a capital 'i'.

2) When you view the properties for this provider I enabled the following

"Dynamic parameter"

"Allow inprocess"

and

"Supports 'Like' operator"

3) I did a single quote in the "Provider String" in the Linked Server Properties.

ie:

username='informix';password='mypassword'

4) In Security in Linked Server Properties, I used:

"Be made using this security context" and entered the same username and password as in step 3.

So I clicked OK and did not receive any error messages.

WaHoo.

Hope this helps. I'm going for a beer now. I earned it.

Steph