Microsoft OLE DB provider for SQL Server not available

I have just written screeds to explain this very frustrating problem and the system didn't accept my login so here goes again.

I am using codecharge studio to develop a web application and am having huge problems with making a connection to an SQL database. The problem occurs with the connection string builder. I have tried other providers e.g. to an Access database and they all work. The provider causing grief is Microsft OLE DB Provider for SQL Server. the error message is that the provider is no longer available.

I ran the DEPENDS utility and it would appear to be related to a file called MSDART.DLL, which caused me a heap of grief the other night and I thought I had resolved it by reinstallind MDAC 2.8 but this is not the case.

I cannot afford to do a total system reinstall as I simply do not have the time and I will end up losing a heap of work so need to resolve it some other method.

I am desperate to get it solved as I have the opportunity of doing a contract which will give some much needed funds as I have been without income for over 8 weeks as well.

Cheers Lesley

post the connectionstring.