"fpsoft" <fpsoft1NOSPAM@hotmail.it> wrote in message
news:ercGPVvpHHA.4872@TK2MSFTNGP03.phx.gbl...
> In a Vb6 program i need to open a "read only" Sql Native Client Connection
> to a Sql2005 database.
>
> How can i do this? Is there something i can specify in the
> connectionstring? Actually i have found nothing.
>
> Note: i'm using SQLNCLI provider.
>
> Thanks.
>

> Hello,
>
> The easy way is create a SQL Server user with db_Datareader fixed database
> role and use it inside application.
>
> Thanks
> Hari
>
>
> "fpsoft" <fpsoft1NOSPAM@hotmail.it> wrote in message
> news:ercGPVvpHHA.4872@TK2MSFTNGP03.phx.gbl...
>> In a Vb6 program i need to open a "read only" Sql Native Client
>> Connection to a Sql2005 database.
>>
>> How can i do this? Is there something i can specify in the
>> connectionstring? Actually i have found nothing.
>>
>> Note: i'm using SQLNCLI provider.
>>
>> Thanks.
>>
>
>

"fpsoft" <fpsoft1NOSPAM@hotmail.it> wrote in message
news:OJUcZs0pHHA.3644@TK2MSFTNGP02.phx.gbl...
> In my case is not possible, i thought there was something in the
> connectionstring like "mode=read", but if i add this to the
> connectionstring it gives me an error.
>
>
> "Hari Prasad" <hari_prasad_k@hotmail.com> ha scritto nel messaggio
> news:%23E2butxpHHA.4032@TK2MSFTNGP02.phx.gbl...
>> Hello,
>>
>> The easy way is create a SQL Server user with db_Datareader fixed
>> database role and use it inside application.
>>
>> Thanks
>> Hari
>>
>>
>> "fpsoft" <fpsoft1NOSPAM@hotmail.it> wrote in message
>> news:ercGPVvpHHA.4872@TK2MSFTNGP03.phx.gbl...
>>> In a Vb6 program i need to open a "read only" Sql Native Client
>>> Connection to a Sql2005 database.
>>>
>>> How can i do this? Is there something i can specify in the
>>> connectionstring? Actually i have found nothing.
>>>
>>> Note: i'm using SQLNCLI provider.
>>>
>>> Thanks.
>>>
>>
>>
>
>