AS/400 to SQL Server 2008

335 pts.
Tags:
AS/400
AS/400 to SQL Server 2008
ODBC
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Rmason
    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.
    335 pointsBadges:
    report
  • Rmason
    Thanks Phil, I appreciate it!!
    335 pointsBadges:
    report
  • Littlepd
    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
    1,130 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following