Connection string with a Select Statement

Is it possible to use and ODBC connection string within a Select Statement?
If so what would the syntax be?
You can use something like Openrowset with the OLE DB
provider for ODBC. You can find examples and more
information in books online under Openrowset.
-Sue
On Fri, 10 Mar 2006 11:19:38 -0600, "Preacher Man" <nospam>
wrote:

>Is it possible to use and ODBC connection string within a Select Statement?
>If so what would the syntax be?
>

Connection string with a Select Statement

Is it possible to use and ODBC connection string within a Select Statement?
If so what would the syntax be?
You can use something like Openrowset with the OLE DB
provider for ODBC. You can find examples and more
information in books online under Openrowset.
-Sue
On Fri, 10 Mar 2006 11:19:38 -0600, "Preacher Man" <nospam>
wrote:

>Is it possible to use and ODBC connection string within a Select Statement?
>If so what would the syntax be?
>

Connection string with a Select Statement

Is it possible to use and ODBC connection string within a Select Statement?
If so what would the syntax be?You can use something like Openrowset with the OLE DB
provider for ODBC. You can find examples and more
information in books online under Openrowset.
-Sue
On Fri, 10 Mar 2006 11:19:38 -0600, "Preacher Man" <nospam>
wrote:

>Is it possible to use and ODBC connection string within a Select Statement?
>If so what would the syntax be?
>