>Hello,
>
>I'm creating the connection to MS SQL server via SQLSTRINGCONNECT command.
>Can I create temporary remote view using that connection?
>
>Here is my code:
>

>lcConnString="Driver={SQL Server};Server=SERVER2\FBSQL;Database=TestDB;Uid=user;Pwd=password;"
>lhConnection = SQLSTRINGCONNECT(lcConnString)
>
>CREATE SQL VIEW vTest REMOTE CONNECTION lhConnection SHARE ;
>  AS SELECT * FROM Table1
>

>
>My task is to transfer a lot of data from DBF to SQL table. So, I will create remote view and... or (I just got idea) I can use CursorAdapter?

Yes you can. But I prefer to use CA instead of View. Also if this is only for transfer you could use SPT to do that.