Geoff,
You can create such connection in your DB and use it for your remote views. When you create connection, select 'Connection string' and cut and paste connection string from your code (w/o ne wline characters and quotes).
>Hi Sergey
>
>I am even more confused now. Surely I dont want to keep creating the remote connection each time. Perhaps I should step back a bit.
>
>What I am trying to achieve is to use a remote view via a DSN-Less connection.
>
>Should I create a connection in my database and then access the views via that?
>
>I am at a bit of a loss as to how I should implement this as remote views are all a bit new to me. Could you give me an example of how I would do this to access a VisualFoxpro database?
>
>Regards
>Geoff Scott
>
>
>>Geoff,
>>
>>You cannot use connection handle created by SQLSTRINGCONNECT() or SQLCONNECT() in views in VFP7 and earlier. However, you can create connection to the remote source with connection string and use that connection for your views.
CREATE CONNECTION MyRemConn CONNSTRING lcConnStr
>>>Hi Sergey
>>>
--sb--