You check "Connect to SQL server to obtain..." in DSN configuration?
MartinJ
>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