bergertime
asked on
Sql Server and iSeries linked server
I tried this a few years back and was very frustrated, but I'm going to try again. I have a server 2003 box (clean, all updates) with client access 6.0 installed. Our AS400 runs 7.1. My question is can I do this with sql server 2012 express or should I stick with 2008 developer edition. I'm just doing this for testing to see if I can get it to work. Also, with a linked server, is it read only or will I be able to update the tables on the 400? Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, I'll award points today, but I do need one more thing made clear. I've got it linked, can I see the tables from Visual Studio? Can I use the query designer in Mgmt Studio? All I've been able to do is open the linked the linked server, I see the tables, then run a Script table as. I'm just not sure what a linked table offers me. I was hoping to be able to write my programs against the SQL server since I can't always install client access on all the machines that need to query data from our 400. Thanks again for all the insight.
The tables are linked to the database (or the server, if that visualization is easier for you).
Visual Studio creates a connection to the database (instance, etc.) an interacts with the objects that are accessible in that database (schema). If the objects are properly linked to the database that you connect to, you should be able to access them from Visual Studio.
Kent
Visual Studio creates a connection to the database (instance, etc.) an interacts with the objects that are accessible in that database (schema). If the objects are properly linked to the database that you connect to, you should be able to access them from Visual Studio.
Kent
ASKER
Thanks. I'm going to post a follow up question. Thanks
Different clients, different releases, different options, different servers... all can affect exactly which buttons or menu options to click or which connection string parameters to use or...?
For the AS/400 line, this usually comes up when the "tables" are really older style DDS physical or logical files rather than actual SQL objects in a SQL schema. Without knowing details, guesses are tricky.
Tom