Call Stored Procedure AS400 From SQL Server

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
PortekoiHi
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:
_sna_distributed_query_support_using_the
_ole_db_provider_for_db2_oledb.asp" target="_blank">http://msdn.microsoft.com/library/d...r_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 iSerie
s
> 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
>|||I can't help you with your problem, But I sure love to know how you configur
ed your linked server.
I am using Client Access Express and can't find any documentation for what t
he 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
---