SQLCONNECT([cConnectionName | cDataSourceName [, cUserID [, cPassword ]][, lShared]])
Understanding the syntax and Process will help.
gnHandle = SQLCONNECT(gcDSN,'MRPSA')
In the above code
gcDSN is your DSN and
MRPSA is your Username at initial.
Login Dialog box at login is displayed only when the username,password,connection name is wrong. which is forced displayed by ODBC engiene
When you supply new user name it directly sends it to server for authentication and authenticates and did not communicate to VFP.
Though this New username is not provided to VFP . The vfp is not aware of it and sends you the OLD Username .
I hope this explains.
Aashish
>Hi All,
>
>In My Application , i am using SQLCONNECT() to connect SQL SERVER Database.
>
>After successful connect , i am using SQLGETPROP (gnHandle,'UserId'), function returning unexpected value.
>
>eg.
>STEP -
>gnHandle = SQLCONNECT(gcDSN,'MRPSA')
>
>Displayed login dialog, then i change user name 'sa' and blank password. it executed properly.
>
>Then i use
>=SQLGETPROP(gnHandle,'UserID')
>It is giving 'MRPSA'
>Here i am expecting 'sa'???????????????????
>
>=SQLGETPROP(gnHandle,'Password')
>It is blank password.
>
>=SQLGETPROP(gnHandle,'ConnectString')
>It is giving proper valus as i expected.
>
>
>TIA
>Ajay Mishra