Using obdc with an IBM iSeries

[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?

 

[Donald Thompson]

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

 

[Donald Thompson]

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

 

[JeanPierre]

Reinstallation of Access for Windows solved the problem for me.

Kind regards,

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