Are you able to connect at all to the data source? It looks like you have a syntaxes error of some kind. Check the format of the SQL you are submitting.

Perluser.


----- Original Message -----
From: Trace R Jones <trace.[Email Address Removed] Wednesday, February 25, 2004 9: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]
>

DB2 & UDB email list listserv db2-l LazyDBA home page