Leemi
Wed Jun 22 13:40:12 CDT 2005
Hi Paul:
I am glad that helped. We don't have much on using app roles from SQL
Server in VFP. The issue simply does not come up much.
I have not worked with app roles very much. Therefore, I am now sure of
all their capabilities. Maybe someone else a tried this and can answer for
experience. If no one here has used them, I would post the question in the
VFP forum of www.universalthread.com.
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/
*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
>It seems to be possible to use application roles only with SPT and not to
>create a connection for remote views. Is that correct?
>"Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
>news:5sjI4pqdFHA.2656@TK2MSFTNGXA01.phx.gbl...
> Hi Paul:
>
> Have you looked at this article to see if the code is useful?
>
>
http://support.microsoft.com/default.aspx?scid=KB;EN-US;243053
>
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
>
http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
>
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
>
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>
>>I need to be able to connect to a remote instance of SQL Server using an
>>application role rather than a user login. Can anyone help with the
>>connection string?