|
Home > Archive > Microsoft SQL Server forum > July 2005 > ADODB connection with SQL2000SP3
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ADODB connection with SQL2000SP3
|
|
|
| my code is using ADODB connection to connect to SQL (Virtual) Server.
the way it being done is (c++):
ADODB::_ConnectionPt
r m_dbConn;
ADODB::_RecordsetPtr
m_dbRst;
m_dbConn. CreateInstance(__uui
dof(ADODB::Connectio
n));
m_dbRst.CreateInstance( __uuidof( ADODB::Recordset ));
m_dbConn->ConnectionString=( 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-> ConnectionString =(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 ?
| |
| Erland Sommarskog 2005-07-21, 8:24 pm |
| liorh (liorhal@gmail.com) writes:
> my code is using ADODB connection to connect to SQL (Virtual) Server.
>
> the way it being done is (c++):
>
> ADODB::_ConnectionPt
r m_dbConn;
> ADODB::_RecordsetPtr
m_dbRst;
> m_dbConn. CreateInstance(__uui
dof(ADODB::Connectio
n));
> m_dbRst.CreateInstance( __uuidof( ADODB::Recordset ));
> m_dbConn->ConnectionString=( 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-> ConnectionString =(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 ?
Since I don't know what is in that DSN, I would have to guess a bit.
Then again, I never liked DSNs. Anyway, my guess is that since SP3
was very focused on security, it may be that since you did not provide
a password, there is now a default for Windows authentication.
Anyway, running a system with a blank password for 'sa' is extremely
poor practice. So is it for that matter, to use sa to connect to SQL
Server from an application.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
|
|
|
|
|