my code is using ADODB connection to connect to SQL (Virtual) Server.
the way it being done is (c++):
ADODB::_Connect ionPtr m_dbConn;
ADODB::_Records etPtr m_dbRst;
m_dbConn.Create Instance(__uuid of(ADODB::Conne ction));
m_dbRst.CreateI nstance( __uuidof( ADODB::Recordse t ));
m_dbConn->ConnectionStri ng=( L"DSN=mydsn" );
m_dbConn->Open("","sa"," ",-1);
lately after installing SP3 over SQL2000, it was impossible to connect
- the error message showed: login failed for user 'null)'. reason: not
associated with a trusted sql server connection.
so i changed the connection string to:
m_dbConn-> ConnectionStrin g =(L"DSN=mydsn; UID=sa; PWD=;");
m_dbConn->Open("",""," ",-1);
and now it works !!
what is the reason for that ?
what in sql SP3 interrupt for this kind of connection ?
what is the difference ?