AS/400 to SQL Server 2008
Hi, Is there a way to pull an AS/400 File into SQL server 2008? From within SQL 2008 we do not see an ODBC connection that will work for the 400(??) I am not familiar with SQL server and we need to get some data to it. Can anyone shed some light on what I may be missing in regards to the link to the SQL server?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 28, 2009 6:28 PM
UPDATED:
January 30, 2009 6:50 PM
Answer Wiki:
Rmason
It's been a few years and it wasn't 2008.
But, as I remember it ....
Need client access installed on the server system -- it contains ODBC driver
If you go to create a new data source you should see Client Access ODBC driver
I don't remember any big issues creating a DTE or the like.
Oops - you're already on to this.
You should be able to see any library the id you sign in with has authority to.
If you're using a data source to link server
... the Data source default library is QGPL .. add your libraries in the server tab -- library list
DTE will work. You should also be able to create views on Server of your tables.
Using client access transfer - it shows the libraries in your (the signed in id's) library list when you browse. Want another library type any library your are authroized to mylib2/ followed by / and browse to see files. You can also just type the library/file
Phil
To see all answers submitted to the Answer Wiki: View Answer History.
Update: I was thinking of putting Client Access on the SQL server and use the Transfer Data From AS/400 but I cannot configure it to see the user library where the data resides(?) I can see the lib qgpl but his data is going to a different lib.
Thanks Phil, I appreciate it!!
FWIW, iSeries Access for Windows also includes an OLE DB provider, which is considered by Microsoft to be more advanced technology than ODBC. You might want to use that instead.
Michael