SQL-Server use SSL to perform its encryption; so the use of encryption
requires that a valid certificate from a known CA authority exist on the
server and that the root certificate for this CA authority is already
installed on the client machine.
This is the same requirement has for HTTPS://; so if you cannot make a
connection with HTTPS on the server, then you cannot use encryption with
SQL-Server.
(There is one exception to this: the old Multiprotocol Net-Library for
SQL-Server offers support for its own encryption algorithm but I don't know
if this old protocol is still supported with SQL-2005 Express.)
The question with the native provider SQLNCLI is more interesting: can we
use with ADP? From your test, it appears that maybe we cannot use it with
ADP. However, all the advanced features of SQLNCLI are probably unavailable
under ADP, so there is no real advantage to use this provider under ADP.
If you want to use some of these features with ADP, you should open your own
ADO connection and access it with VBA code.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Gabriele Bertolucci" <info[ at ]REMOVEpbsoft.it> wrote in message
news:875ea355af2e8c80d015d2e52c0[ at ]news.virgilio.it...
[Quoted Text] > I'm using Access XP.
>
> May you tell me why, if I use the following connection string:
>
> "Provider=SQLNCLI;Server=mycomputer\sqlexpress;Database=databasename;UID=sa;PWD=sapassword;MarsConn=yes;Encrypt=yes"
>
> I continue to receive a "Specified SQL Server not found" error,
>
> while, if I use the following one:
>
> "Provider=SQLOLEDB.1;Persist Security Info=False;Data
> Source=mycomputer\sqlexpress;User ID=sa;Password=sapassword;Initial
> Catalog=databasename"
>
> it seems all ok?
>
> Obviously I tried also not to specify MARS and encryption parameters, but
> got same results.
> I tried also to specify ".\sqlexpress" as server name, but problem stays
> up.
>
> I hope you can help me.
>
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
>
>
|