Can the SQL Server Managament Studio connect to ODBC sources?

Hi,
Can the SQL Server Managament Studio connect to ODBC sources?
If so, how do you do it? I've not done much with ODBC before...
Thanks,
Alan
http://www.sadevelopment.com
Partition Boot Manager and Large Drive Tools utilities!SSMS does not use the ODBC API. However, you can connect to any SQL Server
via SSMS as long as you know the server name and login credentials. You can
get that information by viewing the properties of the existing SQL Server
ODBC data source or connection string.
Hope this helps.
Dan Guzman
SQL Server MVP
"Default User" <nospam38925@.forme.com> wrote in message
news:4623694e$0$23404$c3e8da3@.news.astraweb.com...
> Hi,
> Can the SQL Server Managament Studio connect to ODBC sources?
> If so, how do you do it? I've not done much with ODBC before...
> Thanks,
> Alan
> http://www.sadevelopment.com
> Partition Boot Manager and Large Drive Tools utilities!
>|||Hi Dan,

> SSMS does not use the ODBC API. However, you can connect to any SQL
> Server via SSMS as long as you know the server name and login credentials.
> You can get that information by viewing the properties of the existing SQL
> Server ODBC data source or connection string.
Too bad, I was hoping to connect to ODBC with it. Does anyone have any idea
what tool or tools I could use to connect and troubleshoot ODBC...
Alan
http://www.sadevelopment.com
Partition Boot Manager and Large Drive Tools utilities!|||Can you elaborate on what you mean by "connect and troubleshoot ODBC"? If
you are trying to test ODBC data source connectivity, the ODBC data source
setup has a button to test the connection.
Hope this helps.
Dan Guzman
SQL Server MVP
"Default User" <nospam38925@.forme.com> wrote in message
news:4623b9c6$0$873$c3e8da3@.news.astraweb.com...
> Hi Dan,
>
> Too bad, I was hoping to connect to ODBC with it. Does anyone have any
> idea what tool or tools I could use to connect and troubleshoot ODBC...
> Alan
> http://www.sadevelopment.com
> Partition Boot Manager and Large Drive Tools utilities!
>|||Hi,

> Can you elaborate on what you mean by "connect and troubleshoot ODBC"? If
> you are trying to test ODBC data source connectivity, the ODBC data source
> setup has a button to test the connection.
Yes, I'm looking for a tool that lets you connect to ODBC and use it much
the way the SQL management studio lets you connect to MSSQL...
Thanks,
Alan|||> Yes, I'm looking for a tool that lets you connect to ODBC and use it much
> the way the SQL management studio lets you connect to MSSQL...
So you need to query ODBC data sources other than Micosoft SQL Server? If
you need only SQL Server, I still don't understand why you have the ODBC
requirement.
Hope this helps.
Dan Guzman
SQL Server MVP
"Default User" <nospam38925@.forme.com> wrote in message
news:4627a5d7$0$4674$c3e8da3@.news.astraweb.com...
> Hi,
>
> Yes, I'm looking for a tool that lets you connect to ODBC and use it much
> the way the SQL management studio lets you connect to MSSQL...
> Thanks,
> Alan
>

Can the SQL Server Managament Studio connect to ODBC sources?

Hi,
Can the SQL Server Managament Studio connect to ODBC sources?
If so, how do you do it? I've not done much with ODBC before...
Thanks,
Alan
http://www.sadevelopment.com
Partition Boot Manager and Large Drive Tools utilities!
SSMS does not use the ODBC API. However, you can connect to any SQL Server
via SSMS as long as you know the server name and login credentials. You can
get that information by viewing the properties of the existing SQL Server
ODBC data source or connection string.
Hope this helps.
Dan Guzman
SQL Server MVP
"Default User" <nospam38925@.forme.com> wrote in message
news:4623694e$0$23404$c3e8da3@.news.astraweb.com...
> Hi,
> Can the SQL Server Managament Studio connect to ODBC sources?
> If so, how do you do it? I've not done much with ODBC before...
> Thanks,
> Alan
> http://www.sadevelopment.com
> Partition Boot Manager and Large Drive Tools utilities!
>
|||Hi Dan,

> SSMS does not use the ODBC API. However, you can connect to any SQL
> Server via SSMS as long as you know the server name and login credentials.
> You can get that information by viewing the properties of the existing SQL
> Server ODBC data source or connection string.
Too bad, I was hoping to connect to ODBC with it. Does anyone have any idea
what tool or tools I could use to connect and troubleshoot ODBC...
Alan
http://www.sadevelopment.com
Partition Boot Manager and Large Drive Tools utilities!
|||Can you elaborate on what you mean by "connect and troubleshoot ODBC"? If
you are trying to test ODBC data source connectivity, the ODBC data source
setup has a button to test the connection.
Hope this helps.
Dan Guzman
SQL Server MVP
"Default User" <nospam38925@.forme.com> wrote in message
news:4623b9c6$0$873$c3e8da3@.news.astraweb.com...
> Hi Dan,
>
> Too bad, I was hoping to connect to ODBC with it. Does anyone have any
> idea what tool or tools I could use to connect and troubleshoot ODBC...
> Alan
> http://www.sadevelopment.com
> Partition Boot Manager and Large Drive Tools utilities!
>
|||Hi,

> Can you elaborate on what you mean by "connect and troubleshoot ODBC"? If
> you are trying to test ODBC data source connectivity, the ODBC data source
> setup has a button to test the connection.
Yes, I'm looking for a tool that lets you connect to ODBC and use it much
the way the SQL management studio lets you connect to MSSQL...
Thanks,
Alan
|||> Yes, I'm looking for a tool that lets you connect to ODBC and use it much
> the way the SQL management studio lets you connect to MSSQL...
So you need to query ODBC data sources other than Micosoft SQL Server? If
you need only SQL Server, I still don't understand why you have the ODBC
requirement.
Hope this helps.
Dan Guzman
SQL Server MVP
"Default User" <nospam38925@.forme.com> wrote in message
news:4627a5d7$0$4674$c3e8da3@.news.astraweb.com...
> Hi,
>
> Yes, I'm looking for a tool that lets you connect to ODBC and use it much
> the way the SQL management studio lets you connect to MSSQL...
> Thanks,
> Alan
>

Can the SQL Server Managament Studio connect to ODBC sources?

Hi,
Can the SQL Server Managament Studio connect to ODBC sources?
If so, how do you do it? I've not done much with ODBC before...
Thanks,
Alan
http://www.sadevelopment.com
Partition Boot Manager and Large Drive Tools utilities!SSMS does not use the ODBC API. However, you can connect to any SQL Server
via SSMS as long as you know the server name and login credentials. You can
get that information by viewing the properties of the existing SQL Server
ODBC data source or connection string.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Default User" <nospam38925@.forme.com> wrote in message
news:4623694e$0$23404$c3e8da3@.news.astraweb.com...
> Hi,
> Can the SQL Server Managament Studio connect to ODBC sources?
> If so, how do you do it? I've not done much with ODBC before...
> Thanks,
> Alan
> http://www.sadevelopment.com
> Partition Boot Manager and Large Drive Tools utilities!
>|||Hi Dan,
> SSMS does not use the ODBC API. However, you can connect to any SQL
> Server via SSMS as long as you know the server name and login credentials.
> You can get that information by viewing the properties of the existing SQL
> Server ODBC data source or connection string.
Too bad, I was hoping to connect to ODBC with it. Does anyone have any idea
what tool or tools I could use to connect and troubleshoot ODBC...
Alan
http://www.sadevelopment.com
Partition Boot Manager and Large Drive Tools utilities!|||Can you elaborate on what you mean by "connect and troubleshoot ODBC"? If
you are trying to test ODBC data source connectivity, the ODBC data source
setup has a button to test the connection.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Default User" <nospam38925@.forme.com> wrote in message
news:4623b9c6$0$873$c3e8da3@.news.astraweb.com...
> Hi Dan,
>> SSMS does not use the ODBC API. However, you can connect to any SQL
>> Server via SSMS as long as you know the server name and login
>> credentials. You can get that information by viewing the properties of
>> the existing SQL Server ODBC data source or connection string.
> Too bad, I was hoping to connect to ODBC with it. Does anyone have any
> idea what tool or tools I could use to connect and troubleshoot ODBC...
> Alan
> http://www.sadevelopment.com
> Partition Boot Manager and Large Drive Tools utilities!
>|||Hi,
> Can you elaborate on what you mean by "connect and troubleshoot ODBC"? If
> you are trying to test ODBC data source connectivity, the ODBC data source
> setup has a button to test the connection.
Yes, I'm looking for a tool that lets you connect to ODBC and use it much
the way the SQL management studio lets you connect to MSSQL...
Thanks,
Alan|||> Yes, I'm looking for a tool that lets you connect to ODBC and use it much
> the way the SQL management studio lets you connect to MSSQL...
So you need to query ODBC data sources other than Micosoft SQL Server? If
you need only SQL Server, I still don't understand why you have the ODBC
requirement.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Default User" <nospam38925@.forme.com> wrote in message
news:4627a5d7$0$4674$c3e8da3@.news.astraweb.com...
> Hi,
>> Can you elaborate on what you mean by "connect and troubleshoot ODBC"?
>> If you are trying to test ODBC data source connectivity, the ODBC data
>> source setup has a button to test the connection.
> Yes, I'm looking for a tool that lets you connect to ODBC and use it much
> the way the SQL management studio lets you connect to MSSQL...
> Thanks,
> Alan
>

Can SQL Server 2005 using C# make a SOAP call do set operations?

We have two remote data sources that we will access via a SOAP call.
But then we need to operate on the two sets (remove dups, etc.) and,
ideally, return a SQL result set to the client app.
So questions:
* Can we make a SOAP call using C# from within SQL Server?
* Can SQL Server operate on the resulting data (an XML record)?
* Can SQL Server return the combined results as a standard results set?
Thank youHello shp.jc,

> * Can we make a SOAP call using C# from within SQL Server?
Yes.

> * Can SQL Server operate on the resulting data (an XML record)?
Yes, but you'll probably want to do that with CLR code.

> * Can SQL Server return the combined results as a standard results
> set?
Yes, but recommend loading the data from the SOAP into a temp table and then
doing that work with T-SQL. Note that you can just have the Spoc or Function
turn an XML instance and query over that with Xquery.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/