I am trying to design a Syntax that imports data from a SQL Server.
This is no problem using a syntax created with the make new query functionality.
Only this always depends a DSN name/existing ODBC driver specific for a server/database.
I want to share this syntax with someone else without having to make the same ODBC driver on a different PC. This is because of flexible work stations.
I cannot find a way or example "/CONNECT=" string anywhere on the web. For a Access database this is not a problem.
Can you help me?