I can connect with everything (client config,etc) fine. However, when I use
an MS product, I get the error below (I am choosing the IBM DB2 ODBC
Driver).

TRJ



DANIEL
CALLAHAN To: "Trace R Jones" <trace.[Email Address Removed]
<[Email Address Removed] cc: [Email Address Removed]
ibm.com> Subject: Re: DB2 Connect with Access Issue

02/25/2004
08:38 AM










Do you have all the neccessary stored procedures and stored procedure WLM
address space
running on MVS?

version 8 requires 13 new stored procedures and a new WLM managed address
space. You may want to
check with your MVS db2 people.

the other possibility is that you are using the MS provider rather than a
db2 provider, but I think its the former.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email Address Removed] [Email Address Removed] "Trace R Jones"
<trace.[Email Address Removed] erPointEnergy.com To
> [Email Address Removed] cc
02/25/2004 09:07
AM Subject
DB2 Connect with Access Issue










Hello everyone,

I am trying to use MS ACCESS using ODBC (via DB2 Connect 8.1.4.A) to
connect to our DB2 OS390 databases. Here is the error I'm receiving:

[IBM] [CLI Driver] [DB2] SQL0440N No Authorized Routine Named "SQLTABLES"
of type "*" having compatible arguments was found. SQLSTATE=42884.

Anyone seen this or have any ideas?


TRJ


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed]DB2 & UDB email list listserv db2-l LazyDBA home page