01-01-1995, 02:00 AM
I am trying to access the data on our AS400 using MS SQL 7.0. We are currently working on a project to mothball our AS400 and use SQL and VB on NT Servers. (Don't yell at me.....I had no choice in this matter!!!) :( I have used the Transformation function of MSSQL 7.0 to update tables on the SQL Server. I would prefer being able to define views/tables that directly reference my AS400 data (similar to MSAccess Linked Table). Defining the AS400 as a MS SQL 7.0 "Linked Server" seems to be the way to go but I have no clue as to filling in the following fields: Should I use "Microsoft OLE DB Provider for ODBC Driver" or "IBM AS400 OLE DB Provider"? and what about these fields: Product Name, Data source, Provider string, location, and catalog. Thank you for any help you can give me.