It turns I have to apply APAR PQ76858 on the OS/390 side to create some new
procedures. Thanks to all for the help.

TRJ




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

02/25/2004
03:29 PM






The error is ODBC specific, so it is reasonable that you can do normal CLI
stuff. Your program is asking ODBC for a list of tables, and it in turn
asks
DB2 via the sqltables() function. DB2 responds with your error message. I
think Daniel is right, and you should review your ODBC support host side
installation.


----- Original Message -----
From: "Trace R Jones" <trace.[Email Address Removed] "DANIEL CALLAHAN" <[Email Address Removed] <[Email Address Removed] Wednesday, February 25, 2004 11:09 AM
Subject: Re: DB2 Connect with Access Issue


>
> 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] 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] For additional commands, e-mail: db2udbdba-[Email Address Removed] ---------------------------------------------------------------------
> 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] For additional commands, e-mail: db2udbdba-[Email Address Removed] ---------------------------------------------------------------------
> 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] For additional commands, e-mail: db2udbdba-[Email Address Removed]DB2 & UDB email list listserv db2-l LazyDBA home page