Home > IT Answers > AS/400 > AS/400 to SQL Server 2008
Rmason
335 pts.
 AS/400 to SQL Server 2008
AS/400, SQL Server 2008, ODBC, 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?
ASKED: Jan 28, 2009  6:28 PM GMT
UPDATED: January 30, 2009  6:50:14 PM GMT
RELATED QUESTIONS
Philpl1jb
36,400 pts.
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
Last Wiki Answer Submitted:  Jan 28, 2009  9:50 PM (GMT)  by  Philpl1jb   36,400 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

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.

Rmason
 335 pts.
 

Thanks Phil, I appreciate it!!

Rmason
 335 pts.
 

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

Littlepd
 1,130 pts.