MS SQL Server - Call Stored Procedure AS400 From SQL Server

Author

Call Stored Procedure AS400 From SQL Server

Portekoi

2006-02-03, 9:23 am

Hi,

I have SQL Server 7 with a link server.

When i try to execute a SP from SQL Server, i have this error :

[ OLE/DB provider returned message: [ IBM][Pilote ODBC iSeries
Access][DB2 UDB]SQL0107 - "pack14rexe" is too long. 10 characters
maximum are accepted. ]

I try this : exec recette.recette.pack14rexe.idcb050

I think that it's the '.' but i've try to change with '/' but i have an
another error....

Can you help me?

Thank's :)

Portekoi

John Bell

2006-02-04, 11:23 am

Hi

I don't know specifically about your error, but there seems to be similar
issue with MS Query and the ODBC driver
http://groups.google.com/groups?q=S...ng=d&hl=en&lr=&

you may want to try the oledb driver:
http://msdn.microsoft.com/library/d... _db2_oledb.asp

or possibly use OPENQUERY (if you do return a rowset from the stored
procedure or add a dummy one to the query).

See also http://support.microsoft.com/kb/218590/

John

"Portekoi" <portekoi@passion-cinquieme.com> wrote in message
news:1138975377.316513.28700@g49g2000cwa.googlegroups.com...
> Hi,
>
> I have SQL Server 7 with a link server.
>
> When i try to execute a SP from SQL Server, i have this error :
>
> [ OLE/DB provider returned message: [ IBM][Pilote ODBC iSeries
> Access][DB2 UDB]SQL0107 - "pack14rexe" is too long. 10 characters
> maximum are accepted. ]
>
> I try this : exec recette.recette.pack14rexe.idcb050
>
> I think that it's the '.' but i've try to change with '/' but i have an
> another error....
>
> Can you help me?
>
> Thank's :)
>
>
> Portekoi
>

~@%.com

2006-02-17, 7:23 am

I can't help you with your problem, But I sure love to know how you configured your linked server.

I am using Client Access Express and can't find any documentation for what the Product Name, Provider String
and Data Source Should be.

Thanks,

Johnny
--
----------------------------------------------
Posted with NewsLeecher v3.0 Final
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

Sponsored Links