MS SQL Server ODBC - Connection string with a Select Statement

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Connection string with a Select Statement

Preacher Man

2006-03-10, 11:23 am

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

Sue Hoegemeier

2006-03-11, 1:23 pm

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?
>

Sponsored Links