It’s been a few years and it wasn’t 2008.
But, as I remember it ….
Need client access installed on the server system — it contains ODBC driver
If you go to create a new data source you should see Client Access ODBC driver
I don’t remember any big issues creating a DTE or the like.
Oops – you’re already on to this.
You should be able to see any library the id you sign in with has authority to.
If you’re using a data source to link server
… the Data source default library is QGPL .. add your libraries in the server tab — library list
DTE will work. You should also be able to create views on Server of your tables.
Using client access transfer – it shows the libraries in your (the signed in id’s) library list when you browse. Want another library type any library your are authroized to mylib2/ followed by / and browse to see files. You can also just type the library/file