[thelist] ASP-SQLServer: ADO vs. ODBC?

[Chris Houston.]

Pardon my listurbation in replying to myself, but in case anyone's
interested, I found the answer:

This doesn't work on my server:
> connstring = "DRIVER={SQLServer};SERVER=192.168.1.100;UID=sa;
> PWD=password;LANGUAGE=us_english;DATABASE=Databasename"

This does work on my server:
connstring = "provider=SQLOLEDB;SERVER=192.168.1.100;UID=sa;
PWD=password;LANGUAGE=us_english;DATABASE=Databasename"

Does anyone know why? I haven't a clue what the difference is.

Chris Houston.

Creative Director
Phosphors Intermedia.