Connect to system DSN with SQL Server 2005

[RollingMoose]

As someone who isn't overly literate with SQL Server 2005, this might be a simple question.

Is there a way to create a linked server to an ODBC connection that is on a PC as a system DSN?

I have a number of system DSNs, system data sources, on my PC. I'd like to reference these from within SQL Server 2005 to link to all of the data that these provide. Any suggestions or pointers?

 

[mrdenny]

Linked servers are typically setup seperate from the system DSNs. You are better off creating them on thier own. Take a look in Books OnLine under Linked Servers. There is a lot of information in there about setting them up.

What kinds of databases are the destination database servers?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[RollingMoose]

Denny, thanks for the quick reply.

They are DB2, Access, and Sybase.

 

[mrdenny]

You should be able to create direct OLEDB or ODBC linked servers to those data sources without using DSNs. (I know for a fact that you can with Access, 99% sure about the other two.)

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog