Hi All,

Actually I found the error in the Connection String, I was typing "UserID" while I should type "User Id"

Thanks for you help.

this is the connection string I am using

Provider=%s;Server=%s;Database=%s;UserId=%s;Password=%s;

each %s is replaced by an equivalent value as the follwoing:

%s = SQLNCLI

%s = My Computer Name

%s = My Database Name

%s = Username

%s...

I don't think this is the case. But I believe SQL Server or ADO has decided to grant me access due to the Windows Authenticated user who is running the...