Post reply

Set up Linked Servers from SystemDSN ODBC problems

  • April 16, 2008 at 10:28 am

    #379981

    I am having trouble setting up a Linked Server for System DSNs I have on my system. I have a PostGreSQL DSN (called PostGreSQL) and a CSV file DSN (called CSV) and I am trying to add them as Linked servers in SQL 2005 Management Studio.

    Whenever I type in the DSN name 'PostGreSQL' under 'Data Source' and set the 'Provider' to 'Microsoft OLE DB Provider for ODBC drivers' I get an error saying

    'the data source is not found and no default driver specified' Error 7303

    This also happens when I try to set the CSV DSN as a Linked Server.

    What am I doing wrong? I have attached a screenshot showing what I am inputting.

  • April 17, 2008 at 8:19 am

    #803746

    Have you verified that the ODBC DSNs work? If you've got MS Access (or Excel) I think that's a good way to test the DSN.

  • April 17, 2008 at 9:56 am

    #803838

    I just figured it out, nevermind. I didn't set up the DSNs properly on the server I was logged into.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply