Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ODBC Connectin from Microsoft SQL Server Management Studio Expand / Collapse
Author
Message
Posted Tuesday, March 4, 2008 4:11 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 29, 2009 9:39 AM
Points: 16, Visits: 52
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
Post #464141
Posted Wednesday, March 5, 2008 12:48 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 29, 2009 9:39 AM
Points: 16, Visits: 52
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')
Post #464697
Posted Thursday, September 22, 2011 9:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:30 PM
Points: 1, Visits: 73
Thank you so much! Saved me a ton of time :)
Post #1179519
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse