Unix Technical Forum

Connection string with a Select Statement

This is a discussion on Connection string with a Select Statement within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Is it possible to use and ODBC connection string within a Select Statement? If so what would the syntax ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 10:07 PM
Preacher Man
 
Posts: n/a
Default 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?


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 10:07 PM
Sue Hoegemeier
 
Posts: n/a
Default Re: Connection string with a Select Statement

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


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:57 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com