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
>