Using obdc with an IBM iSeries

  • Thread starter Thread starter Brenda Lichius
  • Start date Start date
B

Brenda Lichius

When trying to import a table from our IBM iSeries to Access 2007 using an
obdc driver I am getting the following error. OBDC --call failed.
[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0440 - Routine
SQLSTATISTICS in SYSIBM not found with specified parameters (#-440).

I was able to do this two weeks ago and now it doesn't work at all. My old
linked files work but I can't import or link anything new. I'm wondering if
there was an Access update or patch that changed this procedure.

This is a vital part of my job. I need to be able to do this. Any ideas?
 
What was the resolution to this problem?



Brenda Lichius wrote:

Using obdc with an IBM iSeries
02-Nov-09

When trying to import a table from our IBM iSeries to Access 2007 using a
obdc driver I am getting the following error. OBDC --call failed
[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0440 - Routin
SQLSTATISTICS in SYSIBM not found with specified parameters (#-440)

I was able to do this two weeks ago and now it does not work at all. My ol
linked files work but I cannot import or link anything new. I am wondering i
there was an Access update or patch that changed this procedure

This is a vital part of my job. I need to be able to do this. Any ideas
-
Brenda

Previous Posts In This Thread:

Using obdc with an IBM iSeries
When trying to import a table from our IBM iSeries to Access 2007 using a
obdc driver I am getting the following error. OBDC --call failed
[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0440 - Routin
SQLSTATISTICS in SYSIBM not found with specified parameters (#-440)

I was able to do this two weeks ago and now it does not work at all. My ol
linked files work but I cannot import or link anything new. I am wondering i
there was an Access update or patch that changed this procedure

This is a vital part of my job. I need to be able to do this. Any ideas
-
Brenda


Submitted via EggHeadCafe - Software Developer Portal of Choice
MDI .NET Forms Include Docked Controls And Smaller MDIClient
http://www.eggheadcafe.com/tutorial...84-57049e53b8c5/mdi-net-forms-include-do.aspx
 
Brenda, I have several pc's in my shop that are experiencing this same error. Can you explain how the problem was fixed?
Thanks



Brenda Lichius wrote:

Using obdc with an IBM iSeries
02-Nov-09

When trying to import a table from our IBM iSeries to Access 2007 using a
obdc driver I am getting the following error. OBDC --call failed
[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0440 - Routin
SQLSTATISTICS in SYSIBM not found with specified parameters (#-440)

I was able to do this two weeks ago and now it does not work at all. My ol
linked files work but I cannot import or link anything new. I am wondering i
there was an Access update or patch that changed this procedure

This is a vital part of my job. I need to be able to do this. Any ideas
-
Brenda

Previous Posts In This Thread:

Using obdc with an IBM iSeries
When trying to import a table from our IBM iSeries to Access 2007 using a
obdc driver I am getting the following error. OBDC --call failed
[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0440 - Routin
SQLSTATISTICS in SYSIBM not found with specified parameters (#-440)

I was able to do this two weeks ago and now it does not work at all. My ol
linked files work but I cannot import or link anything new. I am wondering i
there was an Access update or patch that changed this procedure

This is a vital part of my job. I need to be able to do this. Any ideas
-
Brenda

ODBC ERROR
What was the resolution to this problem?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Access Modifiers
http://www.eggheadcafe.com/tutorial...-4e21-bd2a-cbcf05d20d5f/access-modifiers.aspx
 
Reinstallation of Access for Windows solved the problem for me.

Kind regards,


Brenda Lichius said:
When trying to import a table from our IBM iSeries to Access 2007 using an
obdc driver I am getting the following error. OBDC --call failed.
[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0440 - Routine
SQLSTATISTICS in SYSIBM not found with specified parameters (#-440).

I was able to do this two weeks ago and now it doesn't work at all. My old
linked files work but I can't import or link anything new. I'm wondering if
there was an Access update or patch that changed this procedure.

This is a vital part of my job. I need to be able to do this. Any ideas?
--
Brenda
Click to expand...
 
Back
Top