Here i have mention my connection string

i am using ADO db connection with DSN name,username, password

_RecordsetPtr pRs;

bstrSQLConnect += (LPCTSTR)m_DataSourceName;

bstrSQLConnect += (LPCTSTR)m_UserName;

bstrSQLConnect += (LPCTSTR)m_Password;

pRs->Open(bstrSQL, bstrSQLConnect, adOpenDynamic, adLockReadOnly,adCmdText);

Regards

Sudhan

Hi Gail Shaw

My SQLServer 2000 machine registry value for login mode =2

HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\LoginMode = 2

Then its SQL and Windows Authentication only, is it right?

But Same setup when i try to connect...

Thanks For your inforamtion.

Already In my Sql Server i am using Mixed Mode(Sql and Windows Authentication) only. Still i am getting same error.

Please provide solution for me.

Thanks

Sudhan