SAP .NET Connector with SQL Server 2000 or SQL Server 2005

[Former Member]

Dear all,

does anyone have experiences in working with this connector in combination with SQL Server 2000 or 2005. The current Version (2.0.1) we installed is only working with VS Version 7 and the SQL Server 2005 requires VS Version 8. In the DTS Tool of SQL Server 2000 I wasn't able to access to this connector.

Thanks & Regards

Susanne Lieke-Thölke

[reiner_hille-doering]

ou can allways install NCo in a VS2003 to create proxies.

You can either compile or use the compiled proxies from VS 2005 Beta.

[Former Member]

Hallo,

please correct me if I'm wrong.

To use SAP .NET Connector with SQL Server 2000 in DTS you have 2 possibilities

1. Use COM objects in ActiveX Tasks ->

or

2. Call you .Net programm from an DTS "Execute Process" Task

As far as I know, there is no direct integration of VS7 in MS Sql Server 2000 and therefore no intergration of NCo.

Ad SQL 2005: As you wrote, SQL 2005 requires VS8 and NCo is only running on VS7.

Regards

Gerhard Rausch

Message was edited by: Gerhard Rausch