Also, examine the General properties page. Open up your linked server's Security properties page and re-enter any connection password (even though asterisks - suggesting that the password is filled and correct - may appear in the corresponding entry). In doing so, the existing linked server is dropped, and a new one is created. Press F5 to run the script and thereby apply your changes.

In the script text that appears, type replacement info for those settings that were grayed-out and uneditable. So, if your connection fails because you mistyped something, it is unclear how to fix it.īeneath 'Test Connection,' look for 'Script Linked Server as.'Ĭlick the latter, and, then, each of the following: 'DROP And CREATE To' Once you create the linked server, if you go back into its General properties page, you will see that you cannot edit what you typed for Linked Server, Product Name (Why isn't this called 'Provider Name,' since Ifxoledbc is listed under Linked Servers/Providers in the Object Explorer tree?), Data Source, etc. The Data Source fill-in could be something as simple as rather than what I tried, namely, or (the latter specifies a port/service number). Snapshots of the dialog boxes help immensely.

It was hard for me to find such a clear, straightforward answer. The answer of SGeis, above, is on the money. I would have used the Comment feature, but I do not have enough 'Reputation Points' to do so.

Informix odbc driver download