![]() 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. Informix odbc driver download how to#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. Start up the SQL Server Management Studio, and find Linked Servers in the Object Explorer. ![]() OLE DB is not available for Informix SE databases, so you have to use ODBC. 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). Firstly, download and install the latest Informix drivers for Windows: Windows 32-bit (4.10.TC5DE) or 64-bit (4.10.FC5DE) matching your SQL Server product. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |