Pass thru query with DSN info.

  • Thread starter Thread starter BR
  • Start date Start date
B

BR

I would like to create a SQL pass thru query that can be run from multiple
workstations without having to create a DSN entry on each station. Is it
possible to embed the dsn info into the query? Is so examples would be
appreciated.
Thanks in advance for your help
 
Actually, DSN-less pass-through queries are easier than DSN-less linked
tables.

Simply plug the appropriate DSN-less connection string into the QueryDef's
ODBC Connect Str property. Note that you must use an ODBC DSN-less
connection string: Ole Db DSN-less connection strings will not work.

See Carl Prothman's site for the most comprehensive list of DSN-less
connection strings http://www.carlprothman.net/Default.aspx?tabid=81 (or,
since I said you must use ODBC DSN-less connection strings, go straight to
http://www.carlprothman.net/Default.aspx?tabid=90 )
 
Back
Top