MSDE Password... 1

[gazal]

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

 

[blweb]

If you try a different UID and password what does it give you? If it lets you in, then MSDE is looking at the UID and password for SA incorrectly.

Does the machine have Query Analyser or something equivalent on it? If so you can try logging on with it to make sure the UID and PW for SA works right.

otherwise, I'd use a connection string as follows

g_sConnStg = "Provider=MSDASQL.1;" _
                        & "Driver={SQL Server};" _
                        & "server=" & sSrvrName & ";" _
                        & "Database=" & PROJ_DB_Name & ";" _
                        & "uid=;" _
                        & "pwd="

Cheers,
Blweb

 

[gazal]

hi BLEWB

When i tried ur suggestion it says Not associated with Trusted Connection....

So sad....
Please help me........

Gazal

 

[blweb]

I pulled this one from

http://www.connectionstrings.com.

"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"

then all you'll have to do is write your open statement as follows.

.open, <UID>, <PW>

If that doesn't work then referr to my first 2 questions I posted.


Cheers,
Blweb

 

[gazal]

No use
No Success yet

Where are u all MSDE Guru's Common man,

Please its really urgent

Gazal

 

[mmilan]

Try setting up an ODBC DSN on your machine - that should tell you whether or not you are using the correct password.

Also try a blank password - you're reassignment of the password could have failed.

mmilan

 

[williamu]

Hi I hacked this out of an ASP web page:

Dim adoConn, adoRec, adoCmd, strConn, nRecs
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb"
Set adoConn = Server.CreateObject("ADODB.Connection")
Set adoCmd = Server.CreateObject("ADODB.Command")
adoCmd.CommandType = adCmdStoredProc
adoCmd.CommandText = "SelectEvent"
adoConn.Open strConn
adoCmd.ActiveConnection = adoConn
adoCmd.Parameters.Append adoCmd.CreateParameter ("@pUID", adInteger, adParamInput, , Request.Form("currRec"))

And I know this works, but the principal is the same.

HTH


William
Software Engineer
ICQ No. 56047340

 

[strongm]

Might I suggest

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322336

I'd focus on the authentication mode stuff in that article

 

[gazal]

hi thanks for ur responses

i have checked Strongm's link and i hope that should solve the problem but still have to check will get back to u guys once i check it...

Regards

Gazak