hi friends
I have installed MSDE 2000 on WIN 98SE machine, The Service manager runs properly and connects as well but when i try to connect from VB6, it gives me error saying Invalid User Name / Password.
While installing i have given following command line parameter
setup SAPWD="AStrongSAPwd"
And following is the connection string i m using to connect:
cn.ConnectionString = _
"Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=127.0.0.1,1433;" & _
"Initial Catalog=MQIS;" & _
"User ID=sa;" & _
"Password=AStrongSAPwd"
cn.Open
but it says login failed for user SA
Please help me i need it really urgently...
REgards
GAzal
I have installed MSDE 2000 on WIN 98SE machine, The Service manager runs properly and connects as well but when i try to connect from VB6, it gives me error saying Invalid User Name / Password.
While installing i have given following command line parameter
setup SAPWD="AStrongSAPwd"
And following is the connection string i m using to connect:
cn.ConnectionString = _
"Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=127.0.0.1,1433;" & _
"Initial Catalog=MQIS;" & _
"User ID=sa;" & _
"Password=AStrongSAPwd"
cn.Open
but it says login failed for user SA
Please help me i need it really urgently...
REgards
GAzal