Data provider

[Tony Johansson]

Hello!

Here is some text that I find strange.
"The .NET Framework Data Provider for SQL Server is designed to connect to
SQL Server 7
and later versions. When connecting to SQL Server 6 or earlier, highlight
the <other> data source and select the .NET Framework Data Provider for OLE
DB. Then, in the add Connection dialog box, select the Microsoft OLE DB
Provider for SQL Server."

As I have understood is the following when I have the Change Data Source
dialog up.
If I have a Sql Server database use Data Source Microsoft SQL Server and
then use the Data Provider that is automatically suggested by the .NET
Framework which is .NET Framework data Provider for SQL Server

//Tony

 

[Arne Vajhøj]

Here is some text that I find strange.
"The .NET Framework Data Provider for SQL Server is designed to connect to
SQL Server 7
and later versions. When connecting to SQL Server 6 or earlier, highlight
the<other> data source and select the .NET Framework Data Provider for OLE
DB. Then, in the add Connection dialog box, select the Microsoft OLE DB
Provider for SQL Server."

As I have understood is the following when I have the Change Data Source
dialog up.
If I have a Sql Server database use Data Source Microsoft SQL Server and
then use the Data Provider that is automatically suggested by the .NET
Framework which is .NET Framework data Provider for SQL Server

Yes.

If you have a SQLServer 7 or newer (and 7 was released in 1998!)
then you pick SQLServer.

Only if you have SQLServer 6.5 (1996!) or older do you
pick OLE DB.

The short version: pick SQLServer.

Arne

 

[Tony Johansson]

Yes.

If you have a SQLServer 7 or newer (and 7 was released in 1998!)
then you pick SQLServer.

Only if you have SQLServer 6.5 (1996!) or older do you
pick OLE DB.

The short version: pick SQLServer.

Arne

I'm not used to the term SQL Server 6 and 7 I have only heard about SQL
Server 2000, SQL Server 2005 and SQL Server 2008.
I don't understand this terminology SQL Server 6 and SQL Server 7.

//Tony

 

[Arne Vajhøj]

I'm not used to the term SQL Server 6 and 7 I have only heard about SQL
Server 2000, SQL Server 2005 and SQL Server 2008.
I don't understand this terminology SQL Server 6 and SQL Server 7.

That is just the version numbering!

6.5 -> 7.0 -> 2000 -> 2005 -> 2008 -> 2008R2

Arne