perfectchaoss
Programmer
Hi,
I am trying to link my SQL server 2000(enterprise manager) to an AS/400 server. I was going to use Client access for a ODBC provider, but after I installed client access I no longer have the option to select any Provider Name(combo box displays blank and I cannot type text). Before I installed client access i could select from a group of providers that were already on the server. Now I cannot choose anything for the "Other Data Source" Does anyone know how I can add/restore providers for linked servers. I am trying to add the linked server in enterprise manager, by right clicking the linked server node under security. Also... I can pull data from the AS-400 using excel with this same ODBC.
Thanks in advance,
JF
I am trying to link my SQL server 2000(enterprise manager) to an AS/400 server. I was going to use Client access for a ODBC provider, but after I installed client access I no longer have the option to select any Provider Name(combo box displays blank and I cannot type text). Before I installed client access i could select from a group of providers that were already on the server. Now I cannot choose anything for the "Other Data Source" Does anyone know how I can add/restore providers for linked servers. I am trying to add the linked server in enterprise manager, by right clicking the linked server node under security. Also... I can pull data from the AS-400 using excel with this same ODBC.
Thanks in advance,
JF