Re: DBExpress in DeXter

> Do I have to wait for a future version of MDAC

SQLNCLI will run on top of MDAC2.6 and above, I recomend 2.8 but its not
required

> or the current version 2.81 (2.81.1117.0) is fine to change the
> "SQLOLEDB.1" to "SQLNCLI".

SQLNCLI is not part of MDAC its part of SQL Server, its called SQL Server
Native Client. Currently its part of the SQL Server install but there will
be a redist available at RTM that you can run.

>
> We have diffent clients using diffent versions of SQL Server.
> I guess I have to create a user setting to identify if the user is
> intended to connect to a SQL Server 2005, so that I can use the SQLNCLI.
> Otherwise, I guess I'll have to continue using my old connection string
> with SQLOLEDB.1

Nope SQLNCLI will work against SQL2000 for sure I'd have to check if it
works against 7 but I think so.

>
> May be I can set this for user by looking at the value of
> SERVERPROPERTY('ProductVersion').
>
Not needed from a client perspective.

-Euan


.

Relevant Pages

  • Re: Zugriff mit VB 6 auf SQLEXPRESS 2005 - DB
    ... ODBC-Verbindung? ... Dann wirds auch ODBC und SQLNCLI nicht richten. ... Der SQLNCLI Treiber kann direkt als ADO Provider ... das muss zuvor über die SQL Server ...
    (microsoft.public.de.sqlserver)
  • Re: Query regarding Multiple parameter set using OLEDB
    ... I was not aware of the SQL Server issue. ... Is the same thing with SQLNCLI? ... using multiple parameter sets is an optmization in some databases, ... SQLNCLI to insert/update/delete data. ...
    (microsoft.public.data.oledb)
  • Re: OLEDB error with SQL 2005
    ... Same problem with SQLNCLI or with SQLOLEDB. ... is to pass all string as empty string instead of setting status flag to ... Source:Microsoft OLE DB Provider for SQL Server ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • SQL Server 2005 Native Client
    ... What would be the best data access client for SQL Server 2005 that support ... low-level components that need high performance. ... The SQLNCLI is a native, ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL and DNS
    ... cliconfig.exe is already on the client machine, with MDAC. ... Tibor Karaszi, SQL Server MVP ... In a pure DNS ...
    (microsoft.public.sqlserver.server)