Hi Varun,
Basically when we are pulling data from linked server through SSMS/some
other client tools we may need to use query like this format
* linkedservername.databasename.schemaname.tablename* and in this case your
query like this,
table1 <- as.data.table(sqlQuery(dbhandle, 'select * from
l
This is not an R concept, and it may be highly specific to the SQL Server API
rather than the ODBC API. You might try doing as the Posting Guide recommends
and posting in the R-sig-db mailing list. I would also recommend that you
figure out from Microsoft documentation what programming API your
2 matches
Mail list logo
