You can create DSN-less connections in your database and then use it in your views.

CREATE CONNECTION myconn CONNSTRING "DRIVER=sql server;SERVER=(local);UID=sa;PWD=;DATABASE=northwind"

On the other hand, you are right about connections created via SQLSTRINGCONNECT() -- they cannot be used in your remote views. You can only use them for SQL pass-through operations.



>Ok, I just started to use the MSDE and I installed it in a PC with Windows XP Professional.
>
>I have another machine with Windows 2000, and I’d like to connect to the SQL server on the XP machine.
>
>I already created a DSN on the machine with Win XP and MSDE.
>
>Now my newbie questions:
>
>Do I need to create a DSN on the client machine in order to connect to the SQL Server on the WinXP box?
>
>By looking at some samples at the fox.wiki.com, it looks like if you can execute sqlstringconnect in order to establish a connection to the DSN and start creating, modifying, etc. the SQLServer database without having to create a connection into a VFP database. However, the views should be created and I think it is here when database created connections are needed. Is it that the sqlstringconnect function is useful only to perform administration activities for the SQL connection and remote view should be created in order to access the data?
>
>Any advice about first steps tith MSDE, what to do next and how to do it will be very helpful for me.
>
>Thanks in advance.
>
>Oscar Corte