SQL Native Client Provider not installed on web servers?

The SQL Native Client provider does not appear to be installed on the webservers.

Using an ADO dsn-less connection string such as:

Provider=SQLNCLI;DataTypeCompatibility=80;Persist Security Info=True;User ID=<mylogin>;Initial Catalog=<mydb>;Data Source=sql2k501.discountasp.net;Password=<mypassword>;

Can you confirm that this is the case, and not something silly that I'm doing wrong?

I believe I can use SQLOLEDB, but I wanted to use the updated native client if possible.

Thanks,

andrew

 

Forgot to include the error message:

ADODB.Connection error '800a0e7a'

Provider cannot be found. It may not be properly installed.


When using the SQLOLEDB, everything works fine.

andrew

 

Okay, will do.

The reason I posted here first was just checking my assumptions that there isnt some reason they shouldnt be installed, or that I wasnt doing something dumb that I didnt see.

Thanks,

andrew