ODBC Connection to iSeries

40 pts.
Tags:
Crystal Reports
Data Transformation Services
Database connectivity
iSeries Access
iSeries connectivity
iSeries interoperability
ODBC
SQL Server DTS
Hi, My company has just upgraded to V6RM0 of iSries and I have had problems connecting to the new server through ODBC using Crystal Reports or SQL server DTS. The packages I already had set up are still functioning and I can get a connection OK, but whern I try to create a new package I get an a message "Unspecified Error" and the design view of the packe comes up blank where I would normally be abel to select a table to download data from. Has anyone else had this problem or know of a solution ? Thanks

Answer Wiki

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

Have you applied the lastest PTF package? There are a lots of APARs opened for ODBC connection problems on V6R1 system version.

Discuss This Question: 2  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
  • MBell
    Thanks for your prompt reply. I'm new to all this so I don't know the answer to that. I did apply a service pack to the original - Is this what the PTF is? Sorry for my ignorance on this but I've not been dealing with the IBM side for very long and I'm still trying to get my head round it all.
    40 pointsBadges:
    report
  • Teandy
    When some one talks about “Service Packs”, they are generally referring to iSeries Access for windows (Client Access). A PTF (Program Temporary Fix) refers to i5/OS. Go to http://www-933.ibm.com/support/fixcentral/ to order the latest Cume for your system.
    5,860 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