Provider parameter for OleDB connection string

[stevenjhill]

Hi, I guess this question has been done to death, and I'm sorry about asking this again - but I'm extending a contact management program I've made to support Sage Line 50 in C#.

I'm using version SL50 v7, but I simple can't connect to the database using Microsoft's ODBC classes through the System DSN that is set up. The Connection String I have is:

"DSN=SageLine50v7;provider=sageline50v7;Server=Qsls1;Database=Stationery & Computer Mart UK;uid=anyone;pswd=password;"

I just cannot find anything that will work for the provider parameter - any help would be massively appreciated. Thanks.