cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos
261

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

Accepted Solutions (0)

Answers (2)

Answers (2)

reiner_hille-doering
Active Contributor
0 Kudos

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
0 Kudos

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