>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.