Problem solve Get help with specific problems with your technologies, process and projects.

iSeries file to the database error

I have a Windows XP PC -- iSeries Access and Access 2002. I have set up an ODBC 32-bit connection and I'm trying to link an iSeries file to the Access database. I receive the error "Received error (-7778) there is no message for this error." This is my first try at an ODBC connection. Is there a simple documented way to do this?
You did nothing wrong. This is a known issue in Access, and Microsoft acknowledged it as a bug. You can bypass this problem by using Machine ODBC Data Sources instead of File Data Sources -- this is done in the ODBC source configuration.


Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.

Check out this Search400.com Featured Topic: Networking and the iSeries

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

This was last published in January 2004

Dig Deeper on FTP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.



  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...