Data provider

  • Thread starter Thread starter Tony Johansson
  • Start date Start date
T

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
 
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
Click to expand...

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
 
Arne Vajhøj said:
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
Click to expand...

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
 
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.
Click to expand...

That is just the version numbering!

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

Arne
 
Back
Top