ODBC Connectin from Microsoft SQL Server Management Studio

• durgapras

  Old Hand

  Points: 320

  More actions

  March 4, 2008 at 4:11 pm

  #379056

  Hi,

  I have created a DSN from the ODBC in Administrative tools.

  Is there a way I can connect to that DB from my Microsoft SQL Server Management Studio?

  FYI:The Provider for this DB does not exist in LinkedServer

  Thanks

• durgapras

  Old Hand

  Points: 320

  More actions

  March 5, 2008 at 12:48 pm

  #785719

  After little bit of 'googling',I could successfully connect to my ODBC

  1.)Exec sp_addlinkedserver

  EXEC sp_addlinkedserver

  @server = 'MY_ODBC_SERVER',

  @srvproduct = '',

  @provider = 'MSDASQL',

  @datasrc = 'QFTest' //System DSN

  GO

  2.)To check whether SP worked,

  EXEC sp_tables_ex @table_server = 'MY_ODBC_SERVER'

  3.)I could successfully retrieve all the data from the table 'BTL'

  SELECT * FROM OPENQUERY(MY_ODBC_SERVER, 'SELECT * FROM BTL')

• reehus

  SSC Rookie

  Points: 35

  More actions

  September 22, 2011 at 9:24 am

  #1385243

  Thank you so much! Saved me a ton of time 🙂