If the server is a Windows-based machine, begin the IP address or hostname with the "smb://" prefix. Click on the "Connect" button to initiate a connection.

I went back and changed the name of the SQL server from AppVolMgr\SQLEXPRESS to AppVolMgr (Figure 11); after doing so, I was able to select the View Composer database and successfully set up an ODBC ...

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

You can use RSPT to reduce network traffic and to shift CPU load by sending queries for remote data to a remote server. (If the server is a SAS/CONNECT single-user server you can also RSUBMIT queries ...