Connecting to DB2 / AS 400 from SQL Server

Bonjour,
I wish to access a DB2 database wich is on a AS 400.
1) wich OLE db driver must we use ?
2) where can we download it ?
3) is it free ?
3) how to configure it ?
We have try different syntaxes without success :
Example :
sp_addlinkedserver @.server = 'AccesDB2_AS400_TRY1'
, @.srvproduct = 'Microsoft OLE DB Provider for DB2'
, @.provider = 'DB2OLEDB'
, @.location = 'ASILON'
, @.provstr = 'Initial Catalog=EPSILON;Data
Source=DB2;HostCCSID=1252;Network Address=192.168.1.15;Network
Port=50000;Package Collection=admin;Default Schema=admin;'
, @.catalog = 'EPSILON'
Our AS 400 server name is ASILON
Our AS 400 server adress IP is 192.168.1.15
The database name is EPSILON
What are we missing ?
thanks
Frdric BROUARD, MVP SQL Server, expert bases de donnes et langage SQL
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Audit, conseil, expertise, formation, modlisation, tuning, optimisation
********************* http://www.datasapiens.com ***********************Hi Frdric,
There should be an OLEDB DB2 provider distributed with MDAC. From here you
can download the latest version:
http://msdn.microsoft.com/data/mdac...ds/default.aspx
Here are a couple of good links providing information about formatting
connection strings:
http://www.carlprothman.net/Default.aspx?tabid=81
http://www.connectionstrings.com/
JT
"SQLpro [MVP]" <brouardf@.club-internet.fr> wrote in message
news:%238ucAMsRGHA.2300@.TK2MSFTNGP11.phx.gbl...
> Bonjour,
> I wish to access a DB2 database wich is on a AS 400.
> 1) wich OLE db driver must we use ?
> 2) where can we download it ?
> 3) is it free ?
> 3) how to configure it ?
> We have try different syntaxes without success :
> Example :
> sp_addlinkedserver @.server = 'AccesDB2_AS400_TRY1'
> , @.srvproduct = 'Microsoft OLE DB Provider for DB2'
> , @.provider = 'DB2OLEDB'
> , @.location = 'ASILON'
> , @.provstr = 'Initial Catalog=EPSILON;Data
> Source=DB2;HostCCSID=1252;Network Address=192.168.1.15;Network
> Port=50000;Package Collection=admin;Default Schema=admin;'
> , @.catalog = 'EPSILON'
>
> Our AS 400 server name is ASILON
> Our AS 400 server adress IP is 192.168.1.15
> The database name is EPSILON
> What are we missing ?
>
> thanks
> --
> Frdric BROUARD, MVP SQL Server, expert bases de donnes et langage SQL
> Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
> Audit, conseil, expertise, formation, modlisation, tuning, optimisation
> ********************* http://www.datasapiens.com ***********************|||this posting made my day!!!
thanks!!!
--
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes
"JT" wrote:

> Hi Frédéric,
> There should be an OLEDB DB2 provider distributed with MDAC. From here you
> can download the latest version:
> http://msdn.microsoft.com/data/mdac...ds/default.aspx
> Here are a couple of good links providing information about formatting
> connection strings:
> http://www.carlprothman.net/Default.aspx?tabid=81
> http://www.connectionstrings.com/
> JT
> "SQLpro [MVP]" <brouardf@.club-internet.fr> wrote in message
> news:%238ucAMsRGHA.2300@.TK2MSFTNGP11.phx.gbl...
>
>