Fetch data from SQL Server 6.5

Question

In SSIS 2005, connection manager i get 'Test connection failed because of an error in initializing provider' when I try to connect to a SQL Server 6.5 database using Microsoft OLE DB provider with a SQL server account. I'm trying to do this on a Windows 7 64 bit machine.

What do I need to do?

Answer 1

What is the OLEDB Provider that you are using SQL Native Client (SQLNCLI) (or) Microsoft OLE DB Provider for SQL Server (SQLOLEDB)?

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

I believe SQL Native Client does not support SQL Server 6.5 - it supports only as far back as SQL Server 7.0. I'm honestly not sure about what is supported by SQLOLEDB.

---

This post is provided 'as is' and confers no express or implied warranties or rights.

Answer 3

Yes Dan is correct. SQL Native Client does not support connecting to SQL Server 6.5, but with SQLOLEDB you can (you will not be able to access new functionality and features introduced with SQL Server 2005). Also based on the error message you reported it is not very clear what the exact issue is, so if you want you can tell us the provider you are using then we might be able to help better

---

This posting is provided "AS IS" with no warranties, and confers no rights

Answer 4

Thank you for your answers.(The alert system seems to be out of order :( )

'Native OLE DB\Microsoft OLE DB Provider for SQL Server' is the provider chosen.
I was trying to open a colleagues work when I first experienced it, and when I created I new package(and new connection) I experience same thing.

Any ideas?