Hi Ajay,

- Run "Control Panel"
- Click to "Administrative tools"
- Click to "Data Source (ODBC)"
- Find your DSn in User or System DSN
- Click to "Configure"
- After open window "Microsoft SQL Server DSN configuration" click to "Next"

Is checkbox "Connect to SQL server to obtain..." check[x] or uncheck[ ]?

MartinJ

>Hello MartinJ,
>
>It is not clear to me.
>Please explain in Detail.
>
>
>Ajay Mishra
>
>>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